Question: Problem 3-20 (Algo) An analyst must decide between two different forecasting techniques for weekly sales of roller blades: a linear trend equation and the

Problem 3-20 (Algo) An analyst must decide between two different forecasting techniques for weekly sales of roller blades: a linear trend equation and the naive approach. The linear trend equation is F+ = 123 +1.8t, and it was developed using data from periods 1 through 10. Based on data for periods 11 through 20 as shown in the table, which of these two methods has the greater accuracy if MAD and MSE are used? (Round your intermediate calculations and final answers to 2 decimal places.) t Units Sold 11 143 12 146 13 152 14 142 15 154 16 152 17 155 18 155 19 159 20 165 Click here for the Excel Data File Answer is complete but not entirely correct. MAD (Naive) MAD (Linear) MSE (Naive) MSE (Linear) 5.11 2.72 12.92 39.33 Linear trend Answer is complete and correct. provides forecasts with less average error and less average squared error. Units t Sold LR forecast Absolute error squared error nave forecast absolute error squared error 11 143 142.8 0.2 0.04 12 146 144.6 1.4 1.96 143 3 9 13 152 146.4 5.6 31.36 146 6 36 14 142 148.2 6.2 38.44 152 10 100 15 154 150 4 16 142 12 144 16 152 151.8 0.2 0.04 154 2 4 17 155 153.6 1.4 1.96 152 3 9 18 155 155.4 0.4 0.16 155 0 0 19 159 157.2 1.8 3.24 155 4 16 20 165 159 6 36 159 6 36 2.72 12.92 5.11 39.33
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
