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): 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
|
|
|