Multiple Linear Regression - Estimated Regression Equation
Y[t] = + 98.85059602649 -14.9166390728477X[t] + 9.55899144591611M1[t] -16.0242356512141M2[t] -5.28014486754967M3[t] + 12.3672737306843M4[t] + 12.0313645143488M5[t] + 5.31545529801325M6[t] -2.52045391832229M7[t] -2.51636313465784M8[t] -1.41227235099337M9[t] + 7.17181843267108M10[t] + 0.775909216335541M11[t] + 0.215909216335541t + e[t]


Multiple Linear Regression - Ordinary Least Squares
VariableParameterS.D.T-STAT
H0: parameter = 0
2-tail p-value1-tail p-value
(Intercept)98.850596026492.30862542.81800
X-14.91663907284771.978489-7.539400
M19.558991445916112.6132363.65790.0006410.000321
M2-16.02423565121412.745086-5.837400
M3-5.280144867549672.742979-1.9250.0602980.030149
M412.36727373068432.7435484.50784.3e-052.2e-05
M512.03136451434882.7388624.39286.3e-053.2e-05
M65.315455298013252.7347941.94360.057940.02897
M7-2.520453918322292.731347-0.92280.3608310.180415
M8-2.516363134657842.728524-0.92220.3611120.180556
M9-1.412272350993372.726326-0.5180.6068790.30344
M107.171818432671082.7247552.63210.0114450.005722
M110.7759092163355412.7238120.28490.7770020.388501
t0.2159092163355410.0413855.21714e-062e-06


Multiple Linear Regression - Regression Statistics
Multiple R0.911311400399914
R-squared0.830488468498853
Adjusted R-squared0.783602300211301
F-TEST (value)17.712867116918
F-TEST (DF numerator)13
F-TEST (DF denominator)47
p-value7.07212066686225e-14
Multiple Linear Regression - Residual Statistics
Residual Standard Deviation4.30622765600411
Sum Squared Residuals871.549041390728


Multiple Linear Regression - Actuals, Interpolation, and Residuals
Time or IndexActualsInterpolation
Forecast
Residuals
Prediction Error
1111.4108.6254966887422.77450331125823
287.483.2581788079474.14182119205302
396.894.2181788079472.58182119205298
4114.1112.0815066225172.01849337748342
5110.3111.961506622517-1.66150662251656
6103.9105.461506622517-1.56150662251655
7101.697.84150662251653.75849337748346
894.698.0615066225166-3.46150662251656
995.999.3815066225166-3.48150662251655
10104.7108.181506622517-3.48150662251655
11102.8102.0015066225170.798493377483445
1298.1101.441506622517-3.34150662251656
13113.9111.2164072847682.6835927152318
1480.985.8490894039735-4.94908940397352
1595.796.8090894039735-1.10908940397351
16113.2114.672417218543-1.47241721854304
17105.9114.552417218543-8.65241721854304
18108.8108.0524172185430.747582781456949
19102.3100.4324172185431.86758278145695
2099100.652417218543-1.65241721854304
21100.7101.972417218543-1.27241721854305
22115.5110.7724172185434.72758278145695
23100.7104.592417218543-3.89241721854304
24109.9104.0324172185435.86758278145696
25114.6113.8073178807950.792682119205299
2685.488.44-3.04000000000001
27100.599.41.10000000000000
28114.8117.263327814570-2.46332781456953
29116.5117.143327814570-0.643327814569542
30112.9110.6433278145702.25667218543047
31102103.023327814570-1.02332781456954
32106103.2433278145702.75667218543047
33105.3104.5633278145700.736672185430459
34118.8113.3633278145705.43667218543046
35106.1107.183327814570-1.08332781456954
36109.3106.6233278145702.67667218543046
37117.2116.3982284768210.801771523178817
3892.591.03091059602651.46908940397350
39104.2101.9909105960262.20908940397351
40112.5119.854238410596-7.35423841059602
41122.4119.7342384105962.66576158940398
42113.3113.2342384105960.0657615894039687
43100105.614238410596-5.61423841059603
44110.7105.8342384105964.86576158940398
45112.8107.1542384105965.64576158940397
46109.8115.954238410596-6.15423841059603
47117.3109.7742384105967.52576158940397
48109.1109.214238410596-0.114238410596029
49115.9118.989139072848-3.08913907284767
509693.6218211920532.37817880794700
5199.8104.581821192053-4.78182119205298
52116.8107.5285099337759.27149006622517
53115.7107.4085099337758.29149006622516
5499.4100.908509933775-1.50850993377483
5594.393.28850993377481.01149006622516
569193.5085099337748-2.50850993377483
5793.294.8285099337748-1.62850993377483
58103.1103.628509933775-0.528509933774839
5994.197.4485099337748-3.34850993377484
6091.896.8885099337748-5.08850993377484
61102.7106.663410596026-3.96341059602648


Goldfeld-Quandt test for Heteroskedasticity
p-valuesAlternative Hypothesis
breakpoint indexgreater2-sidedless
170.2532787616774220.5065575233548450.746721238322578
180.2981590546067970.5963181092135940.701840945393203
190.182101150420170.364202300840340.81789884957983
200.1621750295122010.3243500590244020.837824970487799
210.1402754986653040.2805509973306080.859724501334696
220.2810991394553180.5621982789106360.718900860544682
230.2421143619285970.4842287238571940.757885638071403
240.3755543730229730.7511087460459470.624445626977027
250.2808540853769170.5617081707538340.719145914623083
260.2333114762387260.4666229524774530.766688523761273
270.1638838735277590.3277677470555190.83611612647224
280.1233892802492980.2467785604985950.876610719750702
290.1554732871513110.3109465743026210.84452671284869
300.1137963451020780.2275926902041560.886203654897922
310.08314097896838910.1662819579367780.916859021031611
320.07433330036788740.1486666007357750.925666699632113
330.05737384751734320.1147476950346860.942626152482657
340.05425659879979160.1085131975995830.945743401200208
350.04383465300738360.08766930601476730.956165346992616
360.02542637187349560.05085274374699110.974573628126504
370.01430433500089360.02860867000178710.985695664999106
380.00983591732181550.0196718346436310.990164082678185
390.004655055442540890.009310110885081780.99534494455746
400.0816514346053670.1633028692107340.918348565394633
410.1161697485683980.2323394971367960.883830251431602
420.06619805687803470.1323961137560690.933801943121965
430.1770836410424440.3541672820848880.822916358957556
440.1260056585454890.2520113170909780.87399434145451


Meta Analysis of Goldfeld-Quandt test for Heteroskedasticity
Description# significant tests% significant testsOK/NOK
1% type I error level10.0357142857142857NOK
5% type I error level30.107142857142857NOK
10% type I error level50.178571428571429NOK