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

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) (Show Source): You can put this solution on YOUR website!
Answer: A
=============
cheers,
Stan H.
Answer by ewatrrr(24785) (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
RELATED QUESTIONS
Highway bridges often have expansion joints- small gaps between the bridge sections-that... (answered by jim_thompson5910)
Highway bridges often have expansion joints- small gaps between the bridge sections-that... (answered by DrBeeee)
Suppose that the correlation r between two quantitative variables was found to be r = 0.... (answered by Theo)
Suppose that the relationship between te tempeature t of a cup of water (in degrees... (answered by stanbon)
Entomologists have discovered that a linear relationship exists between the number of... (answered by josgarithmetic)
A study regarding the relationship between age and the amount of stress sales personnel... (answered by stanbon)
The relationship between Celsius (�C) and Fahrenheit(F�) degrees of measuring temperature (answered by josgarithmetic)
If we find that there is a linear correlation between the concentration of carbon dioxide (answered by richard1234)
Examining Relationships Question 3 Select one answer. 10 points If there is no... (answered by ikleyn)