Multiple Linear Regression - Estimated Regression Equation
Y[t] = + 5039.52273540422 + 0.152568870939067X[t] + 1.21721358419328Y1[t] -0.158914826056032Y2[t] -0.133371695416324Y3[t] -0.125086641034477Y4[t] -1237.48667831291M1[t] -796.231551251808M2[t] -2800.83954489340M3[t] -3149.69928454874M4[t] -830.742747890353M5[t] -166.895192124954M6[t] -1271.27324638286M7[t] -1886.8123772962M8[t] -8925.71155554022M9[t] + 834.008192265998M10[t] -272.653196521483M11[t] -28.6099017672629t + e[t]


Multiple Linear Regression - Ordinary Least Squares
VariableParameterS.D.T-STAT
H0: parameter = 0
2-tail p-value1-tail p-value
(Intercept)5039.522735404224459.3613811.13010.266120.13306
X0.1525688709390670.2696250.56590.5751010.287551
Y11.217213584193280.1774066.861200
Y2-0.1589148260560320.268997-0.59080.5584710.279236
Y3-0.1333716954163240.193218-0.69030.494580.24729
Y4-0.1250866410344770.168057-0.74430.4616570.230829
M1-1237.486678312911506.315053-0.82150.4169040.208452
M2-796.2315512518081599.277915-0.49790.621690.310845
M3-2800.839544893401352.024178-2.07160.0457370.022869
M4-3149.699284548741070.086875-2.94340.0057310.002865
M5-830.742747890353944.231106-0.87980.3849640.192482
M6-166.8951921249541010.600647-0.16510.869780.43489
M7-1271.27324638286970.723979-1.30960.1988580.099429
M8-1886.8123772962952.829009-1.98020.0555830.027791
M9-8925.711555540221009.261665-8.843800
M10834.0081922659981625.6220670.5130.6111470.305573
M11-272.6531965214831649.882392-0.16530.8696930.434847
t-28.609901767262919.311086-1.48150.1474140.073707


Multiple Linear Regression - Regression Statistics
Multiple R0.981518378713279
R-squared0.963378327751944
Adjusted R-squared0.945590658374316
F-TEST (value)54.1598962348403
F-TEST (DF numerator)17
F-TEST (DF denominator)35
p-value0
Multiple Linear Regression - Residual Statistics
Residual Standard Deviation937.106244215662
Sum Squared Residuals30735883.9531794


Multiple Linear Regression - Actuals, Interpolation, and Residuals
Time or IndexActualsInterpolation
Forecast
Residuals
Prediction Error
11620316027.4740195250175.525980475039
21743218819.1842383708-1387.18423837085
31801417531.1901193002482.809880699819
41695617164.9878649264-208.987864926352
51798217627.8626492226354.13735077738
61943519499.2398142875-64.239814287504
71999020041.3439641976-51.3439641976077
82015419805.6132100469348.386789953138
91032712544.641744657-2217.64174465700
10980710099.9474968022-292.947496802228
11108629905.221651052956.77834894800
121374312797.7991405042945.20085949582
131645816300.3290739922157.670926007802
141846618935.2716758402-469.271675840165
151881018453.3685169252356.631483074835
161736117659.9839229609-298.983922960897
171741117604.8066864470-193.806686447044
181851718407.5405552831109.459444716898
191852518755.5752988062-230.575298806196
201785918058.8717489497-199.871748949702
2194999900.52773700663-401.527737006635
2294909364.40995648836125.590043511638
2392559691.06805817654-436.06805817654
241075810822.3219761968-64.3219761967597
251237512763.6238888048-388.623888804814
261461714454.3196512665162.680348733508
271542714667.0457764288759.954223571198
281413614421.7684224102-285.768422410225
291430814428.8768084923-120.876808492253
301529315127.0576344725165.942365527527
311567915350.3798320845328.620167915513
321631915229.11789112021089.88210887983
33111968766.83279380312429.16720619689
341116911967.8784202523-798.878420252277
351215811659.323943106498.676056894004
361425113928.0956611457322.904338854314
371623716242.301634772-5.30163477198586
381970617934.43850191941771.56149808064
391896019623.0672889446-663.067288944637
401853717396.25774838071140.74225161928
411910318637.8526348609465.147365139086
421969119902.1619959569-211.161995956921
431946419510.7009049117-46.7009049117082
441726418502.3971498833-1238.39714988326
4589578766.99772453326190.002275466745
4697038736.76412645713966.235873542868
47916610185.3863476655-1019.38634766546
48951910722.7832221534-1203.78322215337
491053510474.271382906060.728617093958
501152611603.7859326031-77.785932603132
51963010566.3282984012-936.328298401214
5270617408.0020413218-347.002041321807
5360216525.60122097717-504.601220977169


Goldfeld-Quandt test for Heteroskedasticity
p-valuesAlternative Hypothesis
breakpoint indexgreater2-sidedless
210.2603724610199260.5207449220398520.739627538980074
220.1255857372305810.2511714744611620.874414262769419
230.2880004054716670.5760008109433350.711999594528333
240.2149728464707270.4299456929414540.785027153529273
250.1253317836227070.2506635672454140.874668216377293
260.0996867959815790.1993735919631580.900313204018421
270.06053383919358160.1210676783871630.939466160806418
280.05325615799756870.1065123159951370.946743842002431
290.0511602857623430.1023205715246860.948839714237657
300.05245655346079480.1049131069215900.947543446539205
310.174851834292850.34970366858570.82514816570715
320.2233897117004030.4467794234008050.776610288299597


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