Question: The Independence School is a private grade school that depends on enrollment forecasting to plan for the upcoming school year. The following data show the

The Independence School is a private grade school that depends on enrollment forecasting to plan for the upcoming school year. The following data show the enrollments for the past several years. These data can also be found in the Excel file Independence School. xlsx.

Year Enrollment 2006 2007 2008 2009 624 645 659 643 Year Enrollment

a. Forecast the 2014 enrollment for the Independence School using four period simple moving average.

b. Calculate the MAD for the forecast in part a.

c. Forecast the 2014 enrollment for the Independence School using exponential smoothing with α = 0.4.

d. Calculate the MAD for the forecast in part c.

e. In which forecast do you have most confidence? Why?

Year Enrollment 2006 2007 2008 2009 624 645 659 643 Year Enrollment 2010 2011 2012 2013 630 625 641 656

Step by Step Solution

3.38 Rating (173 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

a b c d e The forecast using 4period simp... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Document Format (1 attachment)

Word file Icon

483-M-S-F (237).docx

120 KBs Word File

Students Have Also Explored These Related Statistics Questions!