SOLUTION: Find the correlation coefficient for the following set of data. Then, write the regression equation for this data. Use the regression equation to find: 2.4 225 1.6 184 2 220

Question 1057898: Find the correlation coefficient for the following set of data. Then, write the regression equation for this data. Use the regression equation to find:
2.4 225
1.6 184
2 220
2.6 240
1.4 180
1.6 184
2 186
2.2 215
a. Use Excel to determine the correlation coefficient of this data
b. Use Excel to determine the regression equation of this data
c. Use the regression equation to find f(3.1)
d. Use the regression equation to find f(1.7)
Answer by Fombitz(32388) (Show Source): You can put this solution on YOUR website!

.
.
.
.
Type the data into EXCEL
Highlight the data, choose Insert Scatterplot.
Then right click on a data point and a Format Trendline dialog box will open.
Tick the last two boxes as shown.
.
.

.
.
.
The equation will be placed on the graph in addition to the coefficient of determination. The square root of the coefficient of determination is the correlation coefficient.
.
.
.
When you have the equation, find the values of y when and .
RELATED QUESTIONS
How do you find the linear regression equation and the correlation coefficient for a... (answered by Fombitz)

you are given the following data number of abscences 0,1,2,3,4,5 final grades... (answered by stanbon)

You are given the following data. Number of Absences Final Grade 0 91 1 89 (answered by Fombitz)

You are given the following data. # of Absent/ Final grade... (answered by stanbon,Theo)

You are given the following data. Number of Absences Final Grade 0 (answered by stanbon)

you are given the following data number of absences 0 (answered by Edwin McCravy)

You generate a scatter plot using Excel. You then have Excel plot the trend line and... (answered by Fombitz)

You are given the following data. Number of Absences Final Grade 0 (answered by ewatrrr)

Calculate the correlation coefficient for the following data, showing all work. What does (answered by ikleyn)