Following data presents the number of rooms sold and number of breakfast customers of Ada Hotel....

 

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.

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