Using the Excel Insert Tab Line Graph and follow-up Chart Tools Tabs, construct an appropriate… 1 answer below »

a. 6 Points: Using the Excel Insert Tab Line Graph and follow-up Chart Tools Tabs, construct an appropriate line chart displaying the time pattern of order deliveries. Please create a professional appearing chart with labeling and titles. A legend is probably not needed. Move the chart so that it starts in cell H4 and fits within the red shaded area. Is the time pattern stationary? Yes or No in cell K3. b. 4 Points: In column C (starting in the appropriate cell), write a formula using a built-in Excel function to forecast demand through October using an MA(3) model. c. 4 Points: In column D (starting in the appropriate cell), write a formula using a built-in Excel function to forecast demand through October using an MA(5) model. d. 2 Points: In cell B17, write a formula using a built-in Excel function to forecast demand for November using the MA(3) model you constructed. e. 2 Points: In cell B18, write a formula using a built-in Excel function to forecast demand for November using the MA(5) model you constructed. f. 4 Points: In column E, under the label “MA(3) Error,” write a formula in the appropriate cells calculating the error terms necessary to calculate the MAE for the MA(3) model. Do not construct a column of errors, then another column of absolute, squared, or absolute relative errors. Construct only one set of errors using the appropriate formula to make the errors absolute, squared, or absolute relative (whichever is appropriate for MAE). 