Multiple Linear Regression - Estimated Regression Equation |
TimeIn[t] = + 784.964659426609 + 0.307180923823299Sunset[t] + 1.27562842060466Temperature[t] -18.0203187459354Rain[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) | 784.964659426609 | 226.522355 | 3.4653 | 0.001619 | 0.00081 |
Sunset | 0.307180923823299 | 0.198072 | 1.5509 | 0.131424 | 0.065712 |
Temperature | 1.27562842060466 | 0.56703 | 2.2497 | 0.031963 | 0.015981 |
Rain | -18.0203187459354 | 7.140063 | -2.5238 | 0.017137 | 0.008569 |
Multiple Linear Regression - Regression Statistics | |
Multiple R | 0.678147633506224 |
R-squared | 0.459884212830092 |
Adjusted R-squared | 0.405872634113101 |
F-TEST (value) | 8.51454861632146 |
F-TEST (DF numerator) | 3 |
F-TEST (DF denominator) | 30 |
p-value | 0.000305434288559225 |
Multiple Linear Regression - Residual Statistics | |
Residual Standard Deviation | 15.049466280197 |
Sum Squared Residuals | 6794.59305956363 |
Multiple Linear Regression - Actuals, Interpolation, and Residuals | |||
Time or Index | Actuals | Interpolation Forecast | Residuals Prediction Error |
1 | 1217 | 1196.19805829155 | 20.8019417084539 |
2 | 1202 | 1200.22801399778 | 1.77198600222244 |
3 | 1180 | 1201.14440625486 | -21.1444062548566 |
4 | 1167 | 1197.26546575334 | -30.2654657533402 |
5 | 1186 | 1166.51231516401 | 19.4876848359861 |
6 | 1168 | 1161.38119860455 | 6.61880139545141 |
7 | 1142 | 1156.55726296891 | -14.5572629689066 |
8 | 1147 | 1175.67359205368 | -28.6735920536839 |
9 | 1183 | 1179.39636683609 | 3.60363316390688 |
10 | 1149 | 1182.5333826479 | -33.5333826479024 |
11 | 1197 | 1188.16960006122 | 8.83039993878134 |
12 | 1210 | 1183.47322726764 | 26.5267727323629 |
13 | 1206 | 1188.01343434211 | 17.9865656578884 |
14 | 1196 | 1178.97992491847 | 17.0200750815258 |
15 | 1190 | 1170.1260335766 | 19.8739664234004 |
16 | 1175 | 1169.51167172895 | 5.48832827104695 |
17 | 1186 | 1173.87226072166 | 12.1277392783354 |
18 | 1172 | 1174.3304568502 | -2.33045685020413 |
19 | 1152 | 1154.29773550835 | -2.29773550834788 |
20 | 1154 | 1156.6642237534 | -2.66422375340347 |
21 | 1168 | 1175.60093475642 | -7.6009347564179 |
22 | 1180 | 1174.98657290877 | 5.0134270912287 |
23 | 1169 | 1167.53587282956 | 1.46412717043811 |
24 | 1166 | 1172.68529123729 | -6.68529123729201 |
25 | 1177 | 1170.3371048405 | 6.66289515949875 |
26 | 1168 | 1166.78879762546 | 1.21120237453608 |
27 | 1160 | 1164.44061122867 | -4.44061122867316 |
28 | 1147 | 1153.58726400078 | -6.58726400077959 |
29 | 1161 | 1159.64012795569 | 1.35987204431309 |
30 | 1143 | 1154.35799619151 | -11.3579961915054 |
31 | 1161 | 1161.52496770955 | -0.524967709547274 |
32 | 1161 | 1166.95811467844 | -5.95811467844496 |
33 | 1168 | 1164.81299872607 | 3.18700127392723 |
34 | 1172 | 1172.41471401 | -0.414714009998385 |
Goldfeld-Quandt test for Heteroskedasticity | |||
p-values | Alternative Hypothesis | ||
breakpoint index | greater | 2-sided | less |
7 | 0.0723182204235766 | 0.144636440847153 | 0.927681779576423 |
8 | 0.268258671328907 | 0.536517342657814 | 0.731741328671093 |
9 | 0.968682086162451 | 0.0626358276750979 | 0.0313179138375489 |
10 | 0.999738031082882 | 0.000523937834236601 | 0.000261968917118301 |
11 | 0.99996809253341 | 6.38149331826412e-05 | 3.19074665913206e-05 |
12 | 0.999994239762902 | 1.15204741955112e-05 | 5.76023709775559e-06 |
13 | 0.999983451051036 | 3.30978979280611e-05 | 1.65489489640305e-05 |
14 | 0.999973652355527 | 5.26952889453496e-05 | 2.63476444726748e-05 |
15 | 0.999994894542295 | 1.02109154095754e-05 | 5.10545770478769e-06 |
16 | 0.999982203782903 | 3.55924341944653e-05 | 1.77962170972327e-05 |
17 | 0.999988387381 | 2.32252380022595e-05 | 1.16126190011298e-05 |
18 | 0.999968836963064 | 6.23260738717797e-05 | 3.11630369358899e-05 |
19 | 0.999921577416303 | 0.00015684516739299 | 7.84225836964949e-05 |
20 | 0.999791429588653 | 0.000417140822693992 | 0.000208570411346996 |
21 | 0.999813181007546 | 0.000373637984908456 | 0.000186818992454228 |
22 | 0.999332707091657 | 0.00133458581668686 | 0.00066729290834343 |
23 | 0.997779207190063 | 0.00444158561987435 | 0.00222079280993718 |
24 | 0.99800011849312 | 0.00399976301375883 | 0.00199988150687942 |
25 | 0.99414904390582 | 0.0117019121883602 | 0.00585095609418011 |
26 | 0.981134404001596 | 0.0377311919968078 | 0.0188655959984039 |
27 | 0.937252920049863 | 0.125494159900275 | 0.0627470799501374 |
Meta Analysis of Goldfeld-Quandt test for Heteroskedasticity | |||
Description | # significant tests | % significant tests | OK/NOK |
1% type I error level | 15 | 0.714285714285714 | NOK |
5% type I error level | 17 | 0.80952380952381 | NOK |
10% type I error level | 18 | 0.857142857142857 | NOK |