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
Algebra ->
Probability-and-statistics
-> 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
Log On
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 .
.
.