StudentShare
Contact Us
Sign In / Sign Up for FREE
Search
Go to advanced search...
Free

Westar beverage - Statistics Project Example

Cite this document
Summary
Regression analysis, as a statistical tool, provides a basis for establishing relationships among variables. Such relationships can then be used make predictions subject to some…
Download full paper File format: .doc, available for editing
GRAB THE BEST PAPER97.3% of users find it useful
Westar beverage
Read Text Preview

Extract of sample "Westar beverage"

WESTAR BEVERAGE 17 February WESTAR BEVERAGE Forecasting is a statistical application that relies on existing numeric datafor predicting trends. Regression analysis, as a statistical tool, provides a basis for establishing relationships among variables. Such relationships can then be used make predictions subject to some expected assumptions. This paper seeks to offer a basis for predicting beverage sales for Westar hotel. The paper will use regression analysis to establish a model for predicting sales of the hotel’s beverage sales (Freund, Wilson, and Sa, 2006).

The sets of data used in the analysis corresponds to the hotel’s monthly sales for both pub and nightclub, sales for the club, sales for the pub, total expenditure for the hotel, expenditure for the nightclub, expenditure for the pub, and room occupancy in the hotel. Using excel, regression analysis generates the following tables with coefficients.Regression StatisticsMultiple R1R Square1Adjusted R Square0.954545Standard Error3.65E-13Observations28ANOVA table dfSSMSFSignificance FRegression66E+081E+089E+320Residual223E-241.

33E-25Total286E+08   Table of coefficients CoefficientsStandard Errort StatP-valueLower 95%Upper 95%Lower 95.0%Upper 95.0%Intercept-4E-121E-12-4.18660.0004-6E-12-2E-12-0-2E-12X Variable 117E-171.35E+1601111X Variable 212E-175.54E+1601111X Variable 32.1E-169E-160.2249240.8241-2E-152E-15-02E-15X Variable 40065535#NUM!0000X Variable 5-1E-169E-16-0.129620.898-2E-152E-15-02E-15X Variable 63.2E-171E-160.2727370.7876-2E-163E-16-03E-16From the regression statistics, the high value of adjusted R square indicates that the regression model explains a high percentage of the considered data, more than 95 %.

The model can therefore be used to predict beverage sales. The lower significance value from the ANOVA table, 0 relative to 0.05, also indicates that there exist significant relationship between beverage sales and the other variables. Further, the table of coefficients confirms that significant relationship exists between beverage sales and sales for the pub and sales for the nightclub. The significant model for forecasting beverage sales is therefore given by,Sales = x + y, Where x is the sales for pub and y is the sales from nightclub.

The other variables are not significantly related to beverage sales.ConclusionThe hotel’s volume of sales equally depends on its two branches, pub, and club. Research into forecasting should therefore be diversified to investigate factors affecting sales in the two branches of the hotel. ReferenceFreund, R., Wilson, W., and Sa, P. (2006). Regression analysis: statistical modeling of a response variable. London, UK: Academic Press

Read More
Cite this document
  • APA
  • MLA
  • CHICAGO
(“Westar beverage Statistics Project Example | Topics and Well Written Essays - 250 words”, n.d.)
Westar beverage Statistics Project Example | Topics and Well Written Essays - 250 words. Retrieved from https://studentshare.org/statistics/1589555-westar-beverage
(Westar Beverage Statistics Project Example | Topics and Well Written Essays - 250 Words)
Westar Beverage Statistics Project Example | Topics and Well Written Essays - 250 Words. https://studentshare.org/statistics/1589555-westar-beverage.
“Westar Beverage Statistics Project Example | Topics and Well Written Essays - 250 Words”, n.d. https://studentshare.org/statistics/1589555-westar-beverage.
  • Cited: 0 times

CHECK THESE SAMPLES OF Westar beverage

The Close Connection Between Identity and Security in US Foreign Policy

Course: Date: Some critics have claimed that the periods of the Cold War and detente were underpinned by the close connection between identity and security in US foreign policy.... Do you accept this claim?... Introduction During the Cold War era, US identity was characterized as individualism, voluntarism and democratic....
13 Pages (3250 words) Essay

The Investment Decision of an Analyst of a Company for Ethical Investment

The companies are Coca-Cola Amatil Limited, Qantas Airways Limited and Woolworths Limited; they are from different sectors like beverage, aviation and retailing industry respectively.... Finance and Accounting Table of Contents Executive Summary 3 Coca-Cola Amatil Limited 4 Qantas Airways Limited 5 Woolworths Limited 6 Financial Performance and Prospects 7 Corporate Governance Performance 9 Coca-Cola Amatil Limited 9 Qantas Airways Limited 9 Woolworths Limited 10 Environmental protection Credential 11 Coca-Cola Amatil Limited 11 Qantas Airways Limited 13 Woolworths Limited 14 Contextual factors 16 Conclusion 17 Reference List 18 Appendix -1 – Ratio Analysis of Coca- Cola Amatil Limited 20 Appendix -2– Ratio Analysis of Qantas Airways Limited 22 Appendix 3 – Ratio Analysis of Woolworths Limited 24 Executive Summary The report seeks to elaborate the investment decision of… an analyst of a company for Ethical investment....
13 Pages (3250 words) Essay

Concept of Design-Thinking for Coca-Cola Company

Free collaboration between the various departments in the company enhanced the development and marketing of Diet Coke in 1982 emerging as the bestselling low calorie beverage in the US within a very short period.... Name of Student: Lecturer: Date: Introduction Design thinking is the strategic approach applied by businesses to encourage innovativeness through the effective utilization of human resources....
8 Pages (2000 words) Essay

Peculiarities of Australian Media

This paper "Peculiarities of Australian Media" focuses on the fact that in recent years, Australian media lost its unique educational appeal from the sources of news and education to intertwinement media.... Traditionally, magazines have played an important role in American politics, education, etc....
7 Pages (1750 words) Article

Hedging Foreign Exchange Exposure

As each subsidiary would have different assets under their control so it would result in different depreciation expense.... This would need to be matched against the revenues arising… Qantas Ltd is responsible for the assets that are under the parent company use only and does not bear expense for subsidiaries assets....
2 Pages (500 words) Essay

Management Strategy and Decision Making

This paper describes critically analyze Qantas' internal and external environment and performance using the strategic management theory.... nbsp; Porter's five forces model and PEST analysis are employed in the paper so as to ascertain the company's strategic direction.... hellip; Thus, the strategic management theory is tied to the organization's overall performance and is mainly seen as a twofold process where managers seek to accomplish the task and satisfy the employees at the same time....
18 Pages (4500 words) Term Paper

Highway Engineering

This assignment "Highway Engineering" looks into the design of the Road, route 352 which is in Delaware County, Pennsylvania.... The starting coordinate is 39.... 15366, -75.... 24780 and the ending coordinate is 39.... 43339, -75.... 69283.... The intersection that we are concerned about is 39.... 17538, -75....
5 Pages (1250 words) Assignment

Effect of Temperature on Larvae Growth

… The paper "Effect of Temperature on Larvae Growth" is a good example of a lab report on science.... nbsp;This experiment aimed at investigating the relationship between larvae growth and temperature.... The various facts about forensic entomology have been discussed as a build-up to this experiment....
4 Pages (1000 words) Lab Report
sponsored ads
We use cookies to create the best experience for you. Keep on browsing if you are OK with that, or find out how to manage cookies.
Contact Us