M$1$: y$^=1\mathrm{.}0356$t $+339\mathrm{.}29($from Mini Case C$1)$

M$2$: y$^=0\mathrm{.}7163$t$+116\mathrm{.}7679$w$+315\mathrm{.}0262($from Mini Case C$1)$

M$3$: y$^=$ b$0+$ b$1$x$1+$ b$2$x$2+$ b$3$x$3+$ b$4$x$4+$ b$5$x$5+$ b$6$x$6+$ b$7$t $($the current one$)$

to predict the demand for seven days ahead $($rows $58-64).$

Specifically,

$1.$ Redo the dummy variable calculatuions in columns F $-$ K $($DO NOT copy the values $-$ you must build the formulas again$).$

$2.$ Transfer the apprprate values into the M$3$ Coefficients table below $($DO NOT ROUND any numbers$).$

$3.$ Using M$1,$ M$2$ and M$3$ coefficients, calculate estimated demand values $($y$^\text{'}$s$)$ in columns L $-$ N

$4.$ Provide a line graph with the actual demand, along with the estimated values from M$2$ and M$3,$ from day $1$ to day $63.$ Note that there are no actual demand numbers for days $57-63($future$).$ Leave these cells empty. The graph needs to have a clear legend.

Note: Your graph should show three lines. DO NOT include M$1.$

Hint: Copying the actual demand numbers to column O may help you build the graph.