Multiple Linear Regression - Estimated Regression Equation
Y[t] = + 649.098782608696 + 49.8834782608695X[t] -26.9059130434782M1[t] -39.7711304347826M2[t] -34.8363478260870M3[t] -30.1015652173913M4[t] -31.7667826086957M5[t] -38.0320000000000M6[t] -40.4972173913044M7[t] -49.1624347826087M8[t] -44.427652173913M9[t] + 9.3071304347826M10[t] + 19.8419130434782M11[t] -2.53478260869565t + e[t]


Multiple Linear Regression - Ordinary Least Squares
VariableParameterS.D.T-STAT
H0: parameter = 0
2-tail p-value1-tail p-value
(Intercept)649.09878260869611.6266955.828300
X49.88347826086959.9393995.01888e-064e-06
M1-26.905913043478213.880686-1.93840.0587290.029364
M2-39.771130434782613.862139-2.8690.0061980.003099
M3-34.836347826087013.847697-2.51570.0154350.007718
M4-30.101565217391313.837372-2.17540.0347770.017389
M5-31.766782608695713.831173-2.29680.0262360.013118
M6-38.032000000000013.829106-2.75010.0084880.004244
M7-40.497217391304413.831173-2.9280.005290.002645
M8-49.162434782608713.837372-3.55290.0008940.000447
M9-44.42765217391313.847697-3.20830.0024330.001217
M109.307130434782613.8621390.67140.5053190.25266
M1119.841913043478213.8806861.42950.1596280.079814
t-2.534782608695650.239105-10.601100


Multiple Linear Regression - Regression Statistics
Multiple R0.888041241395152
R-squared0.788617246418643
Adjusted R-squared0.72887864214565
F-TEST (value)13.2011327686003
F-TEST (DF numerator)13
F-TEST (DF denominator)46
p-value1.89785964721523e-11
Multiple Linear Regression - Residual Statistics
Residual Standard Deviation21.757220994567
Sum Squared Residuals21775.3266086956


Multiple Linear Regression - Actuals, Interpolation, and Residuals
Time or IndexActualsInterpolation
Forecast
Residuals
Prediction Error
1611619.658086956522-8.65808695652151
2594604.258086956522-10.2580869565216
3595606.658086956522-11.6580869565218
4591608.858086956522-17.8580869565217
5589604.658086956522-15.6580869565218
6584595.858086956522-11.8580869565218
7573590.858086956522-17.8580869565218
8567579.658086956522-12.6580869565217
9569581.858086956522-12.8580869565217
10621633.058086956522-12.0580869565218
11629641.058086956522-12.0580869565218
12628618.6813913043489.31860869565215
13612589.24069565217422.759304347826
14595573.84069565217421.159304347826
15597576.24069565217420.7593043478261
16593578.44069565217414.5593043478261
17590574.24069565217415.7593043478261
18580565.44069565217414.5593043478261
19574560.44069565217413.5593043478261
20573549.24069565217423.7593043478261
21573551.44069565217421.5593043478261
22620602.64069565217417.3593043478261
23626610.64069565217415.3593043478261
24620588.26431.736
25588558.82330434782629.1766956521739
26566543.42330434782622.5766956521739
27557545.82330434782611.1766956521739
28561548.02330434782612.9766956521739
29549543.8233043478265.17669565217393
30532535.023304347826-3.02330434782607
31526530.023304347826-4.02330434782608
32511518.823304347826-7.8233043478261
33499521.023304347826-22.0233043478261
34555572.223304347826-17.2233043478261
35565580.223304347826-15.2233043478261
36542557.846608695652-15.8466086956522
37527528.405913043478-1.40591304347832
38510513.005913043478-3.00591304347824
39514515.405913043478-1.40591304347824
40517517.605913043478-0.60591304347824
41508513.405913043478-5.40591304347825
42493504.605913043478-11.6059130434782
43490499.605913043478-9.60591304347823
44469488.405913043478-19.4059130434783
45478490.605913043478-12.6059130434782
46528541.805913043478-13.8059130434783
47534549.805913043478-15.8059130434783
48518577.312695652174-59.3126956521739
49506547.872-41.8720000000001
50502532.472-30.472
51516534.872-18.872
52528537.072-9.0720
53533532.8720.128000000000009
54536524.07211.928
55537519.07217.928
56524507.87216.128
57536510.07225.928
58587561.27225.728
59597569.27227.728
60581546.89530434782634.1046956521739


Goldfeld-Quandt test for Heteroskedasticity
p-valuesAlternative Hypothesis
breakpoint indexgreater2-sidedless
171.00872762296752e-052.01745524593504e-050.99998991272377
186.88981666961962e-050.0001377963333923920.999931101833304
194.39749428598553e-068.79498857197107e-060.999995602505714
202.03112426922738e-064.06224853845476e-060.99999796887573
212.34205806664728e-074.68411613329457e-070.999999765794193
222.50951335990665e-085.01902671981329e-080.999999974904866
235.04519717219935e-091.00903943443987e-080.999999994954803
241.47067919612813e-082.94135839225625e-080.999999985293208
251.5714384797056e-053.1428769594112e-050.999984285615203
260.0002040718968456980.0004081437936913960.999795928103154
270.001918543583177810.003837087166355610.998081456416822
280.002565728996874260.005131457993748510.997434271003126
290.005243368151662660.01048673630332530.994756631848337
300.01277978940952580.02555957881905170.987220210590474
310.01647253909389510.03294507818779030.983527460906105
320.03514178813908670.07028357627817340.964858211860913
330.07135702832504450.1427140566500890.928642971674956
340.08607310126579830.1721462025315970.913926898734202
350.1192587616327730.2385175232655450.880741238367228
360.2903034983042510.5806069966085010.709696501695749
370.4936996155854360.9873992311708720.506300384414564
380.6781300729003030.6437398541993940.321869927099697
390.8322074160720440.3355851678559120.167792583927956
400.9517592266761790.09648154664764260.0482407733238213
410.9929888722064930.01402225558701330.00701112779350663
420.9936698286871480.01266034262570480.00633017131285241
430.9966899181959680.006620163608064740.00331008180403237


Meta Analysis of Goldfeld-Quandt test for Heteroskedasticity
Description# significant tests% significant testsOK/NOK
1% type I error level130.481481481481481NOK
5% type I error level180.666666666666667NOK
10% type I error level200.740740740740741NOK