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
VariableParameterS.D.T-STAT
H0: parameter = 0
2-tail p-value1-tail p-value
(Intercept)15515.9166666667129.27789120.019900
M1-2132.84102182539159.023856-13.412100
M2-2859.02430555556158.904073-17.992100
M3-1507.77901785714158.79562-9.495100
M4-2251.39087301587158.69852-14.186600
M5-1687.43129960317158.612794-10.638700
M6-2357.90029761905158.538461-14.872700
M7-2422.36929563492158.475536-15.285400
M8-2104.69543650794158.424034-13.285200
M9-2896.45014880952158.383965-18.287500
M10-2143.9191468254158.355338-13.538700
M11-2478.67385912698158.338159-15.654300
t77.75471230158731.34664557.739600


Multiple Linear Regression - Regression Statistics
Multiple R0.99130582514897
R-squared0.98268723897428
Adjusted R-squared0.979761138519229
F-TEST (value)335.83510001438
F-TEST (DF numerator)12
F-TEST (DF denominator)71
p-value0
Multiple Linear Regression - Residual Statistics
Residual Standard Deviation296.212858097258
Sum Squared Residuals6229686.06845237


Multiple Linear Regression - Actuals, Interpolation, and Residuals
Time or IndexActualsInterpolation
Forecast
Residuals
Prediction Error
11332813460.8303571428-132.830357142841
21287312812.401785714360.5982142857118
31400014241.4017857143-241.401785714286
41347713575.5446428571-98.5446428571415
51423714217.258928571419.7410714285705
61367413624.544642857149.4553571428556
71352913637.8303571429-108.830357142857
81405814033.258928571424.7410714285711
91297513319.2589285714-344.258928571428
101432614149.5446428571176.455357142858
111400813892.5446428571115.455357142857
121619316448.9732142857-255.973214285715
131448314393.886904761989.1130952380893
141401113745.4583333333265.541666666667
151505715174.4583333333-117.458333333334
161488414508.6011904762375.398809523809
171541415150.3154761905263.684523809524
181444014557.6011904762-117.601190476191
191490014570.8869047619329.113095238095
201507414966.3154761905107.684523809524
211444214252.3154761905189.684523809523
221530715082.6011904762224.398809523809
231493814825.6011904762112.398809523809
241719317382.0297619048-189.029761904762
251552815326.943452381201.056547619045
261476514678.514880952486.4851190476193
271583816107.5148809524-269.514880952381
281572315441.6577380952281.342261904761
291615016083.372023809566.6279761904764
301548615490.6577380952-4.65773809523786
311598615503.943452381482.056547619047
321598315899.372023809583.6279761904761
331569215185.3720238095506.627976190476
341649016015.6577380952474.342261904762
351568615758.6577380952-72.657738095238
361889718315.0863095238581.91369047619
37163161626055.9999999999979
381563615611.571428571424.4285714285715
391716317040.5714285714122.428571428571
401653416374.7142857143159.285714285714
411651817016.4285714286-498.428571428571
421637516423.7142857143-48.7142857142854
431629016437-147
441635216832.4285714286-480.428571428571
451594316118.4285714286-175.428571428572
461636216948.7142857143-586.714285714286
471639316691.7142857143-298.714285714286
481905119248.1428571429-197.142857142858
491674717193.056547619-446.05654761905
501632016544.6279761905-224.627976190476
511791017973.6279761905-63.6279761904762
521696117307.7708333333-346.770833333333
531748017949.4851190476-469.485119047619
541704917356.7708333333-307.770833333333
551687917370.056547619-491.056547619047
561747317765.4851190476-292.485119047619
571699817051.4851190476-53.485119047619
581730717881.7708333333-574.770833333333
591741817624.7708333333-206.770833333333
602016920181.1994047619-12.1994047619044
611787118126.1130952381-255.113095238097
621722617477.6845238095-251.684523809523
631906218906.6845238095155.315476190476
641780418240.8273809524-436.827380952381
651910018882.5416666667217.458333333333
661852218289.8273809524232.172619047619
671806018303.1130952381-243.113095238095
681886918698.5416666667170.458333333333
691812717984.5416666667142.458333333333
701887118814.827380952456.1726190476177
711889018557.8273809524332.172619047619
722126321114.255952381148.744047619049
731954719059.1696428571487.830357142855
741845018410.741071428639.2589285714298
752025419839.7410714286414.25892857143
761924019173.883928571466.1160714285716
772021619815.5982142857400.401785714287
781942019222.8839285714197.116071428572
791941519236.1696428571178.830357142857
802001819631.5982142857386.401785714286
811865218917.5982142857-265.598214285714
821997819747.8839285714230.116071428572
831950919490.883928571418.1160714285716
842197122047.3125-76.312499999999


