document.write( "Question 629245: The city of Oakdale wishes to see if there is a linear relationship between the temperature and the amount of electricity used (in kilowatts). Based on the data in the table below, is there a significant linear relationship between temperature and the amount of electricity used?
\n" ); document.write( "
\n" ); document.write( "Temperature (x) 73 78 85 98 93 81 76 105
\n" ); document.write( "Kilowatts (y) 680 760 910 1510 1170 837 600 1800
\n" ); document.write( "
\n" ); document.write( "
\n" ); document.write( " A. Yes, the sample correlation coefficient is equal to 0.981, which provides evidence of a significant linear relationship.
\n" ); document.write( "
\n" ); document.write( " B. Yes, the sample correlation coefficient is equal to 0.878, which provides evidence of a significant linear relationship.
\n" ); document.write( "
\n" ); document.write( " C. No, the sample correlation coefficient is equal to 0.098, which does not provide evidence of a significant linear relationship.
\n" ); document.write( "
\n" ); document.write( " D. No, the sample correlation coefficient is equal to 0.981, which does not provide evidence of a significant linear relationship.
\n" ); document.write( " \n" ); document.write( "

Algebra.Com's Answer #396124 by ewatrrr(24785) $\"\"$ $\"About$

You can put this solution on YOUR website!

 
\n" );
document.write( "Hi
\n" );
document.write( "Temperature (x) 73 78 85 98 93 81 76 105 
\n" );
document.write( "Kilowatts (y) 680 760 910 1510 1170 837 600 1800 
\n" );
document.write( "Using the Excel CORREL function to find r
\n" );
document.write( " r = 0.981, which provides evidence of a significant linear relationship.
\n" );
document.write( "1. Enter data in 2 columns
\n" );
document.write( "2. Select function/CORREL  \n" );
document.write( "

\n" );