Question: Can you help solve this using excel, and give me step by step instructions on how you put it into excel please? The following data

Can you help solve this using excel, and give me step by step instructions on how you put it into excel please?
The following data relate the sales figures of the bar in Mark Kaltenbach's small bed-and-breakfast inn in Portland, to the number of guests registered that week:
a) The simple linear regression equation that relates bar sales to number of guests (not to time) is (round your responses to one decimal place):
Bar Sales =+ guests
 Can you help solve this using excel, and give me step

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!