Sales of Volkswagen\'s popular Beetle have grown steadily at auto dealerships in

Question

Sales of Volkswagen's popular Beetle have grown steadily at auto dealerships in Nevada during the past 5 years.

Year Sale

1 455

2 502

3 516

4 563

5 584

a) Forecasted sales for year 6 using a 3-year moving average is _____ sales (round your response to one decimal place).

b) The MAD for a 3-year moving average based forecast is _______ sales (round your response to one decimal place).

c) The MSE for a 3-year moving average based forecast is ______sales (round your response to the nearest whole number).

Explanation / Answer

from above:

a)  Forecasted sales for year 6 using a 3-year moving average is 554.3

b) The MAD for a 3-year moving average based forecast is 64.5

c)The MSE for a 3-year moving average based forecast is 4216.5

Year     Sale year Sale(A) forecast(F) |A-F| (A-F)^2 1           455 1 455 2           502 2 502 3           516 3 516 4           563 4 563 491 72 5184 5           584 5 584 527 57 3249 6 554.33 Total 129 8433 mean 64.5 4216.5

Related Questions

Navigate

• Browse (All)
• Browse S
• Subjects

---

---

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