The actual values for 12 periods (shown in order) are: 45 52 48 59 55 54 64 58 6

ID: 3059674 • Letter: T

Question

The actual values for 12 periods (shown in order) are: 45 52 48 59 55 54 64 58 67 66 70 76

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 forecasts for period 6-12, what is the lowest MAD value for any of the methods?

1) Using a 5 period simple moving average, the forecast for period 13 will be

F6= (45 +52+ 48+ 59+ 55 )/5 =

F7= (52 +48+ 59+55+54)/5 = 53.6

Similarly for F13

F13= (58+67+66+70+76)/5

F13= 67.4

PLEASE NOTE: PLAESE REPOST THE REST QUESTION ALONG WITH WEIGHTS OF WEIGHTED MOVING AVERAGE ALSO THE VALUE OF ALPHA FOR EXPOINENTIAL SMOOTHING.

PERIOD ACTUAL VALUE FORECASTED VALUE 1 45 2 52 3 48 4 59 5 55 6 54 51.8 7 64 53.6 8 58 56 9 67 58 10 66 59.6 11 70 61.8 12 76 65 13 67.4

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.