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 that$$week$.$ Jamal is wanting to use Linear Regression as the forecasting method.

$2)$ In cell H$9,$ use a function to find the slope of the model.

$3)$ In cell H$10,$ use a function to find the intercept of the model.

$4)$ In cell H$21,$ use a formula to calculate what the Bar Sales would be when there are $120$ guests using the Associative Forecasting technique of Linear Regression.

Note: Ensure you are using the slope in H$9$ and the intercept from H$10.$ Also use the Number of Guests provided in H$21$ as $"$x$"$ in this formula.