Multiple Linear Regression - Estimated Regression Equation |
TimIN[t] = -266.548847215805 + 0.559491833891551Sunset[t] + 0.0189482370378005Date[t] -10.9503611451591Precip[t] + 1.07511098333939Temp[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) | -266.548847215805 | 456.102268 | -0.5844 | 0.563466 | 0.281733 |
Sunset | 0.559491833891551 | 0.125949 | 4.4422 | 0.000119 | 6e-05 |
Date | 0.0189482370378005 | 0.009629 | 1.9679 | 0.058706 | 0.029353 |
Precip | -10.9503611451591 | 4.875907 | -2.2458 | 0.032504 | 0.016252 |
Temp | 1.07511098333939 | 0.348582 | 3.0842 | 0.004452 | 0.002226 |
Multiple Linear Regression - Regression Statistics | |
Multiple R | 0.831552681889591 |
R-squared | 0.691479862757772 |
Adjusted R-squared | 0.648925361069189 |
F-TEST (value) | 16.2492764647574 |
F-TEST (DF numerator) | 4 |
F-TEST (DF denominator) | 29 |
p-value | 4.33557804324636e-07 |
Multiple Linear Regression - Residual Statistics | |
Residual Standard Deviation | 9.20326257910255 |
Sum Squared Residuals | 2456.30122089737 |
Multiple Linear Regression - Actuals, Interpolation, and Residuals | |||
Time or Index | Actuals | Interpolation Forecast | Residuals Prediction Error |
1 | 1225 | 1216.58750810022 | 8.41249189977688 |
2 | 1214 | 1219.70234184672 | -5.70234184672346 |
3 | 1205 | 1219.89243959599 | -14.8924395959854 |
4 | 1196 | 1216.34158524578 | -20.3415852457814 |
5 | 1209 | 1194.07763432815 | 14.9223656718472 |
6 | 1192 | 1197.71425268142 | -5.71425268141996 |
7 | 1196 | 1188.88918905553 | 7.11081094446628 |
8 | 1174 | 1184.24128737977 | -10.2412873797684 |
9 | 1183 | 1195.83372700975 | -12.8337270097471 |
10 | 1210 | 1198.38906892236 | 11.6109310776443 |
11 | 1210 | 1200.75132498052 | 9.24867501948165 |
12 | 1218 | 1204.91933336814 | 13.0806666318639 |
13 | 1219 | 1207.31399754654 | 11.6860024534603 |
14 | 1215 | 1210.85887568638 | 4.14112431362439 |
15 | 1206 | 1202.66310776559 | 3.33689223440967 |
16 | 1202 | 1194.91932058036 | 7.08067941963734 |
17 | 1195 | 1193.81928514962 | 1.18071485038264 |
18 | 1203 | 1196.9121825539 | 6.08781744610432 |
19 | 1194 | 1197.01670554705 | -3.01670554704557 |
20 | 1170 | 1185.29101287892 | -15.2910128789183 |
21 | 1189 | 1185.50087635763 | 3.49912364237321 |
22 | 1199 | 1196.64133525205 | 2.35866474795213 |
23 | 1196 | 1195.5412998213 | 0.458700178697428 |
24 | 1189 | 1188.98013471775 | 0.0198652822517701 |
25 | 1185 | 1192.15561877295 | -7.15561877295458 |
26 | 1192 | 1189.89489760276 | 2.1051023972422 |
27 | 1188 | 1186.32210691033 | 1.6778930896681 |
28 | 1176 | 1184.06138574014 | -8.06138574013513 |
29 | 1177 | 1178.85100412529 | -1.85100412529423 |
30 | 1166 | 1174.11752769342 | -8.11752769341686 |
31 | 1176 | 1172.64061450521 | 3.35938549479313 |
32 | 1181 | 1176.93807033338 | 4.06192966661963 |
33 | 1176 | 1174.54790172263 | 1.4520982773722 |
34 | 1177 | 1180.67304622248 | -3.67304622247827 |
Goldfeld-Quandt test for Heteroskedasticity | |||
p-values | Alternative Hypothesis | ||
breakpoint index | greater | 2-sided | less |
8 | 0.398729985161891 | 0.797459970323783 | 0.601270014838109 |
9 | 0.972827244384886 | 0.0543455112302279 | 0.0271727556151139 |
10 | 0.999721982479199 | 0.00055603504160224 | 0.00027801752080112 |
11 | 0.999815537581148 | 0.000368924837704736 | 0.000184462418852368 |
12 | 0.999524057688962 | 0.000951884622076062 | 0.000475942311038031 |
13 | 0.99934111764187 | 0.001317764716261 | 0.000658882358130502 |
14 | 0.998494485980411 | 0.00301102803917726 | 0.00150551401958863 |
15 | 0.996384064015724 | 0.00723187196855259 | 0.00361593598427629 |
16 | 0.993189541808781 | 0.0136209163824377 | 0.00681045819121885 |
17 | 0.985951243105839 | 0.0280975137883218 | 0.0140487568941609 |
18 | 0.979515524575498 | 0.0409689508490046 | 0.0204844754245023 |
19 | 0.970097390394483 | 0.0598052192110348 | 0.0299026096055174 |
20 | 0.999241631956609 | 0.00151673608678266 | 0.000758368043391332 |
21 | 0.997475303242176 | 0.00504939351564706 | 0.00252469675782353 |
22 | 0.992496543921937 | 0.015006912156127 | 0.00750345607806348 |
23 | 0.979549302931272 | 0.0409013941374568 | 0.0204506970687284 |
24 | 0.95095225491643 | 0.098095490167141 | 0.0490477450835705 |
25 | 0.953048440285164 | 0.0939031194296725 | 0.0469515597148363 |
26 | 0.87807297982368 | 0.243854040352639 | 0.12192702017632 |
Meta Analysis of Goldfeld-Quandt test for Heteroskedasticity | |||
Description | # significant tests | % significant tests | OK/NOK |
1% type I error level | 8 | 0.421052631578947 | NOK |
5% type I error level | 13 | 0.684210526315789 | NOK |
10% type I error level | 17 | 0.894736842105263 | NOK |