Chapter $4$ ICA

$*$all graded items are underlined in the instructions text box and yellow in the worksheet

Your Name

Kamryn Reaves

Instructions:

In cell B$3,$ enter your full name.

Problem:

Jamal Smith, the owner of Lobster Tail in Portland, ME$,$ is trying to predict what lobster sales will be for the following year, Year $5.$ The data below relates the sales figures of lobsters sold for each previous year. Jamal is wanting to use Trend Projection as the forecasting method.

In cell G$17,$ use a function to find the slope of the model.

In cell G$18,$ use a function to find the intercept of the model.

In cell G$21,$ use a formula to calculate what the Lobsters Sold in Year $5$ would be using the Trend Projection Forecasting technique.

Note: Ensure you are using the slope in G$17$ and the intercept from G$18.$ Also use the Forecasted Lobsters Sold in Year $5$ provided in $H20$ as $"x"$ in this formula.

$\backslash$table$[[$Year$,$Lobster Sales$],[1,1,478],[2,1,700],[3,2,108],[4,2,592]]$

$\backslash$table$[[$Slope$],[$Intercept$]]$

$\backslash$table$[[$Year $,5$