Multiple Linear Regression - Estimated Regression Equation
Y[t] = + 12017.7830247441 -174.383836222070X[t] -719.912886653628M1[t] -823.449856480296M2[t] -765.857775875422M3[t] -449.979957771428M4[t] -864.265695270547M5[t] -588.434180183885M6[t] -686.588928026133M7[t] -679.82747414218M8[t] -132.737858192417M9[t] -513.330989656872M10[t] -419.160565518212M11[t] + e[t]


Multiple Linear Regression - Ordinary Least Squares
VariableParameterS.D.T-STAT
H0: parameter = 0
2-tail p-value1-tail p-value
(Intercept)12017.78302474411895.3759486.340600
X-174.38383622207046.980391-3.71180.0005440.000272
M1-719.912886653628375.895987-1.91520.0615640.030782
M2-823.449856480296375.542108-2.19270.0333150.016657
M3-765.857775875422375.029626-2.04210.0467720.023386
M4-449.979957771428374.846949-1.20040.2359850.117993
M5-864.265695270547374.568512-2.30740.0254870.012743
M6-588.434180183885374.432193-1.57150.1227660.061383
M7-686.588928026133373.759183-1.8370.072540.03627
M8-679.82747414218372.975923-1.82270.0747120.037356
M9-132.737858192417372.841934-0.3560.7234210.361711
M10-513.330989656872372.781014-1.3770.1750260.087513
M11-419.160565518212372.756004-1.12450.2665150.133258


Multiple Linear Regression - Regression Statistics
Multiple R0.562255368238571
R-squared0.316131099113091
Adjusted R-squared0.141526273354732
F-TEST (value)1.81055190049898
F-TEST (DF numerator)12
F-TEST (DF denominator)47
p-value0.0738665033626638
Multiple Linear Regression - Residual Statistics
Residual Standard Deviation589.359817260218
Sum Squared Residuals16325214.7274469


Multiple Linear Regression - Actuals, Interpolation, and Residuals
Time or IndexActualsInterpolation
Forecast
Residuals
Prediction Error
155604901.47102546502658.528974534976
239224794.44637891388-872.446378913876
337594850.29462115653-1091.29462115653
441385164.4286008983-1026.42860089830
546344748.39902503696-114.399025036963
639965024.23054012363-1028.23054012363
743084901.66205521029-593.662055210287
844294831.69462115653-402.69462115653
952195364.83353020853-145.833530208527
1049294979.00888365741-50.0088836574102
1157555057.48476253608697.515237463916
1255925448.74391425876143.256085741236
1341634728.83102760514-565.831027605136
1449624618.31870432959343.681295670415
1552084663.70391639891544.296083601085
1647554977.83789614069-222.837896140689
1744914554.83296683046-63.8329668304644
1857324823.68912846824908.310871531756
1957314645.317815963841085.68218403616
2050404610.2271491545429.772850845499
2161025132.90302803317969.096971966826
2249044733.12767458429170.872325415709
2353694815.09123018741553.908769812594
2455785230.76411898118347.235881018824
2546194507.36355560311111.636444396893
2647314375.92517198091355.074828019092
2750114426.5418991369584.458100863101
2852994738.93204051645560.067959483547
2941464296.7448892218-150.744889221801
3046254569.0887275840255.9112724159788
3147364453.49559611957282.504403880433
3242194376.55280861693-157.552808616926
3351164876.55878878673239.441211213269
3442054494.22181896005-289.221818960054
3541214576.18537456317-455.185374563169
3651034993.60210171916109.397898280839
3743004270.2015383410929.7984616589081
3845784159.68921506554418.31078493446
3938094206.81826549709-397.818265497091
4055264517.464568514421008.53543148558
4142474094.4596392042152.540360795800
4238304370.29115429086-540.291154290862
4343944245.9788310153148.021168984697
4448264233.55806291483592.441937085171
4544094775.41616377793-366.416163777929
4645694370.40929524239198.590704757615
4741064462.83588101882-356.835881018823
4847944862.81422455261-68.8142245526083
4939144148.13285298564-234.132852985642
5037934037.62052971009-244.620529710091
5144054044.64129781057360.358702189434
5240224341.33689393013-319.336893930132
5341003923.56347970657176.436520293429
5447884183.70044953325604.299550466753
5531634085.545701691-922.545701690999
5635854046.96735815721-461.967358157214
5739034599.28848919364-696.288489193638
5841784208.23232755586-30.2323275558589
5938634302.40275169452-439.402751694519
6041874718.07564048829-531.07564048829


Goldfeld-Quandt test for Heteroskedasticity
p-valuesAlternative Hypothesis
breakpoint indexgreater2-sidedless
160.987182754660950.02563449067809780.0128172453390489
170.982538269739660.03492346052068140.0174617302603407
180.9882490518794520.02350189624109540.0117509481205477
190.9854849313116760.02903013737664840.0145150686883242
200.9714871919805220.05702561603895590.0285128080194780
210.9647894186782950.07042116264341070.0352105813217054
220.9596014053510120.08079718929797650.0403985946489882
230.9693199591992030.06136008160159390.0306800408007969
240.9540594588873780.09188108222524390.0459405411126220
250.9494679042098260.1010641915803480.0505320957901738
260.9198645832018950.1602708335962100.0801354167981048
270.8827967645855740.2344064708288520.117203235414426
280.8328669736086450.334266052782710.167133026391355
290.8571938995944490.2856122008111020.142806100405551
300.8313360550608330.3373278898783340.168663944939167
310.7955709897154940.4088580205690120.204429010284506
320.788964524734480.4220709505310390.211035475265520
330.7783654886385180.4432690227229650.221634511361482
340.789231132765680.4215377344686390.210768867234320
350.8235293208928660.3529413582142670.176470679107134
360.7536150428361950.4927699143276110.246384957163806
370.6675220080752060.6649559838495880.332477991924794
380.5861048115959470.8277903768081060.413895188404053
390.6425654356677110.7148691286645770.357434564332289
400.7090380907986750.5819238184026510.290961909201325
410.5995098285051410.8009803429897170.400490171494859
420.948482120157030.1030357596859400.0515178798429699
430.9520041441970510.09599171160589790.0479958558029490
440.9890430951145130.02191380977097380.0109569048854869


Meta Analysis of Goldfeld-Quandt test for Heteroskedasticity
Description# significant tests% significant testsOK/NOK
1% type I error level00OK
5% type I error level50.172413793103448NOK
10% type I error level110.379310344827586NOK