SOLUTION: 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 belo

Algebra ->  Probability-and-statistics -> SOLUTION: 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 belo      Log On


   



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?

Temperature (x) 73 78 85 98 93 81 76 105
Kilowatts (y) 680 760 910 1510 1170 837 600 1800


A. Yes, the sample correlation coefficient is equal to 0.981, which provides evidence of a significant linear relationship.

B. Yes, the sample correlation coefficient is equal to 0.878, which provides evidence of a significant linear relationship.

C. No, the sample correlation coefficient is equal to 0.098, which does not provide evidence of a significant linear relationship.

D. No, the sample correlation coefficient is equal to 0.981, which does not provide evidence of a significant linear relationship.

Found 2 solutions by stanbon, ewatrrr:
Answer by stanbon(75887) About Me  (Show Source):
You can put this solution on YOUR website!
Answer: A
=============
cheers,
Stan H.

Answer by ewatrrr(24785) About Me  (Show Source):
You can put this solution on YOUR website!
 
Hi
Temperature (x) 73 78 85 98 93 81 76 105
Kilowatts (y) 680 760 910 1510 1170 837 600 1800
Using the Excel CORREL function to find r
r = 0.981, which provides evidence of a significant linear relationship.
1. Enter data in 2 columns
2. Select function/CORREL