Question

pleasw reply fast for a thumbs up??

Question 3 (1 point) Absolute Error Percent error Squared error Naive Period Sales($millions) Forecast Error 13.2 2 19.3 3 14.9 4 11.5 Using the Naive forecast, what will be the MAD (Mean Absolute Deviation) in the table above? (Round your answer to 2 decimal places) Your Answer: Answer

Answer 1

Question 3

MAD = 4.63

A B C D E F G H 1 Sales error Absolute error Squared error Abs percent error 2 Period 3 forecast 13.2 1 4 2 19.3 13.2 6.1 -4.4 6.1 4.4 5 3 14.9 19.3 6 4 11.5 14.9 -3.4 3.4 7 8 MAD 4.63 9

Formula

A B с D E F G Sales forecast error Absolute error Squared error Abs percent error 1 2 Period 3 1 4 2 5 3 64 7 13.2 19.3 14.9 11.5 =B3 =B4 =B4-C4 =B5-C5 =B6-C6 =ABS(D4) =ABS(D5) =ABS(D6) =B5 8 MAD =ROUND(AVERAGE(E4:56), 2)

Question 4

Absolute percent error for period 4 = 62.05%

U A B D E F G H 1 Sales forecast error Absolute error Squared error Abs percent error 1 4.5 2 Period 3 4. 5 2 6.5 3 3.8 6 4 13 4.933333 8.066667 8.066666667 65.07111111 62.05 7 5 7.233333333 52.32111111 15 7.766667 7.233333 12 10.6 1.4 8 6 1.4 1.96 9 7

Formula

A B D E G 1 Sales forecast error Absolute error Squared error Abs percent error 4.5 2 Period 3 1 42 5 3 6 4 6.5 3.8 13 15 12 =ROUND((E6/B6) *100,2) FAVERAGE(B3:35) FAVERAGE(B4:36) FAVERAGE(B5:37) =B6-C6 =B7-C7 7 5 =ABS(D6) =ABS(D7) =ABS(D8) =E6^2 =E742 =E8^2 8 6 =B8-C8 9 7