In: Statistics and Probability
2. Let x be the number of years after 2007 and y represent the number of students enrolled at WWCC. Answer the following given the data that enrollment was 2055 in the year 2007, 2244 in 2008, 2512 in 2009, 2715 in 2010, and 2765 in 2011.
(a) Find the least-squares line for the data using Excel and submit your file in Canvas.
(b) Using partial derivatives, verify the formula you obtained in Excel.
(c) Find the least-squares error E