Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Month: 1 Sales: 238 Month: 13 2 4 5 6 220 245 345 14 16 17 Sales: 135 145 185 219 240 In 2020
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?
Step by Step Solution
★★★★★
3.54 Rating (154 Votes )
There are 3 Steps involved in it
Step: 1
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 ...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started