Question

Year	Period (t)	Enrollment (1,000s)
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

(b) Use simple linear regression analysis to find the parameters for the line that minimizes MSE for this time series. If required, round your answers to two decimal places. y-intercept, b0 = Slope, b1 = MSE = (c) What is the forecast for year 10? Do not round your interim computations and round your final answer to two decimal places.

Answer 1

b) From the given data

S.No.	t	Enrollment	X^2	Y^2	XY
1	1	6.5	1	42.25	6.5
2	2	8.1	4	65.61	16.2
3	3	8.4	9	70.56	25.2
4	4	10.2	16	104.04	40.8
5	5	12.5	25	156.25	62.5
6	6	13.3	36	176.89	79.8
7	7	13.7	49	187.69	95.9
8	8	17.2	64	295.84	137.6
9	9	18.1	81	327.61	162.9
Total:	45	108	285	1426.74	627.4

Intercept: 4.72

Slope: 1.46

Y -hat = 19.28