Data collected on the yearly registrations for a Six Sigma seminar at the Qualit
ID: 342605 • Letter: D
Question
Data collected on the yearly registrations for a Six Sigma seminar at the Quality College are shown in the following table Year 3 4 5 10 11 Registrations (000) 4.006.00 4.00 5.00 10.00 8.00 6.00 9.00 12.00 16.00 17.00 a) Calculate the forecasted registrations for years 2 through 12 using exponential smoothing with a smoothing constant of 0.35 and a starting forecast of 6.00 for year 1 (round your responses to one decimal place) Year 4 6 10 12 Forecast (000) 6.00 5.3 5.0 5.0 6.8 7.2 6.8 7.6 9.1 11.5 13.4 b Mean absolute deviation based on the forecast developed using the exponential smoothing method with a smoothing constant ( = 0.35 and a starting forecast of F1 6.00) isregistrations (round your response to one decimal place)Explanation / Answer
b) Mean absolute deviation = Sum of the absolute deviation for all the periods / number of periods
Where,
Deviation = actual value - forecasted value
Absolute deviation = absolute value of deviation
So given the actual value and forecasted values for all the periods the deviation and absolute deviation are
Mean absolute deviation = (2+0.7+1.5+0+5+1.2+1.2+2.2+4.4+6.9+5.5)/11
= 30.6/11
= 2.8
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.