Month: 1 Sales: 238 Month: 13 2 4 5 6 220 245 345 14 16 17...

 

Transcribed Image Text:

Month: 1 Sales: 238 Month: 13 2 4 5 6 220 245 345 14 16 17 Sales: 135 145 185 219 240 In 2020 and 2021, Al Murad company sold the following numbers of bycicles: 10 11 12 110 85 23 24 290 240 3 185 15 Assume that the forecast for month 1 is 200. C. 7 295 19 380 18 420 550 8 9 220 20 280 120 21 22 410 380 320 b. Using three other columns, compute the absolute error, the squared error, and the absolute percentage error. Using these results, find the MAD, MAPD, the mean squared error and bias E for the MA (4). Repeat parts (a) and (b) for eight-month moving averages. Which method, MA (4) or MA(8), was more accurate for these data? Month: 1 Sales: 238 Month: 13 2 4 5 6 220 245 345 14 16 17 Sales: 135 145 185 219 240 In 2020 and 2021, Al Murad company sold the following numbers of bycicles: 10 11 12 110 85 23 24 290 240 3 185 15 Assume that the forecast for month 1 is 200. C. 7 295 19 380 18 420 550 8 9 220 20 280 120 21 22 410 380 320 b. Using three other columns, compute the absolute error, the squared error, and the absolute percentage error. Using these results, find the MAD, MAPD, the mean squared error and bias E for the MA (4). Repeat parts (a) and (b) for eight-month moving averages. Which method, MA (4) or MA(8), was more accurate for these data?

Answer rating: 100% (QA)

Answer Using Excel Excel Formulas 1 34 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 ... View the full answer