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.

College Algebra
1st Edition
ISBN:9781938168383
Author:Jay Abramson
Publisher:Jay Abramson
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...
icon
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
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.
Transcribed Image Text: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.
Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
College Algebra
College Algebra
Algebra
ISBN:
9781938168383
Author:
Jay Abramson
Publisher:
OpenStax
College Algebra
College Algebra
Algebra
ISBN:
9781305115545
Author:
James Stewart, Lothar Redlin, Saleem Watson
Publisher:
Cengage Learning
Algebra & Trigonometry with Analytic Geometry
Algebra & Trigonometry with Analytic Geometry
Algebra
ISBN:
9781133382119
Author:
Swokowski
Publisher:
Cengage
Glencoe Algebra 1, Student Edition, 9780079039897…
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill
Algebra and Trigonometry (MindTap Course List)
Algebra and Trigonometry (MindTap Course List)
Algebra
ISBN:
9781305071742
Author:
James Stewart, Lothar Redlin, Saleem Watson
Publisher:
Cengage Learning
College Algebra (MindTap Course List)
College Algebra (MindTap Course List)
Algebra
ISBN:
9781305652231
Author:
R. David Gustafson, Jeff Hughes
Publisher:
Cengage Learning