Multiple Linear Regression - Estimated Regression Equation
Y[t] = + 591.50371057514 -8.29035250463811X[t] -3.07157287157266M1[t] + 0.940806019377407M2[t] -1.71348175633892M3[t] -9.03443619872196M4[t] -12.6403318903319M5[t] -22.1279529993816M6[t] -18.2822407750979M7[t] + 33.8968047825191M8[t] + 44.4091836734694M9[t] + 35.4215625644197M10[t] + 14.3876211090497M11[t] -1.01237889095032t + e[t]


Multiple Linear Regression - Ordinary Least Squares
VariableParameterS.D.T-STAT
H0: parameter = 0
2-tail p-value1-tail p-value
(Intercept)591.5037105751415.02698639.362800
X-8.2903525046381112.233982-0.67760.5007840.250392
M1-3.0715728715726617.448855-0.1760.8609030.430452
M20.94080601937740717.4357150.0540.957160.47858
M3-1.7134817563389217.426521-0.09830.9220240.461012
M4-9.0344361987219617.42128-0.51860.6060930.303046
M5-12.640331890331917.514591-0.72170.473480.23674
M6-22.127952999381617.494108-1.26490.2111530.105576
M7-18.282240775097917.477546-1.0460.3000360.150018
M833.896804782519117.4649161.94090.0573160.028658
M944.409183673469417.4562262.5440.0137440.006872
M1035.421562564419717.4514822.02970.0471470.023574
M1114.387621109049718.1942910.79080.4324110.216205
t-1.012378890950320.262558-3.85583e-040.00015


Multiple Linear Regression - Regression Statistics
Multiple R0.763457076793766
R-squared0.582866708106483
Adjusted R-squared0.486032193916916
F-TEST (value)6.01920413382199
F-TEST (DF numerator)13
F-TEST (DF denominator)56
p-value7.92639047064725e-07
Multiple Linear Regression - Residual Statistics
Residual Standard Deviation28.7647049822638
Sum Squared Residuals46334.8621521335


Multiple Linear Regression - Actuals, Interpolation, and Residuals
Time or IndexActualsInterpolation
Forecast
Residuals
Prediction Error
1555587.419758812615-32.4197588126149
2562590.419758812616-28.419758812616
3561586.753092145949-25.7530921459494
4555578.419758812616-23.419758812616
5544573.801484230056-29.8014842300557
6537563.301484230056-26.3014842300557
7543566.134817563389-23.1348175633891
8594617.301484230056-23.3014842300557
9611626.801484230056-15.8014842300557
10613616.801484230056-3.80148423005572
11611594.75516388373516.2448361162646
12594579.35516388373514.6448361162646
13595575.27121212121219.7287878787876
14591578.27121212121212.7287878787879
15589574.60454545454514.3954545454545
16584566.27121212121217.7287878787878
17573561.65293753865211.3470624613481
18567551.15293753865215.8470624613481
19569553.98627087198515.0137291280148
20621605.15293753865215.8470624613481
21629614.65293753865214.3470624613481
22628604.65293753865223.3470624613482
23612582.60661719233129.3933828076685
24595567.20661719233127.7933828076685
25597563.12266542980933.8773345701915
26593566.12266542980826.8773345701917
27590562.45599876314227.5440012368584
28580554.12266542980825.8773345701917
29574549.50439084724824.495609152752
30573539.00439084724833.995609152752
31573541.83772418058131.1622758194187
32620593.00439084724826.995609152752
33626602.50439084724823.495609152752
34620592.50439084724827.495609152752
35588570.45807050092817.5419294990724
36566555.05807050092810.9419294990724
37557550.9741187384056.02588126159534
38561553.9741187384047.02588126159559
39549550.307452071738-1.30745207173775
40532541.974118738404-9.97411873840442
41526537.355844155844-11.3558441558441
42511526.855844155844-15.8558441558441
43499529.689177489177-30.6891774891774
44555580.855844155844-25.8558441558441
45565590.355844155844-25.3558441558441
46542580.355844155844-38.3558441558441
47527558.309523809524-31.3095238095238
48510542.909523809524-32.9095238095238
49514538.825572047001-24.8255720470008
50517541.825572047001-24.8255720470006
51508538.158905380334-30.1589053803339
52493529.825572047-36.8255720470005
53490516.916944959802-26.9169449598021
54469506.416944959802-37.4169449598021
55478509.250278293135-31.2502782931355
56528560.416944959802-32.4169449598021
57534569.916944959802-35.9169449598021
58518559.916944959802-41.9169449598021
59506537.870624613482-31.8706246134818
60502522.470624613482-20.4706246134818
61516518.386672850959-2.38667285095879
62528521.3866728509596.61332714904145
63533517.72000618429215.2799938157081
64536509.38667285095926.6133271490415
65537504.76839826839832.2316017316018
66524494.26839826839829.7316017316018
67536497.10173160173238.8982683982684
68587548.26839826839838.7316017316018
69597557.76839826839839.2316017316018
70581547.76839826839833.2316017316018


Goldfeld-Quandt test for Heteroskedasticity
p-valuesAlternative Hypothesis
breakpoint indexgreater2-sidedless
170.004119039843328950.00823807968665790.995880960156671
180.0004821345831911160.0009642691663822320.99951786541681
197.7669714250712e-050.0001553394285014240.99992233028575
209.80996717100343e-061.96199343420069e-050.99999019003283
219.41010820462715e-061.88202164092543e-050.999990589891795
228.18733064884226e-061.63746612976845e-050.999991812669351
236.58260966644286e-050.0001316521933288570.999934173903336
240.0001009787489184120.0002019574978368240.999899021251082
254.49679249799968e-058.99358499599937e-050.99995503207502
262.54917462437811e-055.09834924875622e-050.999974508253756
271.34306990079566e-052.68613980159132e-050.999986569300992
289.02518452776325e-061.80503690555265e-050.999990974815472
293.55065168030406e-067.10130336060813e-060.99999644934832
301.35337992499143e-062.70675984998287e-060.999998646620075
316.10635342241606e-071.22127068448321e-060.999999389364658
323.60935141565962e-077.21870283131924e-070.999999639064858
334.02388039935824e-078.04776079871649e-070.99999959761196
341.71833121303689e-063.43666242607379e-060.999998281668787
350.0001457916786703590.0002915833573407170.99985420832133
360.003607435799097550.007214871598195090.996392564200902
370.02614948162678390.05229896325356770.973850518373216
380.1004173958471930.2008347916943870.899582604152807
390.3407568246394010.6815136492788030.659243175360599
400.7511961543468440.4976076913063130.248803845653156
410.8308152223093920.3383695553812170.169184777690608
420.9257291313909370.1485417372181250.0742708686090625
430.9472263682772130.1055472634455740.0527736317227869
440.9610235034330840.0779529931338330.0389764965669165
450.9788758568470860.04224828630582880.0211241431529144
460.9918735721455540.01625285570889120.00812642785444561
470.9978454983874380.004309003225124090.00215450161256204
480.9990849706932950.001830058613410760.000915029306705382
490.999433691500730.001132616998539340.00056630849926967
500.9997161316408880.0005677367182242720.000283868359112136
510.999702237689060.0005955246218785730.000297762310939286
520.9981087735326470.003782452934705840.00189122646735292
530.9983858110625370.003228377874925030.00161418893746252


Meta Analysis of Goldfeld-Quandt test for Heteroskedasticity
Description# significant tests% significant testsOK/NOK
1% type I error level270.72972972972973NOK
5% type I error level290.783783783783784NOK
10% type I error level310.837837837837838NOK