Multiple Linear Regression - Estimated Regression Equation
inv[t] = -98.6031754376958 + 1.81249154252463cons[t] -10.1515734108020M1[t] -10.2323024500268M2[t] -10.1369413355362M3[t] -7.44036083710648M4[t] -8.40747637998386M5[t] -1.19343749233295M6[t] + 8.4281775125963M7[t] + 1.59241261367585M8[t] + 5.03144811833661M9[t] + 6.55181126262129M10[t] + 9.91851760828455M11[t] + 0.122127045043892t + e[t]


Multiple Linear Regression - Ordinary Least Squares
VariableParameterS.D.T-STAT
H0: parameter = 0
2-tail p-value1-tail p-value
(Intercept)-98.603175437695829.989951-3.28790.0019390.00097
cons1.812491542524630.2813356.442500
M1-10.15157341080206.604696-1.5370.1311380.065569
M2-10.23230245002688.846138-1.15670.2533680.126684
M3-10.13694133553628.570762-1.18270.2429910.121496
M4-7.440360837106487.712021-0.96480.3397030.169851
M5-8.407476379983867.913696-1.06240.2936020.146801
M6-1.193437492332956.703974-0.1780.8594890.429745
M78.42817751259636.6332681.27060.2102630.105131
M81.592412613675858.2846020.19220.8484210.42421
M95.031448118336616.8469580.73480.4661640.233082
M106.551811262621296.7411490.97190.3361770.168088
M119.918517608284557.9805171.24280.2202240.110112
t0.1221270450438920.0783711.55830.1260110.063005


Multiple Linear Regression - Regression Statistics
Multiple R0.86276085439231
R-squared0.744356291871749
Adjusted R-squared0.67210915696594
F-TEST (value)10.3029177951787
F-TEST (DF numerator)13
F-TEST (DF denominator)46
p-value1.11456865958814e-09
Multiple Linear Regression - Residual Statistics
Residual Standard Deviation10.2131534985726
Sum Squared Residuals4798.19120172865


Multiple Linear Regression - Actuals, Interpolation, and Residuals
Time or IndexActualsInterpolation
Forecast
Residuals
Prediction Error
183.488.5664580232261-5.16645802322608
2113.6124.132690262528-10.5326902625276
3112.9111.1189901616321.7810098383677
4104111.037711237067-7.03771123706654
5109.9126.867644930460-16.9676449304596
69997.95398001266191.04601998733814
7106.3101.8977491265564.40225087344379
8128.9121.1027403307827.79725966921819
9111.1109.2577247690271.84227523097287
10102.9109.631470878588-6.73147087858845
11130130.338973923280-0.338973923279582
128779.58027449898237.41972550101768
1387.588.0382418669755-0.538241866975468
14117.6123.604474106277-6.00447410627726
15103.4105.515797686313-2.11579768631297
16110.8113.046983240351-2.24698324035063
17112.6105.6770251894286.92297481057151
18102.5103.588235100995-1.08823510099521
19112.4115.869465310503-3.46946531050285
20135.6142.143173530575-6.54317353057452
21105.1106.735767916000-1.63576791599965
22127.7125.9594260678171.74057393218288
23137138.6919663254-1.6919663253999
249188.477014363862.52298563614
2590.598.7474732743778-8.24747327437777
26122.4126.338742726571-3.93874272657119
27123.3129.456217354145-6.15621735414507
28124.3125.387457036025-1.08745703602511
29120113.1237718202866.87622817971354
30118.1113.5724698913884.52753010861231
31119119.509979702059-0.509979702059099
32142.7141.9774556828290.722544317170941
33123.6113.45751792984810.1424820701522
34129.6123.7999675232955.80003247670542
35151.6145.7762146477535.82378535224705
36110.4108.9737001008951.42629989910470
3799.2102.750485974439-3.55048597443897
38130.5115.29807562367815.2019243763221
39136.2134.5467249797211.65327502027895
40129.7125.4029883425324.29701165746787
41128116.22053874908511.7794612509147
42121.6118.6629775169642.93702248303635
43135.8128.0442212584327.75577874156814
44143.8126.94930718638216.8506928136184
45147.5143.0166613795064.48333862049376
46136.2117.10928012246019.0907198775395
47156.6142.71051033196813.8894896680319
48123.3116.0579484232487.24205157675162
49104.586.997340860981717.5026591390183
50139.8134.5260172809465.27398271905397
51136.5131.6622698181894.83773018181137
52112.1106.0248601440266.0751398559744
53118.5127.11101931074-8.6110193107401
5494.4101.822337477992-7.42233747799158
55102.3110.47858460245-8.17858460244998
56111.4130.227323269433-18.8273232694330
5799.2114.032328005619-14.8323280056192
5887.8107.699855407839-19.8998554078394
59115.8133.482334771599-17.6823347715995
6079.798.311062613014-18.611062613014


Goldfeld-Quandt test for Heteroskedasticity
p-valuesAlternative Hypothesis
breakpoint indexgreater2-sidedless
170.1105989952040150.2211979904080310.889401004795985
180.03940885648739290.07881771297478580.960591143512607
190.01306721672307930.02613443344615860.98693278327692
200.004124957304581850.00824991460916370.995875042695418
210.003121903834058960.006243807668117920.99687809616594
220.01719375782538760.03438751565077520.982806242174612
230.007551963252635730.01510392650527150.992448036747364
240.003093725043500470.006187450087000950.9969062749565
250.001976741207177980.003953482414355970.998023258792822
260.001290960280399290.002581920560798590.9987090397196
270.0008100876601933260.001620175320386650.999189912339807
280.0007965984874669470.001593196974933890.999203401512533
290.0004115496871912790.0008230993743825580.999588450312809
300.0002468413086314140.0004936826172628280.999753158691369
310.0001322822200333310.0002645644400666630.999867717779967
326.61612990178008e-050.0001323225980356020.999933838700982
334.02360403236123e-058.04720806472245e-050.999959763959676
342.34080956225199e-054.68161912450399e-050.999976591904377
351.68394153099284e-053.36788306198569e-050.99998316058469
361.20754593279287e-052.41509186558574e-050.999987924540672
370.0002576666593854390.0005153333187708790.999742333340615
380.0002726086504483510.0005452173008967020.999727391349552
390.003378923496030560.006757846992061120.99662107650397
400.02921905634714650.0584381126942930.970780943652854
410.0940707118549130.1881414237098260.905929288145087
420.3032377902617060.6064755805234130.696762209738294
430.5899933263100430.8200133473799140.410006673689957


Meta Analysis of Goldfeld-Quandt test for Heteroskedasticity
Description# significant tests% significant testsOK/NOK
1% type I error level180.666666666666667NOK
5% type I error level210.777777777777778NOK
10% type I error level230.851851851851852NOK