Multiple Linear Regression - Estimated Regression Equation
Y[t] = + 9374.57467049922 + 1224.00784219445X[t] + 0.0977062231002342Y1[t] + 0.115952759659355Y2[t] + 0.182520307490899Y3[t] + 724.35433075174M1[t] + 3884.92719146509M2[t] + 1126.73655843838M3[t] + 815.94703196878M4[t] + 2970.75504633567M5[t] + 924.990992066053M6[t] -1503.43996923854M7[t] + 2712.33484127727M8[t] + 2530.80527012911M9[t] + 2003.66072271356M10[t] -1276.19185810045M11[t] + 10.7061192035070t + e[t]


Multiple Linear Regression - Ordinary Least Squares
VariableParameterS.D.T-STAT
H0: parameter = 0
2-tail p-value1-tail p-value
(Intercept)9374.574670499224382.6376922.1390.0373410.01867
X1224.00784219445508.1315032.40880.0197290.009865
Y10.09770622310023420.1551020.62990.5315980.265799
Y20.1159527596593550.148310.78180.4380030.219001
Y30.1825203074908990.1524851.1970.2369610.118481
M1724.35433075174885.5241560.8180.4172410.208621
M23884.927191465091009.6605853.84780.0003390.000169
M31126.736558438381123.544221.00280.3207660.160383
M4815.94703196878929.4637140.87790.3842140.192107
M52970.75504633567841.0758873.53210.0008970.000449
M6924.9909920660531055.7927170.87610.385160.19258
M7-1503.43996923854910.49508-1.65120.1049590.052479
M82712.33484127727880.5964493.08010.0033590.001679
M92530.805270129111204.3316152.10140.0406650.020333
M102003.660722713561199.4338411.67050.1010690.050534
M11-1276.19185810045916.869508-1.39190.1701130.085057
t10.706119203507013.8910990.77070.4445010.22225


Multiple Linear Regression - Regression Statistics
Multiple R0.925534667128993
R-squared0.856614420057577
Adjusted R-squared0.810731034476001
F-TEST (value)18.6693812847488
F-TEST (DF numerator)16
F-TEST (DF denominator)50
p-value9.9920072216264e-16
Multiple Linear Regression - Residual Statistics
Residual Standard Deviation1304.49441924886
Sum Squared Residuals85085284.4925715


Multiple Linear Regression - Actuals, Interpolation, and Residuals
Time or IndexActualsInterpolation
Forecast
Residuals
Prediction Error
119435.120733.0066871605-1297.90668716053
222686.823225.9936841678-539.193684167838
320396.720839.1554091511-442.455409151094
419233.620864.3839587577-1630.78395875766
52275123244.2138532124-493.213853212446
61986420999.9733763344-1135.97337633439
717165.418507.9736137480-1342.57361374802
822309.722778.0258422410-468.325842240976
921786.322282.2263472698-495.926347269849
1021927.621843.075118451784.5248815482946
1120957.919502.70432485081455.19567514917
121972620603.4694951917-877.469495191672
1321315.721119.2762988946196.423701105413
1424771.524113.8066364537657.693363546343
1522592.421663.4586236527928.941376347327
1621942.121841.3256652779100.774334722052
1723973.724321.3824620196-347.682462019612
1820815.722011.6904081440-1195.99040814404
1919931.419414.5260624770516.873937523033
2024436.823559.234820803877.565179196982
2122838.723161.9209084131-323.220908413080
2224465.322850.34902051961614.95097948040
2323007.320658.67619326662348.62380673344
2422720.821712.2816311731008.51836882699
2523045.722547.1776567914498.522343208602
2627198.525720.14803991221478.35196008783
2722401.923424.9993050065-1023.09930500651
2825122.723209.32777465701913.37222534305
2926100.526013.833423911886.6665760881643
3022904.923624.4807011610-719.580701160957
3122040.421724.8271251319315.572874868083
3225981.525723.731056566257.768943433971
3326157.125487.0360351552670.063964844769
3425975.425397.1081407847578.29185921532
3522589.823057.9818800585-468.181880058498
3625370.424122.98824537521247.41175462485
3725091.124691.7569378872399.343062112842
3828760.927736.06531491081024.83468508915
3924325.925944.6742440767-1618.77424407666
4025821.725585.8092528767235.890747123276
4127645.728248.8761450524-603.176145052429
4226296.925853.9195624730442.980437526976
4324141.523813.4004330618328.09956693822
4427268.128140.4461907871-872.346190787106
4529060.327742.28281180831318.01718819168
4628226.427382.3271826435844.072817356496
4723268.524859.1423445400-1590.64234454005
4826938.225892.04252714061046.1574728594
4927217.526209.60931878721007.89068121278
5027540.528953.2522132727-1412.75221327267
5129167.627012.94765821472154.65234178528
5226671.526960.2727098072-288.772709807198
533018429068.32274234871115.67725765132
5428422.327543.1280443401879.171955659858
5523774.325002.8899051544-1228.58990515438
562960129395.6620896029205.337910397129
5728523.629692.5338973535-1168.93389735352
582362226743.8405376005-3121.84053760050
5921320.323065.2952572841-1744.99525728407
6020423.622848.2181011196-2424.61810111956
6121174.921979.1731004791-804.273100479103
6223050.224259.1341112828-1208.93411128282
6321202.921202.16475989830.735240101653204
6420476.420806.8806386235-330.480638623518
6523173.322931.571373455241.728626545
662246820738.60790754741729.39209245255
6719842.718432.08286042691410.61713957306


Goldfeld-Quandt test for Heteroskedasticity
p-valuesAlternative Hypothesis
breakpoint indexgreater2-sidedless
200.08160564986103190.1632112997220640.918394350138968
210.02996176134267730.05992352268535460.970038238657323
220.01134985811411850.02269971622823700.988650141885882
230.007229063103817570.01445812620763510.992770936896182
240.01122821670040810.02245643340081610.988771783299592
250.007652746274358960.01530549254871790.99234725372564
260.003691580596699010.007383161193398020.9963084194033
270.02020677710173780.04041355420347560.979793222898262
280.02133751901517600.04267503803035190.978662480984824
290.01191097418620050.02382194837240110.9880890258138
300.01128848770947650.02257697541895290.988711512290524
310.006217302371210230.01243460474242050.99378269762879
320.002893062043017920.005786124086035840.997106937956982
330.001511501932229670.003023003864459340.99848849806777
340.0006533759295736660.001306751859147330.999346624070426
350.003592707496510430.007185414993020850.99640729250349
360.002092699072921520.004185398145843040.997907300927078
370.0009180905257131330.001836181051426270.999081909474287
380.0007463948495886020.001492789699177200.999253605150411
390.001289292588635160.002578585177270310.998710707411365
400.0005826278730341160.001165255746068230.999417372126966
410.0005595974355520290.001119194871104060.999440402564448
420.001499526422867080.002999052845734160.998500473577133
430.005434353977198580.01086870795439720.994565646022801
440.02415377366516230.04830754733032450.975846226334838
450.1363072004075080.2726144008150160.863692799592492
460.1023433993084950.2046867986169900.897656600691505
470.1183131662947880.2366263325895770.881686833705212


Meta Analysis of Goldfeld-Quandt test for Heteroskedasticity
Description# significant tests% significant testsOK/NOK
1% type I error level120.428571428571429NOK
5% type I error level230.821428571428571NOK
10% type I error level240.857142857142857NOK