Name\ Dylan Bryant\ uctions:\ cell B3, enter your full name.\ lem:\ I 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 s of the bar to the number of guests registered that week. Jamal is wanting to use Linear Regression as the forecasting method.\ cell

H9

, use a function to find the slope of the model.\ cell

H10

, use a function to find the intercept of the model.\ cell

H21

, use a formula to calculate what the Bar Sales would be when there are 120 guests using the Associative Forecasting technique of Linear ession.\ Note: Ensure you are using the slope in

H9

and the intercept from

H10

. Also use the Number of Guests provided in

H21

as "

x

" in this formula.\ \\\\table[[Week,Guests,Bar Sales],[1,88,

$2,184

uctions: cell B3, enter your full name. em: 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 s of the bar to the number of guests registered that week. Jamal is wanting to use Linear Regression as the forecasting method. cell H9, use a function to find the slope of the model. cell H10, use a function to find the intercept of the model. cell H21, use a formula to calculate what the Bar Sales would be when there are 120 guests using the Associative Forecasting technique of Linear ession. Note: Ensure you are using the slope in H9 and the intercept from H10. Also use the Number of Guests provided in H21 as " x " in this formula. uctions: cell B3, enter your full name. em: 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 s of the bar to the number of guests registered that week. Jamal is wanting to use Linear Regression as the forecasting method. cell H9, use a function to find the slope of the model. cell H10, use a function to find the intercept of the model. cell H21, use a formula to calculate what the Bar Sales would be when there are 120 guests using the Associative Forecasting technique of Linear ession. Note: Ensure you are using the slope in H9 and the intercept from H10. Also use the Number of Guests provided in H21 as " x " in this formula