Explain what is the difference between a causal model and a time-series model? 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. Develop a weighted moving average mode solutionspile.com

Question

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.

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

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.

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

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

18 19 Table 2. Hale and Harty Trail Bikes sales

Accepted Answer

Expert Answer to -  Explain what is the difference between a causal model and a time-series model? Consider Table 1 in

Answer

Solution for -  Explain what is the difference between a causal model and a time-series model? Consider Table 1 in

Answer

This an additional answer to -  Explain what is the difference between a causal model and a time-series model? Consider Table 1 in

(Solved): Explain what is the difference between a causal model and a time-series model? Consider Table 1 in ...