Multiple Linear Regression - Estimated Regression Equation
Y[t] = -5.32826335158439 + 2.34295047914645X[t] + 1.09404972823779Y1[t] -0.103435969619101Y2[t] + 0.290853961965319Y3[t] -0.283179283774372Y4[t] + 13.4961062988867M1[t] + 9.49932734168887M2[t] + 5.38342892233694M3[t] -0.316430489186691M4[t] + 2.27378015665203M5[t] + 0.634821026614046M6[t] + 7.50051641234214M7[t] + 26.0146635332518M8[t] + 5.80947840878837M9[t] -2.57233748576951M10[t] -7.79427250169785M11[t] + 0.000594829630836294t + e[t]


Multiple Linear Regression - Ordinary Least Squares
VariableParameterS.D.T-STAT
H0: parameter = 0
2-tail p-value1-tail p-value
(Intercept)-5.3282633515843924.839465-0.21450.8312690.415634
X2.342950479146453.0938380.75730.4534240.226712
Y11.094049728237790.1522737.184800
Y2-0.1034359696191010.213236-0.48510.6303350.315167
Y30.2908539619653190.210231.38350.1743790.087189
Y4-0.2831792837743720.143258-1.97670.0551760.027588
M113.49610629888673.4762563.88240.0003890.000194
M29.499327341688874.0243682.36050.0233480.011674
M35.383428922336944.3499211.23760.2232670.111633
M4-0.3164304891866913.768009-0.0840.9335030.466752
M52.273780156652033.423450.66420.5104840.255242
M60.6348210266140463.4287970.18510.8540760.427038
M77.500516412342143.4750342.15840.0371120.018556
M826.01466353325183.5943727.237600
M95.809478408788375.6404311.030.3093690.154685
M10-2.572337485769515.415976-0.4750.6374690.318735
M11-7.794272501697854.401038-1.7710.0843750.042187
t0.0005948296308362940.0831630.00720.994330.497165


Multiple Linear Regression - Regression Statistics
Multiple R0.988776823652894
R-squared0.977679606993106
Adjusted R-squared0.967950204913177
F-TEST (value)100.487121301117
F-TEST (DF numerator)17
F-TEST (DF denominator)39
p-value0
Multiple Linear Regression - Residual Statistics
Residual Standard Deviation4.80066799932126
Sum Squared Residuals898.81011634858


Multiple Linear Regression - Actuals, Interpolation, and Residuals
Time or IndexActualsInterpolation
Forecast
Residuals
Prediction Error
1461462.492138554731-1.49213855473124
2461467.843306352255-6.84330635225514
3463458.2396163733194.76038362668138
4462458.4558300061143.54416999388604
5456458.046638111461-2.04663811146130
6455450.5291193351774.47088066482284
7456456.064763110499-0.0647631104988569
8472474.315046270879-2.31504627087866
9472472.920037398912-0.920037398912489
10471463.4578740658207.54212593418048
11465461.5129682589553.48703174104504
12459458.3161046500860.683895349913938
13465465.578269264926-0.578269264926175
14468467.3050548364830.694945163517022
15467465.8052365446151.19476345538506
16463462.1458138000650.854186199934795
17460459.6373425154520.362657484547555
18462453.990181095528.0098189044801
19461462.474642112125-1.47464211212481
20476479.948617644391-3.94861764439084
21476477.689455017998-1.6894550179979
22471466.899481879274.10051812072972
23453460.853881765038-7.853881765038
24443445.225344579566-2.22534457956645
25442448.189126069023-6.18912606902336
26444440.3137770129063.68622298709427
27438440.678696337565-2.67869633756482
28427430.749200322785-3.74920032278551
29424422.7909618130591.20903818694096
30416416.696761654408-0.69676165440799
31406413.62064407375-7.62064407374966
32431424.2647867344876.73521326551277
33434430.9685054973913.03149450260911
34418422.640429027241-4.64042902724146
35412409.7071271671592.29287283284123
36404406.385751434503-2.38575143450301
37409406.2474693120652.75253068793536
38412413.677716830384-1.67771683038393
39406411.699626584204-5.69962658420436
40398402.845459804049-4.84545980404912
41397396.7611487383550.238851261644903
42385392.261560843548-7.26156084354795
43390385.4749342965964.52506570340376
44413412.6757368319850.324263168015478
45413413.910042178716-0.910042178716053
46401408.002215027669-7.00221502766874
47397394.9260228088482.07397719115172
48397393.0727993358443.92720066415553
49409403.4929967992555.50700320074541
50419414.8601449679724.13985503202778
51424421.5768241602972.42317583970274
52428423.8036960669864.1963039330138
53430429.7639088216720.236091178327881
54424428.522377071347-4.522377071347
55433428.3650164070304.63498359296957
56456456.795812518259-0.79581251825874
57459458.5119599069830.488040093017333


Goldfeld-Quandt test for Heteroskedasticity
p-valuesAlternative Hypothesis
breakpoint indexgreater2-sidedless
210.01427827562753000.02855655125505990.98572172437247
220.09017917805156960.1803583561031390.90982082194843
230.5806988739255690.8386022521488630.419301126074431
240.5182395155049730.9635209689900540.481760484495027
250.4090503425548410.8181006851096820.590949657445159
260.3917287035208480.7834574070416960.608271296479152
270.2922580579393260.5845161158786530.707741942060674
280.2007535158464380.4015070316928760.799246484153562
290.3450576404793930.6901152809587870.654942359520607
300.4448922706854780.8897845413709560.555107729314522
310.5630218531119730.8739562937760550.436978146888027
320.935685597387460.1286288052250790.0643144026125396
330.9358075391013160.1283849217973680.0641924608986838
340.9380800416387370.1238399167225260.061919958361263
350.9407117502087940.1185764995824110.0592882497912057
360.8696628592850670.2606742814298650.130337140714932


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