Need answers to 2,3,5,6!!!!! Please!!!!!! by tonight!!!! Instructions:Question 1

Question

Need answers to 2,3,5,6!!!!! Please!!!!!! by tonight!!!!

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 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.

QUESTION 1 The actual values for 12 periods (shown in order) are: (1) 45 (2) 52 (3) 48 (4) 59 (5) 55 (6) 55 (7) 64 (8) 58 (9) 73 (10) 66 (11) 66 (12) 74 Using a 5 period simple moving average, the forecast for period 13 will be: 64.7

QUESTION 2 Using the 4 period weighted moving average, the forecast for period 13 will be:

QUESTION 3 With exponential smoothing, the forecast for period 13 will be:

QUESTION 4 With linear regression, the forecast for period 13 will be: 74.5607

QUESTION 5 With quadratic regression, the forecast for period 13 will be:

QUESTION 6 Considering only the forecasts for period 6-12, what is the lowest MAD value for any of the methods? I NEED THIS ANSWER THE MOST!

Explanation / Answer

QUESTION 2 : 71.25

QUESTION 3 : 62.5

QUESTION 5: 73.98

QUESTION 6:

MAD for exponential: 8.51

MADmad for 4 period moving average: 5.21

MAD for regrssion: 3.86

Regression method has the lowest mad value: 3.86

[[Values are calcu;ated in excel, sp if you need the calculation just inform me, i will give]]

Related Questions

Navigate

• Browse (All)
• Browse N
• Subjects

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