document.write( "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:\r
\n" ); document.write( "\n" ); document.write( "2.4 225
\n" ); document.write( "1.6 184
\n" ); document.write( "2 220
\n" ); document.write( "2.6 240
\n" ); document.write( "1.4 180
\n" ); document.write( "1.6 184
\n" ); document.write( "2 186
\n" ); document.write( "2.2 215\r
\n" ); document.write( "\n" ); document.write( "a. Use Excel to determine the correlation coefficient of this data\r
\n" ); document.write( "\n" ); document.write( "b. Use Excel to determine the regression equation of this data\r
\n" ); document.write( "\n" ); document.write( "c. Use the regression equation to find f(3.1)\r
\n" ); document.write( "\n" ); document.write( "d. Use the regression equation to find f(1.7)
\n" ); document.write( "

Algebra.Com's Answer #672893 by Fombitz(32388)\"\" \"About 
You can put this solution on YOUR website!
\r
\n" ); document.write( "\n" ); document.write( ".
\n" ); document.write( ".
\n" ); document.write( ".
\n" ); document.write( ".
\n" ); document.write( "Type the data into EXCEL
\n" ); document.write( "Highlight the data, choose Insert Scatterplot.
\n" ); document.write( "Then right click on a data point and a Format Trendline dialog box will open.
\n" ); document.write( "Tick the last two boxes as shown.
\n" ); document.write( ".
\n" ); document.write( ".
\n" ); document.write( ".
\n" ); document.write( ".
\n" ); document.write( ".
\n" ); document.write( "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.
\n" ); document.write( ".
\n" ); document.write( ".
\n" ); document.write( ".
\n" ); document.write( "When you have the equation, find the values of y when \"x=3.1\" and \"x=1.7\".
\n" ); document.write( "
\n" );