Question 1 contains the actual values for 12 periods (listed in order, 1-12). In

Question

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 following methods: 5 period simple moving average; 4 period weighted moving average (0.63, 0.26, 0.08, 0.03); exponential smoothing (alpha = 0.23 and the forecast for period 5 = 53); linear regression with the equation based on all 12 periods; and quadratic regression with the equation based on all 12 periods.  Round all numerical answers to two decimal places.

The actual values for 12 periods (shown in order) are:

(1) 45  (2) 52 (3) 48 (4) 59  (5) 55  (6) 58  (7) 64  (8) 61  (9) 71  (10) 66  (11) 69  (12) 7

question 6. Considering only the forecasts for period 6-12, what is the lowest MAD value for any of the methods?

Explanation / Answer

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 following methods: 5 period simple moving average; 4 period weighted moving average (0.63, 0.26, 0.08, 0.03); exponential smoothing (alpha = 0.23 and the forecast for period 5 = 53); linear regression with the equation based on all 12 periods; and quadratic regression with the equation based on all 12 periods.  Round all numerical answers to two decimal places.

The actual values for 12 periods (shown in order) are:

(1) 45  (2) 52 (3) 48 (4) 59  (5) 55  (6) 58  (7) 64  (8) 61  (9) 71  (10) 66  (11) 69  (12) 7

question 6. Considering only the forecasts for period 6-12, what is the lowest MAD value for any of the methods?

Related Questions

Navigate

• Browse (All)
• Browse Q
• Subjects

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