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

ID: 3247496 • Letter: S

Question

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

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

nothing

sales (round your response to one decimal place).

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

nothing

sales

(round

your response to one decimal place).

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

nothing

sales

(round

your response to the nearest whole number).

year & Sales

1, 455

2,502

3, 516

4,563

5, 584

from above given data:

a) Forecasted sales for year 6 =(516+563+584)/3 =554.3

b)MAD =129/2=64.5

c)MSE=8433/2=4216.5

please revert for any clarification required

Year actual(A) Forecast(F) |A-F| (A-F)^2 1 455 2 502 3 516 4 563 491.00 72 5184 5 584 527.00 57 3249 6 554.33 Total 129 8433

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