Multiple Linear Regression - Estimated Regression Equation |
TimeIn[t] = -691.543620463383 + 0.0231072136227715Date[t] + 0.785589415565234Sunset[t] + 0.7470913433272Temp[t] -0.257342357332257Dewpoint[t] -0.0329868786295858Humidity[t] -16.73008746253Rain[t] + e[t] |
Multiple Linear Regression - Ordinary Least Squares | |||||
Variable | Parameter | S.D. | T-STAT H0: parameter = 0 | 2-tail p-value | 1-tail p-value |
(Intercept) | -691.543620463383 | 568.719738 | -1.216 | 0.23415 | 0.117075 |
Date | 0.0231072136227715 | 0.011469 | 2.0147 | 0.053626 | 0.026813 |
Sunset | 0.785589415565234 | 0.149807 | 5.244 | 1.4e-05 | 7e-06 |
Temp | 0.7470913433272 | 1.531553 | 0.4878 | 0.629489 | 0.314745 |
Dewpoint | -0.257342357332257 | 1.690645 | -0.1522 | 0.880109 | 0.440054 |
Humidity | -0.0329868786295858 | 0.439549 | -0.075 | 0.940711 | 0.470355 |
Rain | -16.73008746253 | 5.382611 | -3.1082 | 0.004291 | 0.002146 |
Multiple Linear Regression - Regression Statistics | |
Multiple R | 0.833389659213899 |
R-squared | 0.694538324084659 |
Adjusted R-squared | 0.629082250674228 |
F-TEST (value) | 10.6107544784986 |
F-TEST (DF numerator) | 6 |
F-TEST (DF denominator) | 28 |
p-value | 3.77900313952573e-06 |
Multiple Linear Regression - Residual Statistics | |
Residual Standard Deviation | 10.6505459220608 |
Sum Squared Residuals | 3176.1555962619 |
Multiple Linear Regression - Actuals, Interpolation, and Residuals | |||
Time or Index | Actuals | Interpolation Forecast | Residuals Prediction Error |
1 | 1225 | 1218.15734386852 | 6.84265613148283 |
2 | 1214 | 1220.44498067032 | -6.44498067031628 |
3 | 1205 | 1219.67200012903 | -14.6720001290315 |
4 | 1196 | 1216.01732449338 | -20.0173244933825 |
5 | 1209 | 1189.70763607136 | 19.2923639286405 |
6 | 1192 | 1203.32418663531 | -11.32418663531 |
7 | 1196 | 1187.81088005183 | 8.18911994817215 |
8 | 1174 | 1181.65467159715 | -7.65467159714901 |
9 | 1183 | 1198.6749854858 | -15.6749854858036 |
10 | 1210 | 1200.20931977947 | 9.79068022052556 |
11 | 1205 | 1200.94929948985 | 4.05070051014911 |
12 | 1218 | 1203.34505204771 | 14.654947952288 |
13 | 1224 | 1208.03173904649 | 15.9682609535083 |
14 | 1215 | 1211.047741779 | 3.95225822100238 |
15 | 1206 | 1204.34988806626 | 1.65011193374426 |
16 | 1202 | 1203.36566182563 | -1.3656618256333 |
17 | 1215 | 1199.62830377733 | 15.3716962226669 |
18 | 1203 | 1199.74203400206 | 3.25796599793583 |
19 | 1194 | 1197.1199074065 | -3.11990740649736 |
20 | 1170 | 1180.40217672079 | -10.4021767207901 |
21 | 1184 | 1177.89734861679 | 6.102651383212 |
22 | 1199 | 1193.35099977331 | 5.64900022669084 |
23 | 1196 | 1195.56715569564 | 0.432844304358663 |
24 | 1189 | 1189.70785834819 | -0.707858348186726 |
25 | 1185 | 1189.94922937268 | -4.94922937267651 |
26 | 1192 | 1189.70694223026 | 2.29305776974357 |
27 | 1188 | 1185.0932512286 | 2.90674877139628 |
28 | 1176 | 1182.90451472693 | -6.90451472693063 |
29 | 1154 | 1169.52728694209 | -15.5272869420855 |
30 | 1177 | 1181.02617961252 | -4.02617961252112 |
31 | 1166 | 1176.4732007632 | -10.4732007632046 |
32 | 1176 | 1173.81544904308 | 2.18455095692015 |
33 | 1181 | 1174.49603915606 | 6.50396084394164 |
34 | 1176 | 1168.69500185141 | 7.30499814859439 |
35 | 1172 | 1175.13440969545 | -3.13440969545471 |
Goldfeld-Quandt test for Heteroskedasticity | |||
p-values | Alternative Hypothesis | ||
breakpoint index | greater | 2-sided | less |
10 | 0.939608116499313 | 0.120783767001373 | 0.0603918835006867 |
11 | 0.969983338141879 | 0.0600333237162423 | 0.0300166618581211 |
12 | 0.997379857708737 | 0.0052402845825255 | 0.00262014229126275 |
13 | 0.996906076424128 | 0.00618784715174359 | 0.0030939235758718 |
14 | 0.994372235683208 | 0.0112555286335838 | 0.00562776431679191 |
15 | 0.990199224684679 | 0.0196015506306426 | 0.00980077531532131 |
16 | 0.982556410278478 | 0.0348871794430443 | 0.0174435897215222 |
17 | 0.987063805506616 | 0.0258723889867686 | 0.0129361944933843 |
18 | 0.975732341397596 | 0.0485353172048081 | 0.024267658602404 |
19 | 0.976183687374582 | 0.0476326252508357 | 0.0238163126254178 |
20 | 0.996371069908011 | 0.00725786018397805 | 0.00362893009198902 |
21 | 0.996365951963407 | 0.00726809607318502 | 0.00363404803659251 |
22 | 0.992698498778339 | 0.014603002443321 | 0.00730150122166051 |
23 | 0.98105941433897 | 0.03788117132206 | 0.01894058566103 |
24 | 0.94948402158958 | 0.101031956820839 | 0.0505159784104197 |
25 | 0.946779547520872 | 0.106440904958255 | 0.0532204524791276 |
Meta Analysis of Goldfeld-Quandt test for Heteroskedasticity | |||
Description | # significant tests | % significant tests | OK/NOK |
1% type I error level | 4 | 0.25 | NOK |
5% type I error level | 12 | 0.75 | NOK |
10% type I error level | 13 | 0.8125 | NOK |