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.

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.

MATLAB: An Introduction with Applications

6th Edition

ISBN:9781119256830

Author:Amos Gilat

Publisher:Amos Gilat

Chapter1: Starting With Matlab

Section: Chapter Questions

Problem 1P

See similar textbooks

Similar questions

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
Please show examples and final answers
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.
Please answer both questions and be detailed, thank you in advance!
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. PLEASE USE A MATRIX TO SOLVE THIS PROBLEM....
Need a simplified version.