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.
Chapter6: Exponential And Logarithmic Functions
Section6.8: Fitting Exponential Models To Data
Problem 3TI: Table 6 shows the population, in thousands, of harbor seals in the Wadden Sea over the years 1997 to...
Related questions
Question
help please answer in text form with proper workings and explanation for each and every part and steps with concept and introduction no AI no copy paste remember answer must be in proper format with all working
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps
Recommended textbooks for you
College Algebra
Algebra
ISBN:
9781305115545
Author:
James Stewart, Lothar Redlin, Saleem Watson
Publisher:
Cengage Learning
Algebra & Trigonometry with Analytic Geometry
Algebra
ISBN:
9781133382119
Author:
Swokowski
Publisher:
Cengage
College Algebra
Algebra
ISBN:
9781305115545
Author:
James Stewart, Lothar Redlin, Saleem Watson
Publisher:
Cengage Learning
Algebra & Trigonometry with Analytic Geometry
Algebra
ISBN:
9781133382119
Author:
Swokowski
Publisher:
Cengage
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill
Algebra and Trigonometry (MindTap Course List)
Algebra
ISBN:
9781305071742
Author:
James Stewart, Lothar Redlin, Saleem Watson
Publisher:
Cengage Learning
College Algebra (MindTap Course List)
Algebra
ISBN:
9781305652231
Author:
R. David Gustafson, Jeff Hughes
Publisher:
Cengage Learning