Following data presents the number of rooms sold and number of breakfast customers of Ada Hotel....
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Following data presents the number of rooms sold and number of breakfast customers of Ada Hotel. Year 2019 2019 2019 2019 2019 2019 2019 2019 2019 2019 Month January February March April May June 2019 2019 July August September October November December # of Rooms Sold 18,828 17,896 20,506 19,574 22,557 22,184 21,438 22,370 21,997 # of Breakfast Customers 22,585 19,009 23,715 23,150 25,409 24,091 24,844 25,220 23,715 23,526 21,833 18,915 20,879 18,828 16,964 Task 1. Assume that Ada Hotel uses regression method for forecasting. The number of breakfast customers is forecasted based on number of rooms sold. a Run regression analysis on Excel to explore the relationship between number of rooms sold and number of breakfast customers. You need to use the "Regression" function in Excel under Data/Data Analysis/Regression to complete this task. Once you run the regression analysis, save the summary output from the regression analysis and construct the linear function in the form Y = Intercept + B*X, where Y equals number of breakfast customers, X is number of rooms sold and B is the change in number of breaksfast customers when number of rooms sold increases by one unit. (If you do not see Data Analysis in Data Tab, then that means you need to install Data Analysis Toolpak because it is an Add-In; it does not automatically come with Excel. Here is a tutorial on how to install Data Analysis Toolpak for Windows: https://www.youtube.com/watch?v=V60-IFnih3Q) b If 2,300 rooms are forecasted for January 2020, how many breakfast customers are forecasted to be served in January 2020? Use the linear function constructed in part a, to complete this question. Following data presents the number of rooms sold and number of breakfast customers of Ada Hotel. Year 2019 2019 2019 2019 2019 2019 2019 2019 2019 2019 Month January February March April May June 2019 2019 July August September October November December # of Rooms Sold 18,828 17,896 20,506 19,574 22,557 22,184 21,438 22,370 21,997 # of Breakfast Customers 22,585 19,009 23,715 23,150 25,409 24,091 24,844 25,220 23,715 23,526 21,833 18,915 20,879 18,828 16,964 Task 1. Assume that Ada Hotel uses regression method for forecasting. The number of breakfast customers is forecasted based on number of rooms sold. a Run regression analysis on Excel to explore the relationship between number of rooms sold and number of breakfast customers. You need to use the "Regression" function in Excel under Data/Data Analysis/Regression to complete this task. Once you run the regression analysis, save the summary output from the regression analysis and construct the linear function in the form Y = Intercept + B*X, where Y equals number of breakfast customers, X is number of rooms sold and B is the change in number of breaksfast customers when number of rooms sold increases by one unit. (If you do not see Data Analysis in Data Tab, then that means you need to install Data Analysis Toolpak because it is an Add-In; it does not automatically come with Excel. Here is a tutorial on how to install Data Analysis Toolpak for Windows: https://www.youtube.com/watch?v=V60-IFnih3Q) b If 2,300 rooms are forecasted for January 2020, how many breakfast customers are forecasted to be served in January 2020? Use the linear function constructed in part a, to complete this question.
Expert Answer:
Answer rating: 100% (QA)
X Y Year Month of Rooms Sold of Breakfast Customers 2019 January 18828 22585 2019 February 17896 190... View the full answer
Related Book For
Posted Date:
Students also viewed these accounting questions
-
The following table presents the number of students absent in a middle school in northwestern Montana for each school day in January 2008. a. Construct a box plot. b. There was a snowstorm on January...
-
The probability histogram represents the number of rooms in rented housing units in 2009. (a) What is the probability that a randomly selected rental unit has ï¬ve rooms? (b) What is the...
-
Estimated sales January February March April May Total Coffee sales (units) 15,000 16,000 18,000 17,500 14,500 Your friend, Chris Coffee, has been running a successful coffee shop for the last couple...
-
1. Give 3 examples of well-defined sets. 2. Name two subsets of the set of whole numbers using both the listing method and the rule method. 3. Let B [1, 3, 5, 7, 9}. List all the possible subsets of...
-
The company started business on January 1, 2006. Net income and dividends for the first three years of the companys existence are as follows: The company has some foreign subsidiaries and also...
-
Consider the world market for a particular quality of coffee beans. The following table shows the demand and supply schedules for this market. a. Plot the demand and supply schedules on a diagram. b....
-
Consider the system \[\begin{aligned} x^{\prime} & =-y+x\left[\mu-x^{2}-y^{2} ight] \\ y^{\prime} & =x+y\left[\mu-x^{2}-y^{2} ight] \end{aligned}\] Rewrite this system in polar form. Look at the...
-
GrowMaster Products, a rapidly growing distributor of home gardening equipment, is formulating its plans for the coming year. Carol Jones, the firms marketing director, has completed the following...
-
A company purchased a machine on January 1 of the current year for $750,000. Calculate the annual depreciation expense for each year of the machine's life (estimated at 5 years or 20,000 hours, with...
-
The financial statements of Saturn plc have been prepared as follows: Further information: (a) Extract from statement of income 000 Operating profit.........................1,008 Dividend...
-
Here again is the histogram showing distribution of exam scores for 40 students in an elementary statistics course.
-
Given two zero-coupon bonds with the same face value, one with a time remaining to maturity of 25 years, and the other maturing in 10 years, which one will have a lower market price?
-
1. Describe how energy prices have varied over time and across geographic locations or across commodities. Are energy prices more volatile today than in the past? Is the outlook more or less...
-
Traylor Windows is a small company that installs windows. Its cost structure is asfollows: SELLING PRICE FROM EACH WINDOW INSTALLATION $800 VARIABLE COST OF EACH WINDOW INSTALLATION $700 ANNUAL FIXED...
-
(5%) Problem 3: Cranes use a system of two pulleys to provide mechanical advantage, which reduces the force they need to apply to lift a particular weight (two such possible configurations are shown...
-
You should aim to have 7-10 distinct sources. Remember to ask questions about your sources. Tips Remember to ask questions about your sources . For example: Who is the author? Is there a bias...
-
WHAT does "consent" mean with regard to human sexual activity? Is consent implied, meaning that if a participant (usually female) does not specifically say "Yes, I want to have sex with you," she...
-
The packaging division of a company having considered several alternative package designs for the company's new product has finally brought down their choices to two designs of which only one has to...
-
V. Tangpricha et al. conducted a study to determine whether fortifying orange juice with vitamin D would increase serum 25-hydroxyvitamin D [25(OH)D] concentration in the blood. The researchers...
-
Repeat parts (b)(e) of Exercise 7.17 for samples of size 3. (There are 20 possible samples.) b. For samples of size 2, construct a table similar to Table 7.2. (There are 15 possible samples of size...
-
The data from Exercise 14.35 for average high and low temperatures in January for a random sample of 50 cities are on the WeissStats CD. a. Decide whether you can reasonably apply the regression...
-
Matt Lehti owns the Zap Record Shop. He is in the process of examining the following performance report: Matt is very pleased that the company had favorable variances for sales and income. However,...
-
Briefly explain intraperiod tax allocation.
-
For the first quarter of 2005, Philips Sales Corporation has budgeted sales of \($390,000\) and budgeted cost of goods sold of \($280,000.\) In addition, the budget for the first quarter of 2005...
Study smarter with the SolutionInn App