Scribd
Upload
22 views6 pages

Regression Analysis of Temperature and Load

The document contains temperature and peak power load data for 10 days. It calculates the least squares regression line to model the relationship between maximum temperature (X) and peak power load (Y). The regression equation is Y = 127.6252 - 6.7175X. It also reports the mean and standard deviation of the temperature and load data. The coefficient of correlation between temperature and load is -0.94888, indicating a strong negative linear relationship. Using the regression equation, if the maximum temperature tomorrow is 98°F, the predicted peak power load would be Y = 127.6252 - 6.7175(98) = 127.6252 - 660.3825 = -532.7573.

Uploaded by

Hazel Pacs
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
22 views6 pages

Regression Analysis of Temperature and Load

The document contains temperature and peak power load data for 10 days. It calculates the least squares regression line to model the relationship between maximum temperature (X) and peak power load (Y). The regression equation is Y = 127.6252 - 6.7175X. It also reports the mean and standard deviation of the temperature and load data. The coefficient of correlation between temperature and load is -0.94888, indicating a strong negative linear relationship. Using the regression equation, if the maximum temperature tomorrow is 98°F, the predicted peak power load would be Y = 127.6252 - 6.7175(98) = 127.6252 - 660.3825 = -532.7573.

Uploaded by

Hazel Pacs
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

Maximum Peak Power

Day (X - Xbar)
Temperature (X) Load (Y)

1 95 214 3.5
2 82 152 -9.5
3 90 156 -1.5
4 81 129 -10.5
5 99 254 7.5
6 100 266 8.5
7 93 210 1.5
8 95 204 3.5
9 93 213 1.5
10 87 150 -4.5

Total 915 1948

Mean 91.5 194.8

b(∑▒
1
=〖 (𝑥 − 𝑥 ̅)(𝑦 − 𝑦 ̅) 〗 )/(∑▒ 〖 (𝑥 〗6.717477003942
−𝑥 ̅ ) 2)

b0 = 𝑦 ̅ −𝑏1(𝑥) 127.6252299606

b) How do you expect the peak power load to change if the maximum temperature
increases by 5 0 F?

b1 (x) = 33.587385019711

c) Write the equation of the least square regression line.


𝑦 ̂ 𝑏0+𝑏1𝑥 127.6252 - 6.7175x

d) Below are the means and standard deviation of temperature and load. Temperature
(X): Mean = 91.5, standard deviation = 6.5021
Load (Y): Mean = 194.8, standard deviation = 46.2645
Determine the coefficient of correlation.

(𝑥 − 𝑥 ̅)/𝑠
Zx = -12.5344119592132
(𝑍𝑥 −𝑍𝑦)/(𝑛 −1)
r = -0.948887621026965

Zy = -3.9944233699705

e) Predict the required peak power load, if tomorrow’s maximum temperature is


expected to be 98 0 F.
(Y - Ybar)2
(Y - Ybar) (X - Xbar) 2
(Syy) (X - Xbar)(Y - Ybar)

19.2 12.25 368.64 67.2


-42.8 90.25 1831.84 406.6
-38.8 2.25 1505.44 58.2
-65.8 110.25 4329.64 690.9
59.2 56.25 3504.64 444
71.2 72.25 5069.44 605.2
15.2 2.25 231.04 22.8
9.2 12.25 84.64 32.2
18.2 2.25 331.24 27.3
-44.8 20.25 2007.04 201.6

380.5 17256.56 2556


Zy Zx (Y - Yhut)2 (Y - Yhut)2
(SSE) (SSE)

0.415005 0.5382876 18.8400670553


-0.925115 -1.461066 9.30468617831
-0.838656 -0.230695 9.91987204134
-1.422257 -1.614863 5.7673674659
1.2795988 1.1534735 24.9919256855
1.538977 1.30727 26.8374832746
0.3285456 0.2306947 18.2248811922
0.1988566 0.5382876 17.3021023977
0.3933902 0.2306947 18.6862705895
-0.968345 -0.692084 8.9970932468

158.87174912721
Spearman's Rho (coefficient of correlation)

= 1 – (6*12)/(9(81-1))
= 1 – 72/720

ρ = 0.90
d2 = 12

You might also like