Linear Regression is covered in Section 2.5 in Week 3 Learning Resources.  Use EXCEL for the creation of the scatter plot and to insert the regression line, with regression parameters indicated, as instructed in the videos

For this assignment you will implement a project involving linear curve-fitting and interpretation. You will assess the appropriateness of a linear model, and explore the predictive power of the model. You will use appropriate technology to perform the modeling tasks. The project is due at the end of Week 5.

The project is to determine the best fit equation, y =  mx+b, and the correlation coefficient for the following data set. Also, what is the predicted death rate for the age of 35?

AGE              DRIVER DEATHS per 100,000

17.5                38

22.0                36

26.5                34

29.5                24

38.4                22

44.5                20

52.0                19

64.5                18

You are to calculate the slope and intercept of the best fit line by using the  expressions for SSxy, SSyy, etc. as presented in the videos for Linear Regression/Correlation which are presented  below. A comparison between these results and the results of determining the slope and intercept of the regression line using EXCEL may be made.

You are to create a WORD.docx file that contains the project title, introduction to Regression and Correlation, data description and discussion, EXCEL graph of scatter points and regression line, with regression parameters, and all the comments to be presented regarding conclusions. Compare EXCEL results with computations of  SSxy, etc., for same regression parameters. Estimate the deaths corresponding to the age of 35.  Please contact me for any questions about the project.

Click here for further assistance on this assignment