Year	Quarter	Enrollment
2009	Fall	905
2010	Winter	834
	Spring	761
	Fall	901
2011	Winter	802
	Spring	640
	Fall	863
2012	Winter	824
	Spring	809
	Fall	747
2013	Winter	730
	Spring	712

1. Develop a model for trend and seasonality. Please clearly define your variables. How many independent variables do you have in your regression?

2. What is the intercept in your estimated regression model? Rounded to zero decimal places.

3. Use the model to forecast for the enrollments for Fall 2013. Rounded to zero decimal places. 4. What is the MSE for this forecast? Rounded to zero decimal places. Can you show steps on how to do on excel please