Quarter Enrollments in Business Statistics course at a major university are given below. Please copy and paste it in the EXCEL worksheet and run a regression Analysis. Answer the following 4 questions. Please also upload your EXCEL file on Titanium, otherwise you will NOT receive any point for this problem.

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

Question 1

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

Question 2

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

Question 3

Use the model to forecast for the enrollments for Fall 2013. Rounded to zero decimal places.

Question 4

What is the MSE for this forecast? Rounded to zero decimal places.