Jamal Smith, the owner of Lobster Tail BnB in Portland, ME , is trying to predict what
Fantastic news! We've Found the answer you've been seeking!
Question:
Jamal Smith, the owner of Lobster Tail BnB in Portland, ME is trying to predict what bar sales will be for the following week. The data below relates the sales figures of the bar to the number of guests registered thatweek Jamal is wanting to use Linear Regression as the forecasting method.
In cell H use a function to find the slope of the model.
In cell H use a function to find the intercept of the model.
In cell H use a formula to calculate what the Bar Sales would be when there are guests using the Associative Forecasting technique of Linear Regression.
Note: Ensure you are using the slope in H and the intercept from H Also use the Number of Guests provided in H as x in this formula.
Related Book For
Data Analysis and Decision Making
ISBN: 978-0538476126
4th edition
Authors: Christian Albright, Wayne Winston, Christopher Zappe
Posted Date: