$\backslash$table$[[,$Jan,Feb,Mar,Apr,May,Jun,Jul,Aug,Sep,Oct$],[\backslash$table$[[$Cases$],[(1000$s$)]],128\mathrm{.}9,132\mathrm{.}4,116\mathrm{.}6,152\mathrm{.}4,152\mathrm{.}3,144\mathrm{.}5,157\mathrm{.}1,166\mathrm{.}2,150\mathrm{.}7,182\mathrm{.}3]]$

$\%$ Grade

Calculate a forecast for November based on a simple three$-$month moving

$(20\%)$

average.

Calculate a forecast for November based on a weighted moving average.

$(20\%)$

Use a weight factor of $50\%$ for the most recent month, $30\%$ two months ago, and $20\%$ three months ago.

This time, calculate a forecast for November based on exponential smoothing with $=0\mathrm{.}4$ and an October forecast $=153\mathrm{.}8$

$(20\%)$

Develop a simple linear regression model based on historical demand

$(20\%)$

data between January $-$ October.

Use Excel to develop a scatter plot of the historical data, with x$-$axis for time and $y-$axis for demand.

Display the linear trend line and linear regression equation on your chart. Identify the slope and y$-$intercept.

Copy your Excel chart with the regression equation and paste it into the file you are submitting in Canvas. $($Only submit one file in Canvas for all problems.$)$

Use your linear regression model from problem #$4$ to calculate demand

$(20\%)$

forecasts for the next two months $($November and December$).$ Show your calculation steps.