Answered step by step
Verified Expert Solution
Question
1 Approved Answer
I have no idea how to solve problem 2 Following data presents the number of rooms sold and number of breakfast customers of Ada Hotel.
I have no idea how to solve problem 2
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 2019 Month January February March April May June 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 20,879 18,828 16,964 # 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 2019 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-1Fnih3Q) 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 thisStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started