Goldfeld-Quandt test for Heteroskedasticity
p-valuesAlternative Hypothesis
breakpoint indexgreater2-sidedless
160.04807963237522160.09615926475044320.951920367624778
170.0132432466795160.0264864933590320.986756753320484
180.0432107824099890.0864215648199780.956789217590011
190.03150849691365530.06301699382731050.968491503086345
200.01529339052663590.03058678105327180.984706609473364
210.01588121317252550.03176242634505090.984118786827475
220.009666826143101660.01933365228620330.990333173856898
230.00630198435563810.01260396871127620.993698015644362
240.003190945416509940.006381890833019880.99680905458349
250.0014335261891970.0028670523783940.998566473810803
260.002121100964841360.004242201929682730.997878899035159
270.002386156970930020.004772313941860040.99761384302907
280.001314200230774630.002628400461549270.998685799769225
290.001044632477167160.002089264954334330.998955367522833
300.0005141694604559460.001028338920911890.999485830539544
310.0007761227672640410.001552245534528080.999223877232736
320.0004520141868784450.0009040283737568890.999547985813122
330.002391049005310540.004782098010621090.997608950994689
340.004815882714226730.009631765428453470.995184117285773
350.00686617241902950.0137323448380590.99313382758097
360.1022724671424720.2045449342849440.897727532857528
370.1133385592149830.2266771184299660.886661440785017
380.1597194998159210.3194389996318420.840280500184079
390.1391865740741330.2783731481482650.860813425925868
400.2915853737927790.5831707475855580.708414626207221
410.5844744741667810.8310510516664390.415525525833219
420.5646397968089580.8707204063820840.435360203191042
430.7026217469768750.594756506046250.297378253023125
440.7823532288567260.4352935422865470.217646771143274
450.7976629207214270.4046741585571470.202337079278573
460.8983544045009910.2032911909980180.101645595499009
470.8768903564156580.2462192871686830.123109643584341
480.8586538489811270.2826923020377460.141346151018873
490.8571553959260810.2856892081478370.142844604073919
500.8348847468728490.3302305062543030.165115253127151
510.7856957299807930.4286085400384150.214304270019207
520.7729548268072780.4540903463854440.227045173192722
530.8095783382576720.3808433234846570.190421661742328
540.7708311470748130.4583377058503740.229168852925187
550.7537279227441820.4925441545116350.246272077255818
560.7303457188033610.5393085623932790.269654281196639
570.7019123473816020.5961753052367970.298087652618398
580.7867422343355980.4265155313288030.213257765664402
590.7314442685668570.5371114628662860.268555731433143
600.6697964076784690.6604071846430610.330203592321531
610.8007811678123820.3984376643752370.199218832187618
620.7441795761699590.5116408476600810.255820423830041
630.7041095069684130.5917809860631730.295890493031587
640.7764032321241030.4471935357517940.223596767875897
650.7306154254797840.5387691490404330.269384574520216
660.628788517161020.7424229656779610.37121148283898
670.7246310493439880.5507379013120230.275368950656012
680.7528527866189180.4942944267621630.247147213381082


Meta Analysis of Goldfeld-Quandt test for Heteroskedasticity
Description# significant tests% significant testsOK/NOK
1% type I error level110.207547169811321NOK
5% type I error level170.320754716981132NOK
10% type I error level200.377358490566038NOK