1. The managers of the Ada Hotel forecast the breakfast covers based on number of guest...

50.1K

Verified Solution

Question

General Management

1. The managers of the Ada Hotel forecast the breakfast coversbased on number of guest rooms. Following table presents the numberof rooms sold and breakfast covers for the past year, 2017.
Room Guests Breakfast Covers
January 1,200 1,400
February 1,020 1,220
March 1,250 1,420
April 1,100 1,320
May 1,380 1,520
June 1,400 1,580
July 1,520 1,650
August 1,550 1,690
September 1,450 1,400
October 1,210 1,380
November 1,080 1,240
December 1,050 1,220
Required:
1. Determine the coefficient of correlation and coefficient ofdetermination for the Ada Hotel based on the data presented above.Comment on the strength of the relationship between room guests andbreakfast covers.
2. Determine a regression equation for forecasting breakfastcovers based on the number of room guests.
3. If 1,620 room guests are forecasted for next January, howmany breakfast customers are forecasted to be served?
Note: You need to use MS Excel’s regression function to answerthese questions. Please attach your regression output (SummaryOutput) to your submission.

Answer & Explanation Solved by verified expert

3.9 Ratings (460 Votes)

Here Y Breakfast Cover is the dependent Varialbe X Room Guests is independent variable Put the data in X Y Column in Excel go to data Tab click data Analysis select XY input range select the plot you will get following output SUMMARY OUTPUT Regression See Answer

Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:

Unlimited Question Access with detailed Answers
Zin AI - 3 Million Words
10 Dall-E 3 Images
20 Plot Generations
Conversation with Dialogue Memory
No Ads, Ever!
Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!

Become a Member