Multiple Linear Regression - Estimated Regression Equation
HPC[t] = + 131.905882352941 -0.54803921568628M1[t] -6.36274509803925M2[t] -10.7264705882353M3[t] -13.0901960784314M4[t] -19.0539215686275M5[t] -17.2176470588236M6[t] + 14.4186274509804M7[t] + 20.8549019607843M8[t] + 18.8911764705882M9[t] + 8.72745098039215M10[t] + 1.16372549019607M11[t] -0.436274509803922t + e[t]


Multiple Linear Regression - Ordinary Least Squares
VariableParameterS.D.T-STAT
H0: parameter = 0
2-tail p-value1-tail p-value
(Intercept)131.9058823529414.84068527.249400
M1-0.548039215686285.645378-0.09710.9230690.461535
M2-6.362745098039255.925421-1.07380.2882790.144139
M3-10.72647058823535.917854-1.81260.0761560.038078
M4-13.09019607843145.911076-2.21450.0315750.015787
M5-19.05392156862755.905088-3.22670.0022580.001129
M6-17.21764705882365.899894-2.91830.0053420.002671
M714.41862745098045.8954962.44570.0181740.009087
M820.85490196078435.8918943.53960.0009020.000451
M918.89117647058825.8890923.20780.0023830.001192
M108.727450980392155.8870891.48250.1447510.072375
M111.163725490196075.8858870.19770.8441030.422052
t-0.4362745098039220.068678-6.352500


Multiple Linear Regression - Regression Statistics
Multiple R0.868715394112654
R-squared0.754666435968303
Adjusted R-squared0.693333044960379
F-TEST (value)12.3043324943635
F-TEST (DF numerator)12
F-TEST (DF denominator)48
p-value7.01978475348142e-11
Multiple Linear Regression - Residual Statistics
Residual Standard Deviation9.3057716295273
Sum Squared Residuals4156.67450980392


Multiple Linear Regression - Actuals, Interpolation, and Residuals
Time or IndexActualsInterpolation
Forecast
Residuals
Prediction Error
1130130.921568627451-0.921568627450961
2127124.6705882352942.32941176470585
3122119.8705882352942.12941176470588
4117117.070588235294-0.0705882352940977
5112110.6705882352941.32941176470590
6113112.0705882352940.929411764705907
7149143.2705882352945.7294117647059
8157149.2705882352947.7294117647059
9157146.87058823529410.1294117647059
10147136.27058823529410.7294117647059
11137128.2705882352948.72941176470587
12132126.6705882352945.32941176470587
13125125.686274509804-0.686274509803949
14123119.4352941176473.56470588235295
15117114.6352941176472.36470588235294
16114111.8352941176472.16470588235293
17111105.4352941176475.56470588235293
18112106.8352941176475.16470588235293
19144138.0352941176475.96470588235293
20150144.0352941176475.96470588235294
21149141.6352941176477.36470588235293
22134131.0352941176472.96470588235294
23123123.035294117647-0.0352941176470617
24116121.435294117647-5.43529411764707
25117120.450980392157-3.45098039215686
26111114.2-3.19999999999999
27105109.4-4.4
28102106.6-4.60000000000001
2995100.2-5.20000000000001
3093101.6-8.60000000000001
31124132.8-8.8
32130138.8-8.8
33124136.4-12.4
34115125.8-10.8
35106117.8-11.8
36105116.2-11.2
37105115.215686274510-10.2156862745098
38101108.964705882353-7.96470588235293
3995104.164705882353-9.16470588235294
4093101.364705882353-8.36470588235295
418494.964705882353-10.9647058823529
428796.364705882353-9.36470588235294
43116127.564705882353-11.5647058823529
44120133.564705882353-13.5647058823529
45117131.164705882353-14.1647058823529
46109120.564705882353-11.5647058823529
47105112.564705882353-7.56470588235293
48107110.964705882353-3.96470588235294
49109109.980392156863-0.98039215686274
50109103.7294117647065.27058823529413
5110898.92941176470599.07058823529412
5210796.129411764705910.8705882352941
539989.72941176470599.27058823529412
5410391.129411764705911.8705882352941
55131122.3294117647068.67058823529412
56137128.3294117647068.67058823529412
57135125.9294117647069.07058823529411
58124115.3294117647068.67058823529412
59118107.32941176470610.6705882352941
60121105.72941176470615.2705882352941
61121104.74509803921616.2549019607843


Goldfeld-Quandt test for Heteroskedasticity
p-valuesAlternative Hypothesis
breakpoint indexgreater2-sidedless
160.0004508485980433930.0009016971960867860.999549151401957
170.0004413393254655680.0008826786509311360.999558660674534
180.0001379589098441430.0002759178196882850.999862041090156
193.29025479413239e-056.58050958826478e-050.999967097452059
202.79751049813844e-055.59502099627688e-050.999972024895019
214.51424349777160e-059.02848699554319e-050.999954857565022
220.0008306836639050030.001661367327810010.999169316336095
230.004086182806498450.00817236561299690.995913817193502
240.01202539346540210.02405078693080410.987974606534598
250.008832265516328080.01766453103265620.991167734483672
260.008345287353619330.01669057470723870.99165471264638
270.007428841766204520.01485768353240900.992571158233795
280.005690599714158470.01138119942831690.994309400285841
290.008502931616890650.01700586323378130.99149706838311
300.01370473249263280.02740946498526550.986295267507367
310.04337200493188960.08674400986377910.95662799506811
320.1430452645728920.2860905291457850.856954735427108
330.4289493897042350.857898779408470.571050610295765
340.7328722027579140.5342555944841730.267127797242086
350.897453014048510.2050939719029790.102546985951490
360.960823523269330.07835295346133960.0391764767306698
370.998975244544070.002049510911860170.00102475545593009
380.999928529936040.0001429401279205997.14700639602997e-05
390.9998273294301290.0003453411397426110.000172670569871306
400.9994488742919560.001102251416088330.000551125708044163
410.9979938432671620.004012313465675430.00200615673283772
420.9940857258669850.01182854826603030.00591427413301517
430.9814340553615340.03713188927693230.0185659446384661
440.9659987141681360.06800257166372870.0340012858318643
450.9873504144485050.02529917110298950.0126495855514948


Meta Analysis of Goldfeld-Quandt test for Heteroskedasticity
Description# significant tests% significant testsOK/NOK
1% type I error level130.433333333333333NOK
5% type I error level230.766666666666667NOK
10% type I error level260.866666666666667NOK