Question

forecast. Is it better than the simple exponential smoothing forecasts? Comment on the underestimation or overestimation using suitable measure. Plot the errors and MPE for Holt's model. Does it look nearly stationary? For the data below (Production =Y in million tons) plot the data and comment whether you see a seasonal pattern. Perform Holt-Winters' seasonal forecast using alpha =0.4, beta =0.6 and gamma =0.8. Make forecasts for 2018-q1 and 2018-q2 using Holt-Winters' model. Calculate the errors and MSE and RMSE. Plot the errors and comment on the plot. Must show your work, answer all parts of the question, show all relevant graphs, and write necessary explanations to earn full points. Three components of your answer- accuracy and completeness of your calculations (numerical results); accuracy of relevant graphs; and accuracy and completeness of necessary explanations/interpretations/conclusions.You must use Excel to solve this numerical problem (project). The data below is for 25 periods of sales in Smillions. t Sales(Y) 1 70 2 75 3 08 4 84 5 77 6 85 7 100 8 92 9 95 10 98 11 93 12 110 13 125 14 120 15 112 16 128 17 135 18 142 19 145 20 140 21 150 22 155 23 163 24 170 25 165 forecast. Is it better than the simple exponential smoothing forecasts? Comment on the underestimation or overestimation using suitable measure. Plot the errors and MPE for Holt's model. Does it look nearly stationary? 3. For the data below (Production = Y in million tons) plot the data and comment whether you see a seasonal pattern. Perform Holt-Winters' seasonal forecast using alpha =0.4, beta =0.6 and gamma =0.8. Make forecasts for 2018-q1 and 2018-q2 using Holt-Winters model. Calculate the errors and MSE and RMSE. Plot the errors and comment on the plot. Year-q periodwt 2012-1 1 2012-2 2 2012-3 3 2012-4 4 2013-1 2013-2 6 2013-3 7 2013-4 8 2014-1 9 2014-2 10 2014-3 11 2014-4 12 2015-1 13 2015-2 14 2015-3 15 2015-4 16 2016-1 17 2016-2 18 2016-3 19 2016-4 20 2017-1 2 2017-2 22 2017-3 23 2017-4 24 2018-1 2018-2 65 s0 75 73 76 99 96 86 90 105 100 95 102 132 118 115 131 150 146 140 145 170 165 160 1. Plot the time series data. Forecast for the 26th period using simple exponential smoothing with alpha 0.4 and 0.7 and plot the actual 25 period values with forecasted values. Also calculate the errors (as well as MPEs) and plot the errors for the two forecasts. Compare the two forecasts using MSE and RMSE. Comment on the error plots (about stationarity). Do you see systematic underestimation? How do you measure it and visualize it? 2. With the data above, perform the forecast using Holt's two parameter model with alpha =0.5 and beta =0.6.Plot the Holt's forecast with actual values.Also calculate the MSE for Holt's 1

Name: forecast is it better than the simple exponential smoothing forecasts comment on the underestimation or overestimation using suitable measure plot the errors and mpe for holts model does it 77502
Uploaded: 2022-12-02T13:45:40-08:00
Duration: 1 min 32 s
Channel: Sri K
Description: forecast is it better than the simple exponential smoothing forecasts comment on the underestimation or overestimation using suitable measure plot the errors and mpe for holts model does it 77502

forecast. Is it better than the simple exponential smoothing forecasts? Comment on the
underestimation or overestimation using suitable measure. Plot the errors and MPE for Holt's
model. Does it look nearly stationary?
For the data below (Production =Y in million tons) plot the data and comment whether you
see a seasonal pattern. Perform Holt-Winters' seasonal forecast using alpha =0.4, beta =0.6 and
gamma =0.8. Make forecasts for 2018-q1 and 2018-q2 using Holt-Winters' model. Calculate
the errors and MSE and RMSE. Plot the errors and comment on the plot.
Must show your work, answer all parts of the question, show all relevant graphs, and write necessary explanations to earn full points. Three components of your answer- accuracy and completeness of your calculations (numerical results); accuracy of relevant graphs; and accuracy and completeness of necessary explanations/interpretations/conclusions.You must use Excel to solve this numerical problem (project). The data below is for 25 periods of sales in Smillions. t Sales(Y) 1 70 2 75 3 08 4 84 5 77 6 85 7 100 8 92 9 95 10 98 11 93 12 110 13 125 14 120 15 112 16 128 17 135 18 142 19 145 20 140 21 150 22 155 23 163 24 170 25 165
forecast. Is it better than the simple exponential smoothing forecasts? Comment on the underestimation or overestimation using suitable measure. Plot the errors and MPE for Holt's model. Does it look nearly stationary?
3. For the data below (Production = Y in million tons) plot the data and comment whether you see a seasonal pattern. Perform Holt-Winters' seasonal forecast using alpha =0.4, beta =0.6 and gamma =0.8. Make forecasts for 2018-q1 and 2018-q2 using Holt-Winters model. Calculate the errors and MSE and RMSE. Plot the errors and comment on the plot.
Year-q periodwt 2012-1 1 2012-2 2 2012-3 3 2012-4 4 2013-1 2013-2 6 2013-3 7 2013-4 8 2014-1 9 2014-2 10 2014-3 11 2014-4 12 2015-1 13 2015-2 14 2015-3 15 2015-4 16 2016-1 17 2016-2 18 2016-3 19 2016-4 20 2017-1 2 2017-2 22 2017-3 23 2017-4 24 2018-1 2018-2
65 s0 75 73 76 99 96 86 90 105 100 95 102 132 118 115 131 150 146 140 145 170 165 160
1. Plot the time series data. Forecast for the 26th period using simple exponential smoothing with alpha 0.4 and 0.7 and plot the actual 25 period values with forecasted values. Also calculate the errors (as well as MPEs) and plot the errors for the two forecasts. Compare the two forecasts using MSE and RMSE. Comment on the error plots (about stationarity). Do you see systematic underestimation? How do you measure it and visualize it?
2. With the data above, perform the forecast using Holt's two parameter model with alpha =0.5 and beta =0.6.Plot the Holt's forecast with actual values.Also calculate the MSE for Holt's
1

Added by Clarence C.

Question

Please give Ace some feedback