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)![]() ![]() 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 |