In: Statistics and Probability
The city of Oakdale wishes to see if there is a linear relationship between the temperature and the amount of
electricity used (in kilowatts). Using that data, find the estimated regression equation which can be used to estimate Kilowatts when using Temperature as the predictor variable.
Temperature (x) |
Kilowatts (y) |
73 |
680 |
78 |
760 |
85 |
910 |
98 |
1510 |
93 |
1170 |
83 | 888 |
92 | 923 |
81 |
837 |
76 |
600 |
105 |
1800 |
Kilowatts = -2003.896 + 34.858(Temperature)
Kilowatts = 371.223 + 4.269(Temperature)
Kilowatts = 132.031 + 34.858(Temperature)
Kilowatts = 0.945 + 0.893(Temperature)
We can use here Excel for regression equation
Step 1) Enter data in Excel .
Step 2) Data >>Data analysis >>Regression >>Select y and x values separately >>Ok
A.
Kilowatts = -2003.896 + 34.858(Temperature) |