Multiple Linear Regression - Estimated Regression Equation |
HPC[t] = + 15515.9166666667 -2132.84102182539M1[t] -2859.02430555556M2[t] -1507.77901785714M3[t] -2251.39087301587M4[t] -1687.43129960317M5[t] -2357.90029761905M6[t] -2422.36929563492M7[t] -2104.69543650794M8[t] -2896.45014880952M9[t] -2143.9191468254M10[t] -2478.67385912698M11[t] + 77.7547123015873t + 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) | 15515.9166666667 | 129.27789 | 120.0199 | 0 | 0 |
M1 | -2132.84102182539 | 159.023856 | -13.4121 | 0 | 0 |
M2 | -2859.02430555556 | 158.904073 | -17.9921 | 0 | 0 |
M3 | -1507.77901785714 | 158.79562 | -9.4951 | 0 | 0 |
M4 | -2251.39087301587 | 158.69852 | -14.1866 | 0 | 0 |
M5 | -1687.43129960317 | 158.612794 | -10.6387 | 0 | 0 |
M6 | -2357.90029761905 | 158.538461 | -14.8727 | 0 | 0 |
M7 | -2422.36929563492 | 158.475536 | -15.2854 | 0 | 0 |
M8 | -2104.69543650794 | 158.424034 | -13.2852 | 0 | 0 |
M9 | -2896.45014880952 | 158.383965 | -18.2875 | 0 | 0 |
M10 | -2143.9191468254 | 158.355338 | -13.5387 | 0 | 0 |
M11 | -2478.67385912698 | 158.338159 | -15.6543 | 0 | 0 |
t | 77.7547123015873 | 1.346645 | 57.7396 | 0 | 0 |
Multiple Linear Regression - Regression Statistics | |
Multiple R | 0.99130582514897 |
R-squared | 0.98268723897428 |
Adjusted R-squared | 0.979761138519229 |
F-TEST (value) | 335.83510001438 |
F-TEST (DF numerator) | 12 |
F-TEST (DF denominator) | 71 |
p-value | 0 |
Multiple Linear Regression - Residual Statistics | |
Residual Standard Deviation | 296.212858097258 |
Sum Squared Residuals | 6229686.06845237 |
Multiple Linear Regression - Actuals, Interpolation, and Residuals | |||
Time or Index | Actuals | Interpolation Forecast | Residuals Prediction Error |
1 | 13328 | 13460.8303571428 | -132.830357142841 |
2 | 12873 | 12812.4017857143 | 60.5982142857118 |
3 | 14000 | 14241.4017857143 | -241.401785714286 |
4 | 13477 | 13575.5446428571 | -98.5446428571415 |
5 | 14237 | 14217.2589285714 | 19.7410714285705 |
6 | 13674 | 13624.5446428571 | 49.4553571428556 |
7 | 13529 | 13637.8303571429 | -108.830357142857 |
8 | 14058 | 14033.2589285714 | 24.7410714285711 |
9 | 12975 | 13319.2589285714 | -344.258928571428 |
10 | 14326 | 14149.5446428571 | 176.455357142858 |
11 | 14008 | 13892.5446428571 | 115.455357142857 |
12 | 16193 | 16448.9732142857 | -255.973214285715 |
13 | 14483 | 14393.8869047619 | 89.1130952380893 |
14 | 14011 | 13745.4583333333 | 265.541666666667 |
15 | 15057 | 15174.4583333333 | -117.458333333334 |
16 | 14884 | 14508.6011904762 | 375.398809523809 |
17 | 15414 | 15150.3154761905 | 263.684523809524 |
18 | 14440 | 14557.6011904762 | -117.601190476191 |
19 | 14900 | 14570.8869047619 | 329.113095238095 |
20 | 15074 | 14966.3154761905 | 107.684523809524 |
21 | 14442 | 14252.3154761905 | 189.684523809523 |
22 | 15307 | 15082.6011904762 | 224.398809523809 |
23 | 14938 | 14825.6011904762 | 112.398809523809 |
24 | 17193 | 17382.0297619048 | -189.029761904762 |
25 | 15528 | 15326.943452381 | 201.056547619045 |
26 | 14765 | 14678.5148809524 | 86.4851190476193 |
27 | 15838 | 16107.5148809524 | -269.514880952381 |
28 | 15723 | 15441.6577380952 | 281.342261904761 |
29 | 16150 | 16083.3720238095 | 66.6279761904764 |
30 | 15486 | 15490.6577380952 | -4.65773809523786 |
31 | 15986 | 15503.943452381 | 482.056547619047 |
32 | 15983 | 15899.3720238095 | 83.6279761904761 |
33 | 15692 | 15185.3720238095 | 506.627976190476 |
34 | 16490 | 16015.6577380952 | 474.342261904762 |
35 | 15686 | 15758.6577380952 | -72.657738095238 |
36 | 18897 | 18315.0863095238 | 581.91369047619 |
37 | 16316 | 16260 | 55.9999999999979 |
38 | 15636 | 15611.5714285714 | 24.4285714285715 |
39 | 17163 | 17040.5714285714 | 122.428571428571 |
40 | 16534 | 16374.7142857143 | 159.285714285714 |
41 | 16518 | 17016.4285714286 | -498.428571428571 |
42 | 16375 | 16423.7142857143 | -48.7142857142854 |
43 | 16290 | 16437 | -147 |
44 | 16352 | 16832.4285714286 | -480.428571428571 |
45 | 15943 | 16118.4285714286 | -175.428571428572 |
46 | 16362 | 16948.7142857143 | -586.714285714286 |
47 | 16393 | 16691.7142857143 | -298.714285714286 |
48 | 19051 | 19248.1428571429 | -197.142857142858 |
49 | 16747 | 17193.056547619 | -446.05654761905 |
50 | 16320 | 16544.6279761905 | -224.627976190476 |
51 | 17910 | 17973.6279761905 | -63.6279761904762 |
52 | 16961 | 17307.7708333333 | -346.770833333333 |
53 | 17480 | 17949.4851190476 | -469.485119047619 |
54 | 17049 | 17356.7708333333 | -307.770833333333 |
55 | 16879 | 17370.056547619 | -491.056547619047 |
56 | 17473 | 17765.4851190476 | -292.485119047619 |
57 | 16998 | 17051.4851190476 | -53.485119047619 |
58 | 17307 | 17881.7708333333 | -574.770833333333 |
59 | 17418 | 17624.7708333333 | -206.770833333333 |
60 | 20169 | 20181.1994047619 | -12.1994047619044 |
61 | 17871 | 18126.1130952381 | -255.113095238097 |
62 | 17226 | 17477.6845238095 | -251.684523809523 |
63 | 19062 | 18906.6845238095 | 155.315476190476 |
64 | 17804 | 18240.8273809524 | -436.827380952381 |
65 | 19100 | 18882.5416666667 | 217.458333333333 |
66 | 18522 | 18289.8273809524 | 232.172619047619 |
67 | 18060 | 18303.1130952381 | -243.113095238095 |
68 | 18869 | 18698.5416666667 | 170.458333333333 |
69 | 18127 | 17984.5416666667 | 142.458333333333 |
70 | 18871 | 18814.8273809524 | 56.1726190476177 |
71 | 18890 | 18557.8273809524 | 332.172619047619 |
72 | 21263 | 21114.255952381 | 148.744047619049 |
73 | 19547 | 19059.1696428571 | 487.830357142855 |
74 | 18450 | 18410.7410714286 | 39.2589285714298 |
75 | 20254 | 19839.7410714286 | 414.25892857143 |
76 | 19240 | 19173.8839285714 | 66.1160714285716 |
77 | 20216 | 19815.5982142857 | 400.401785714287 |
78 | 19420 | 19222.8839285714 | 197.116071428572 |
79 | 19415 | 19236.1696428571 | 178.830357142857 |
80 | 20018 | 19631.5982142857 | 386.401785714286 |
81 | 18652 | 18917.5982142857 | -265.598214285714 |
82 | 19978 | 19747.8839285714 | 230.116071428572 |
83 | 19509 | 19490.8839285714 | 18.1160714285716 |
84 | 21971 | 22047.3125 | -76.312499999999 |
Goldfeld-Quandt test for Heteroskedasticity | |||
p-values | Alternative Hypothesis | ||
breakpoint index | greater | 2-sided | less |
16 | 0.0480796323752216 | 0.0961592647504432 | 0.951920367624778 |
17 | 0.013243246679516 | 0.026486493359032 | 0.986756753320484 |
18 | 0.043210782409989 | 0.086421564819978 | 0.956789217590011 |
19 | 0.0315084969136553 | 0.0630169938273105 | 0.968491503086345 |
20 | 0.0152933905266359 | 0.0305867810532718 | 0.984706609473364 |
21 | 0.0158812131725255 | 0.0317624263450509 | 0.984118786827475 |
22 | 0.00966682614310166 | 0.0193336522862033 | 0.990333173856898 |
23 | 0.0063019843556381 | 0.0126039687112762 | 0.993698015644362 |
24 | 0.00319094541650994 | 0.00638189083301988 | 0.99680905458349 |
25 | 0.001433526189197 | 0.002867052378394 | 0.998566473810803 |
26 | 0.00212110096484136 | 0.00424220192968273 | 0.997878899035159 |
27 | 0.00238615697093002 | 0.00477231394186004 | 0.99761384302907 |
28 | 0.00131420023077463 | 0.00262840046154927 | 0.998685799769225 |
29 | 0.00104463247716716 | 0.00208926495433433 | 0.998955367522833 |
30 | 0.000514169460455946 | 0.00102833892091189 | 0.999485830539544 |
31 | 0.000776122767264041 | 0.00155224553452808 | 0.999223877232736 |
32 | 0.000452014186878445 | 0.000904028373756889 | 0.999547985813122 |
33 | 0.00239104900531054 | 0.00478209801062109 | 0.997608950994689 |
34 | 0.00481588271422673 | 0.00963176542845347 | 0.995184117285773 |
35 | 0.0068661724190295 | 0.013732344838059 | 0.99313382758097 |
36 | 0.102272467142472 | 0.204544934284944 | 0.897727532857528 |
37 | 0.113338559214983 | 0.226677118429966 | 0.886661440785017 |
38 | 0.159719499815921 | 0.319438999631842 | 0.840280500184079 |
39 | 0.139186574074133 | 0.278373148148265 | 0.860813425925868 |
40 | 0.291585373792779 | 0.583170747585558 | 0.708414626207221 |
41 | 0.584474474166781 | 0.831051051666439 | 0.415525525833219 |
42 | 0.564639796808958 | 0.870720406382084 | 0.435360203191042 |
43 | 0.702621746976875 | 0.59475650604625 | 0.297378253023125 |
44 | 0.782353228856726 | 0.435293542286547 | 0.217646771143274 |
45 | 0.797662920721427 | 0.404674158557147 | 0.202337079278573 |
46 | 0.898354404500991 | 0.203291190998018 | 0.101645595499009 |
47 | 0.876890356415658 | 0.246219287168683 | 0.123109643584341 |
48 | 0.858653848981127 | 0.282692302037746 | 0.141346151018873 |
49 | 0.857155395926081 | 0.285689208147837 | 0.142844604073919 |
50 | 0.834884746872849 | 0.330230506254303 | 0.165115253127151 |
51 | 0.785695729980793 | 0.428608540038415 | 0.214304270019207 |
52 | 0.772954826807278 | 0.454090346385444 | 0.227045173192722 |
53 | 0.809578338257672 | 0.380843323484657 | 0.190421661742328 |
54 | 0.770831147074813 | 0.458337705850374 | 0.229168852925187 |
55 | 0.753727922744182 | 0.492544154511635 | 0.246272077255818 |
56 | 0.730345718803361 | 0.539308562393279 | 0.269654281196639 |
57 | 0.701912347381602 | 0.596175305236797 | 0.298087652618398 |
58 | 0.786742234335598 | 0.426515531328803 | 0.213257765664402 |
59 | 0.731444268566857 | 0.537111462866286 | 0.268555731433143 |
60 | 0.669796407678469 | 0.660407184643061 | 0.330203592321531 |
61 | 0.800781167812382 | 0.398437664375237 | 0.199218832187618 |
62 | 0.744179576169959 | 0.511640847660081 | 0.255820423830041 |
63 | 0.704109506968413 | 0.591780986063173 | 0.295890493031587 |
64 | 0.776403232124103 | 0.447193535751794 | 0.223596767875897 |
65 | 0.730615425479784 | 0.538769149040433 | 0.269384574520216 |
66 | 0.62878851716102 | 0.742422965677961 | 0.37121148283898 |
67 | 0.724631049343988 | 0.550737901312023 | 0.275368950656012 |
68 | 0.752852786618918 | 0.494294426762163 | 0.247147213381082 |
Meta Analysis of Goldfeld-Quandt test for Heteroskedasticity | |||
Description | # significant tests | % significant tests | OK/NOK |
1% type I error level | 11 | 0.207547169811321 | NOK |
5% type I error level | 17 | 0.320754716981132 | NOK |
10% type I error level | 20 | 0.377358490566038 | NOK |