Multiple Linear Regression - Estimated Regression Equation |
HPC[t] = + 15515.9166666667 -2132.8410218254M1[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.8410218254 | 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.06845238 |
Multiple Linear Regression - Actuals, Interpolation, and Residuals | |||
Time or Index | Actuals | Interpolation Forecast | Residuals Prediction Error |
1 | 13328 | 13460.8303571429 | -132.830357142868 |
2 | 12873 | 12812.4017857143 | 60.598214285715 |
3 | 14000 | 14241.4017857143 | -241.401785714285 |
4 | 13477 | 13575.5446428571 | -98.5446428571404 |
5 | 14237 | 14217.2589285714 | 19.7410714285731 |
6 | 13674 | 13624.5446428571 | 49.4553571428566 |
7 | 13529 | 13637.8303571429 | -108.830357142857 |
8 | 14058 | 14033.2589285714 | 24.7410714285715 |
9 | 12975 | 13319.2589285714 | -344.258928571429 |
10 | 14326 | 14149.5446428571 | 176.455357142858 |
11 | 14008 | 13892.5446428571 | 115.455357142858 |
12 | 16193 | 16448.9732142857 | -255.973214285714 |
13 | 14483 | 14393.8869047619 | 89.1130952381001 |
14 | 14011 | 13745.4583333333 | 265.541666666667 |
15 | 15057 | 15174.4583333333 | -117.458333333333 |
16 | 14884 | 14508.6011904762 | 375.398809523809 |
17 | 15414 | 15150.3154761905 | 263.684523809524 |
18 | 14440 | 14557.6011904762 | -117.60119047619 |
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.056547619048 |
26 | 14765 | 14678.5148809524 | 86.4851190476182 |
27 | 15838 | 16107.5148809524 | -269.514880952381 |
28 | 15723 | 15441.6577380952 | 281.342261904761 |
29 | 16150 | 16083.3720238095 | 66.6279761904762 |
30 | 15486 | 15490.6577380952 | -4.65773809523794 |
31 | 15986 | 15503.943452381 | 482.056547619047 |
32 | 15983 | 15899.3720238095 | 83.6279761904762 |
33 | 15692 | 15185.3720238095 | 506.627976190476 |
34 | 16490 | 16015.6577380952 | 474.342261904762 |
35 | 15686 | 15758.6577380952 | -72.6577380952381 |
36 | 18897 | 18315.0863095238 | 581.91369047619 |
37 | 16316 | 16260 | 56.0000000000013 |
38 | 15636 | 15611.5714285714 | 24.4285714285711 |
39 | 17163 | 17040.5714285714 | 122.428571428571 |
40 | 16534 | 16374.7142857143 | 159.285714285714 |
41 | 16518 | 17016.4285714286 | -498.428571428572 |
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.056547619046 |
50 | 16320 | 16544.6279761905 | -224.627976190477 |
51 | 17910 | 17973.6279761905 | -63.6279761904766 |
52 | 16961 | 17307.7708333333 | -346.770833333334 |
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.4851190476187 |
58 | 17307 | 17881.7708333333 | -574.770833333333 |
59 | 17418 | 17624.7708333333 | -206.770833333333 |
60 | 20169 | 20181.1994047619 | -12.1994047619039 |
61 | 17871 | 18126.1130952381 | -255.113095238094 |
62 | 17226 | 17477.6845238095 | -251.684523809524 |
63 | 19062 | 18906.6845238095 | 155.315476190476 |
64 | 17804 | 18240.8273809524 | -436.827380952381 |
65 | 19100 | 18882.5416666667 | 217.458333333332 |
66 | 18522 | 18289.8273809524 | 232.172619047618 |
67 | 18060 | 18303.1130952381 | -243.113095238095 |
68 | 18869 | 18698.5416666667 | 170.458333333332 |
69 | 18127 | 17984.5416666667 | 142.458333333333 |
70 | 18871 | 18814.8273809524 | 56.1726190476182 |
71 | 18890 | 18557.8273809524 | 332.172619047619 |
72 | 21263 | 21114.255952381 | 148.744047619048 |
73 | 19547 | 19059.1696428571 | 487.830357142858 |
74 | 18450 | 18410.7410714286 | 39.2589285714294 |
75 | 20254 | 19839.7410714286 | 414.258928571429 |
76 | 19240 | 19173.8839285714 | 66.1160714285711 |
77 | 20216 | 19815.5982142857 | 400.401785714285 |
78 | 19420 | 19222.8839285714 | 197.116071428571 |
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.1160714285711 |
84 | 21971 | 22047.3125 | -76.3125 |
Goldfeld-Quandt test for Heteroskedasticity | |||
p-values | Alternative Hypothesis | ||
breakpoint index | greater | 2-sided | less |
16 | 0.0480796323752215 | 0.096159264750443 | 0.951920367624778 |
17 | 0.0132432466795159 | 0.0264864933590319 | 0.986756753320484 |
18 | 0.0432107824099892 | 0.0864215648199784 | 0.956789217590011 |
19 | 0.0315084969136555 | 0.0630169938273109 | 0.968491503086345 |
20 | 0.0152933905266358 | 0.0305867810532716 | 0.984706609473364 |
21 | 0.0158812131725252 | 0.0317624263450505 | 0.984118786827475 |
22 | 0.00966682614310163 | 0.0193336522862033 | 0.990333173856898 |
23 | 0.0063019843556381 | 0.0126039687112762 | 0.993698015644362 |
24 | 0.00319094541650988 | 0.00638189083301975 | 0.99680905458349 |
25 | 0.00143352618919701 | 0.00286705237839401 | 0.998566473810803 |
26 | 0.00212110096484134 | 0.00424220192968269 | 0.997878899035159 |
27 | 0.00238615697092998 | 0.00477231394185995 | 0.99761384302907 |
28 | 0.00131420023077457 | 0.00262840046154915 | 0.998685799769225 |
29 | 0.00104463247716715 | 0.0020892649543343 | 0.998955367522833 |
30 | 0.000514169460455932 | 0.00102833892091186 | 0.999485830539544 |
31 | 0.000776122767264043 | 0.00155224553452809 | 0.999223877232736 |
32 | 0.000452014186878419 | 0.000904028373756837 | 0.999547985813122 |
33 | 0.00239104900531059 | 0.00478209801062118 | 0.997608950994689 |
34 | 0.0048158827142265 | 0.009631765428453 | 0.995184117285773 |
35 | 0.0068661724190296 | 0.0137323448380592 | 0.99313382758097 |
36 | 0.102272467142476 | 0.204544934284951 | 0.897727532857524 |
37 | 0.113338559214984 | 0.226677118429967 | 0.886661440785016 |
38 | 0.15971949981592 | 0.31943899963184 | 0.84028050018408 |
39 | 0.139186574074132 | 0.278373148148265 | 0.860813425925868 |
40 | 0.291585373792779 | 0.583170747585559 | 0.708414626207221 |
41 | 0.584474474166784 | 0.831051051666432 | 0.415525525833216 |
42 | 0.564639796808956 | 0.870720406382088 | 0.435360203191044 |
43 | 0.702621746976873 | 0.594756506046253 | 0.297378253023127 |
44 | 0.782353228856722 | 0.435293542286556 | 0.217646771143278 |
45 | 0.797662920721426 | 0.404674158557147 | 0.202337079278574 |
46 | 0.898354404500992 | 0.203291190998017 | 0.101645595499008 |
47 | 0.876890356415658 | 0.246219287168683 | 0.123109643584341 |
48 | 0.858653848981131 | 0.282692302037738 | 0.141346151018869 |
49 | 0.85715539592608 | 0.285689208147841 | 0.14284460407392 |
50 | 0.834884746872849 | 0.330230506254303 | 0.165115253127151 |
51 | 0.785695729980791 | 0.428608540038418 | 0.214304270019209 |
52 | 0.772954826807279 | 0.454090346385441 | 0.227045173192721 |
53 | 0.809578338257673 | 0.380843323484654 | 0.190421661742327 |
54 | 0.770831147074811 | 0.458337705850378 | 0.229168852925189 |
55 | 0.753727922744182 | 0.492544154511635 | 0.246272077255818 |
56 | 0.730345718803356 | 0.539308562393288 | 0.269654281196644 |
57 | 0.701912347381593 | 0.596175305236813 | 0.298087652618407 |
58 | 0.7867422343356 | 0.426515531328799 | 0.2132577656644 |
59 | 0.731444268566861 | 0.537111462866279 | 0.268555731433139 |
60 | 0.669796407678451 | 0.660407184643098 | 0.330203592321549 |
61 | 0.800781167812383 | 0.398437664375233 | 0.199218832187617 |
62 | 0.74417957616996 | 0.51164084766008 | 0.25582042383004 |
63 | 0.70410950696841 | 0.59178098606318 | 0.29589049303159 |
64 | 0.776403232124103 | 0.447193535751794 | 0.223596767875897 |
65 | 0.730615425479785 | 0.538769149040429 | 0.269384574520215 |
66 | 0.628788517161 | 0.742422965678 | 0.371211482839 |
67 | 0.72463104934399 | 0.550737901312019 | 0.275368950656009 |
68 | 0.752852786618917 | 0.494294426762166 | 0.247147213381083 |
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 |