Multiple Linear Regression - Estimated Regression Equation
y[t] = + 2680.53846153846 -160.592948717948x[t] + 275.731997863248M1[t] -161.869337606838M2[t] -220.114262820513M3[t] -186.959188034188M4[t] + 4.1958867521367M5[t] -370.449038461539M6[t] -174.893963675214M7[t] + 24.061111111111M8[t] -117.383814102564M9[t] + 122.489850427350M10[t] + 27.644925213675M11[t] -5.1550747863248t + e[t]


Multiple Linear Regression - Ordinary Least Squares
VariableParameterS.D.T-STAT
H0: parameter = 0
2-tail p-value1-tail p-value
(Intercept)2680.53846153846149.45217717.935800
x-160.592948717948144.28271-1.1130.271350.135675
M1275.731997863248167.7275731.64390.1068650.053432
M2-161.869337606838176.134943-0.9190.3627840.181392
M3-220.114262820513175.815035-1.2520.2167770.108389
M4-186.959188034188175.589494-1.06480.2924280.146214
M54.1958867521367175.4586830.02390.9810230.490511
M6-370.449038461539175.422814-2.11170.0400520.020026
M7-174.893963675214175.481946-0.99660.3240380.162019
M824.061111111111175.6359810.1370.8916210.44581
M9-117.383814102564175.884672-0.66740.5077860.253893
M10122.489850427350175.0190250.69990.4874610.24373
M1127.644925213675174.8761170.15810.8750690.437534
t-5.15507478632484.082598-1.26270.2129280.106464


Multiple Linear Regression - Regression Statistics
Multiple R0.681821185658193
R-squared0.464880129212344
Adjusted R-squared0.316868250058311
F-TEST (value)3.14082985682895
F-TEST (DF numerator)13
F-TEST (DF denominator)47
p-value0.00197903783503728
Multiple Linear Regression - Residual Statistics
Residual Standard Deviation276.428059356235
Sum Squared Residuals3591386.18397436


Multiple Linear Regression - Actuals, Interpolation, and Residuals
Time or IndexActualsInterpolation
Forecast
Residuals
Prediction Error
130162951.1153846153864.8846153846178
221552508.35897435897-353.358974358975
321722444.95897435897-272.958974358973
421502472.95897435897-322.958974358975
525332658.95897435897-125.958974358975
620582279.15897435897-221.158974358974
721602469.55897435897-309.558974358974
822602663.35897435897-403.358974358974
924982516.75897435897-18.7589743589748
1026952751.47756410256-56.4775641025641
1127992651.47756410256147.522435897436
1229462618.67756410256327.322435897436
1329302889.2544871794940.745512820512
1423182446.49807692308-128.498076923077
1525402383.09807692308156.901923076923
1625702411.09807692308158.901923076923
1726692597.0980769230871.9019230769229
1824502217.29807692308232.701923076923
1928422407.69807692308434.301923076923
2034402601.49807692308838.501923076923
2126782454.89807692308223.101923076923
2229812689.61666666667291.383333333333
2322602589.61666666667-329.616666666667
2428442556.81666666667287.183333333333
2525462827.39358974359-281.393589743590
2624562384.6371794871871.3628205128206
2722952321.23717948718-26.2371794871795
2823792349.2371794871829.7628205128207
2924792535.23717948718-56.2371794871795
3020572155.43717948718-98.4371794871793
3122802345.83717948718-65.8371794871794
3223512539.63717948718-188.637179487179
3322762393.03717948718-117.037179487179
3425482467.1628205128280.8371794871794
3523112367.16282051282-56.1628205128206
3622012334.36282051282-133.362820512821
3727252604.93974358974120.060256410256
3824082162.18333333333245.816666666667
3921392098.7833333333340.2166666666665
4018982126.78333333333-228.783333333333
4125372312.78333333333224.216666666666
4220681932.98333333333135.016666666667
4320632123.38333333333-60.3833333333333
4425202317.18333333333202.816666666667
4524342170.58333333333263.416666666667
4621902405.30192307692-215.301923076923
4727942305.30192307692488.698076923077
4820702272.50192307692-202.501923076923
4926152543.0788461538571.9211538461533
5022652100.32243589744164.677564102564
5121392036.92243589744102.077564102564
5224282064.92243589744363.077564102564
5321372250.92243589744-113.922435897436
5418231871.12243589744-48.1224358974356
5520632061.522435897441.47756410256428
5618062255.32243589744-449.322435897436
5717582108.72243589744-350.722435897436
5822432343.44102564103-100.441025641025
5919932243.44102564103-250.441025641025
6019322210.64102564103-278.641025641025
6124652481.21794871795-16.2179487179491


Goldfeld-Quandt test for Heteroskedasticity
p-valuesAlternative Hypothesis
breakpoint indexgreater2-sidedless
170.2442320660862290.4884641321724580.755767933913771
180.1530333260996880.3060666521993770.846966673900312
190.2404377900379190.4808755800758380.759562209962081
200.8313459773594910.3373080452810170.168654022640509
210.7780515472964240.4438969054071530.221948452703576
220.7393619056543880.5212761886912250.260638094345612
230.931226559694590.1375468806108200.0687734403054099
240.9602807041955960.07943859160880790.0397192958044039
250.9867346360891420.0265307278217150.0132653639108575
260.9752697244235030.04946055115299320.0247302755764966
270.9621143129978420.0757713740043150.0378856870021575
280.9389814670136180.1220370659727640.0610185329863818
290.9130201101300580.1739597797398840.086979889869942
300.8846530221857750.2306939556284490.115346977814225
310.846834416946980.3063311661060420.153165583053021
320.8400344414953710.3199311170092580.159965558504629
330.7906691391503190.4186617216993620.209330860849681
340.7121820567103310.5756358865793380.287817943289669
350.6816508265167730.6366983469664530.318349173483227
360.6184409619367790.7631180761264420.381559038063221
370.5392839148243370.9214321703513260.460716085175663
380.4662730523690940.9325461047381870.533726947630906
390.3793226290362240.7586452580724490.620677370963776
400.6561446553267020.6877106893465960.343855344673298
410.5408075476553070.9183849046893870.459192452344693
420.4102980042349440.8205960084698880.589701995765056
430.3690941758353930.7381883516707860.630905824164607
440.3020464400158240.6040928800316470.697953559984176


Meta Analysis of Goldfeld-Quandt test for Heteroskedasticity
Description# significant tests% significant testsOK/NOK
1% type I error level00OK
5% type I error level20.0714285714285714NOK
10% type I error level40.142857142857143NOK