Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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 this

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Accounting questions

Question

Relational Contexts in Organizations

Answered: 1 week ago