The actual values for 12 periods ( shown in order) are: 1-45 2-52 3-48 4-59 5-55
ID: 2931046 • Letter: T
Question
The actual values for 12 periods ( shown in order) are: 1-45 2-52 3-48 4-59 5-55 6-57 7-64 8-63 9-72 10-66 11-70 12-73Questions: 1) Using a 5 period simple moving average, the forecast for period 13 will be? 2) Using the 4 period weighted moving average, the forecast for period 13 will be? 3) With exponential smoothing, the forecast for period 13 will be? 4) With linear regression, the forecast for period 13 will be? 5) With quadratic regression, the forecast for period 13 will be? 6) Considering only the forecast for period 6-12, what is the lowest MAD value for any of the methods? The actual values for 12 periods ( shown in order) are: 1-45 2-52 3-48 4-59 5-55 6-57 7-64 8-63 9-72 10-66 11-70 12-73
Questions: 1) Using a 5 period simple moving average, the forecast for period 13 will be? 2) Using the 4 period weighted moving average, the forecast for period 13 will be? 3) With exponential smoothing, the forecast for period 13 will be? 4) With linear regression, the forecast for period 13 will be? 5) With quadratic regression, the forecast for period 13 will be? 6) Considering only the forecast for period 6-12, what is the lowest MAD value for any of the methods? 2-52 3-48 4-59 5-55 6-57 7-64 8-63 9-72 10-66 11-70 12-73
Questions: 1) Using a 5 period simple moving average, the forecast for period 13 will be? 2) Using the 4 period weighted moving average, the forecast for period 13 will be? 3) With exponential smoothing, the forecast for period 13 will be? 4) With linear regression, the forecast for period 13 will be? 5) With quadratic regression, the forecast for period 13 will be? 6) Considering only the forecast for period 6-12, what is the lowest MAD value for any of the methods?
Explanation / Answer
1. Using a 5 period simple moving average, the forecast for period 13 will be
The forecast for period 13 will be 68.8
Actual 5 Month Month Values Moving Average 1 45 - 2 52 - 3 48 - 4 59 - 5 55 - 6 57 51.8 7 64 54.2 8 63 56.6 9 72 59.6 10 66 62.2 11 70 64.4 12 73 67 13 68.8