Quantitative Methods

I need answers/help on how to do these steps within Excel please, I don't need an explanation. I attached pictures of the given Excel spreadsheets.

1. Consider Table 1 in the workbook. Create a line chart of the demand time series. Clearly label the axes on the graph. Add a column to table 1 and develop a 3-year moving average model. Use the model to make a forecast for year 12.

2. Develop a weighted moving average model for the demand for fertilizer in year 12.

3. Develop a trend line for the demand for fertilizer for the data in Table 1. Use the Excel Data Analysis to estimate the slope and intercept for your trend line model. Add a column to Table 1 and populate it with the predicted values using your trend line equation. Make a forecast for year 12. Check your work by adding the trend line to the line chart you created in part 2 with the trend line equation showing on the graph.

4. Use either MAD or MSE to choose the best model for the data. Briefly explain your answer.

5. Consider Table 2. Using regression with the trend and seasonal components make a forecast for the 4 quarters of year 5.

1 Table 1. Demand for fertilizer at Wallace Garden Supply \begin{tabular}{|c|c|c|} \hline 2 & Year & Demandforfertilizer(1,000sofbags) \\ \hline 3 & 1 & 4 \\ \hline 4 & 2 & 6 \\ \hline 5 & 3 & 4 \\ \hline 6 & 4 & 5 \\ \hline 7 & 5 & 10 \\ \hline 8 & 6 & 8 \\ \hline 9 & 7 & 7 \\ \hline 10 & 8 & 9 \\ \hline 11 & 9 & 12 \\ \hline 12 & 10 & 14 \\ \hline 13 & 11 & 15 \\ \hline 14 & 12 & \\ \hline \end{tabular} 18 19 Table 2. Hale and Harty Trail Bikes sales