Because of high tuition costs at state and private universities, enrollments at community colleges have increased dramatically in recent years. The following data show the enrollment (in thousands) for Jefferson Community College from 2001 to 2009.

Year Period (t) Enrollment (1000s)

2001 1 6.5

2002 2 8.1

2003 3 8.4

2004 4 10.2

2005 5 12.5

2006 6 13.3

2007 7 13.7

2008 8 17.2

2009 9 18.1

Quarter Stock% 1st2007 29.8 2nd2007 31.0 3rd2007 29.9 4th2007 30.1 1st2008 32.2 2nd2008 31.5 3rd2008 32.0 4th2008 31.9 1st2009 30.0 Problems 227 SELF test SELF test a. Construct a time series plot. What type of pattern exists in the data? b. Use simple linear regression analysis to find the parameters for the line that minimizes MSE for this time series. c. What is the forecast for 2010?

Use the SLOPE and INTERCEPT functions in Excel to solve for these coefficients

Please solve in excel, thanks