his Question: 5 pts This Quiz: 25 pls d mleage to be driven next year The miles

Question

his Question: 5 pts This Quiz: 25 pls d mleage to be driven next year The miles driven during the past 5 years are as tollows Year 2 45 750 3 a) Using a 2-year moving average, the forecast for year 6 = | | miles round your response to the nearest whole number) b) If a 2-year moving average is used to make the forecast, the MAD based on thismiles (round your response to one decimal place) (Hint You wil have only 3 years of matched data ) c) The forecast for year 6 using a weighted 2-year moving average with weights of o.35 and 0 65 (the weight of 0 65 is for the most recent peniod)-mies (round your response to me nearest atole number The MAD for the forecast developed using a weighted 2- year moving average with weights of 0.35 and 0.65miles (round your response to one decimal place) (Hint You will have only 3 years of data ) d) using exponential smoorng with g a 050 and the forecast for year 1 being 3,000, the forecast for year 6 mies (round your response to me nearest whole nu oed Enter your answer in each of the answer boxes

Explanation / Answer

a) from above forecast for year 6 =3775

b) MAD =83.3

c)

forecast for year 6 =3767.5

MAD =138.3

d)

forecast for year 6 =3691

please revert for any clarification required

year mileage(A) Forecast(F) |A-F| 1 3000 2 3950 3 3450 3475 25 4 3800 3700 100 5 3750 3625 125 6 3775 total 250 average 83.33

Related Questions

Navigate

• Browse (All)
• Browse H
• Subjects

---

---

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