Please do all of these problems in EXCEL and upload the spreadsheets to this assignment. 1. Consider the time series data given below: Xi 8 3 2 10 11 3 6 5 6 8 yi 4 12 1 14 12 9 4 9 6 1 Use the least square method to determine the equation of line of best fit for the data. 2. Number of man-hours and the corresponding productivity (in units) are furnished below. Fit a simple linear regression equation ^Y = a + bx applying the method of least squares. 3. The sales of a company (in million dollars) for each year are shown in the table below. x (year) 2005 2006 2007 2008 2009 y (sales) 12 19 29 37 45 a) Find the least square regression line y = ax + b. b) Use the least squares regression line as a model to estimate the sales of the company in 2012.

Provide complete solution

Please read the question and leave notes on the answer where appropriate. Please DO NOT skip any steps. Please double check your answer. DO NOT SUBMIT A TYPED RESPONSE. Please use a hand written response that is LEGABLE. Please review your answer to make sure all steps are clearly visible. Please double check your work. Thank you.  Show all your work and please make sure to Justify your answers.  I am having trouble finding this answer. Please double check your steps and do not submit a typed response that is not in LATEX.  Can you please explain how to write this as a linear combination of the other two?

Option a is different from the answer written