Instructions Question 1 contains the actual values for 12 periods (listed in ord

Question

Instructions Question 1 contains the actual values for 12 periods (listed in order, 1-12). In Excel, create forecasts for periods 6-13 using each of the simple moving average; 4 period weighted moving average (0.63, 0.26, 0.08, 0.03); exponential smoothing (alpha 0.23 and th regression with the equation based on all 12 periods; and quadratic regression with the equation based on all 12 periods. Roun decimal places. Multiple Attempts Force Completion Not allowed. This test can only be taken once. This test can be saved and resumed later Question Completion Status: QUESTION 1 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) 58 (9) 68 (10) 66 (11) 69 (12) 75 Using a 5 period simple moving average, the forecast for period 13 will be: 65 QUESTION 2 Using the 4 period weighted moving average, the forecast for period 13 will be: For the toolbar, press ALT+F10 (PC) or ALT+FN+F10 (Mac).

Explanation / Answer

Question 1:

The forecast of 13 is 67.2

Question 2:

The forecast of 13 is 72.51

Question 3:

The forecast of 13 is 65.19

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 58 56.6 9 68 58.6 10 66 60.4 11 69 62.6 12 75 65 13 67.2

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

---