Multiple Linear Regression - Estimated Regression Equation
Y[t] = + 32.0112178808194 + 12.8517679356726X[t] + 0.912623590451367Y1[t] + 0.0121064299814901Y2[t] + 16.312803980732M1[t] + 16.7900026964816M2[t] + 10.8342316766507M3[t] + 6.12167292170496M4[t] + 9.48466383471706M5[t] + 3.23537468192878M6[t] + 15.9983473560093M7[t] + 65.6072237839268M8[t] + 27.1353181179752M9[t] + 4.52518290329523M10[t] -2.53197257686806M11[t] -0.281056311117769t + e[t]


Multiple Linear Regression - Ordinary Least Squares
VariableParameterS.D.T-STAT
H0: parameter = 0
2-tail p-value1-tail p-value
(Intercept)32.011217880819426.7468141.19680.2380870.119044
X12.85176793567263.5768423.5930.0008510.000425
Y10.9126235904513670.1503696.069200
Y20.01210642998149010.150130.08060.9361110.468056
M116.3128039807324.3252193.77160.0005020.000251
M216.79000269648165.3579773.13360.0031440.001572
M310.83423167665075.3166892.03780.0479030.023952
M46.121672921704964.8102171.27260.2101460.105073
M59.484663834717064.5663522.07710.0439480.021974
M63.235374681928784.8252930.67050.5062070.253104
M715.99834735600934.5606233.50790.001090.000545
M865.60722378392685.46422912.006700
M927.135318117975211.3338422.39420.0211990.010599
M104.525182903295235.7878250.78180.4386910.219346
M11-2.531972576868064.613779-0.54880.5860590.293029
t-0.2810563111177690.12654-2.22110.0317920.015896


Multiple Linear Regression - Regression Statistics
Multiple R0.99150564049245
R-squared0.983083435128344
Adjusted R-squared0.977041804817038
F-TEST (value)162.718237375218
F-TEST (DF numerator)15
F-TEST (DF denominator)42
p-value0
Multiple Linear Regression - Residual Statistics
Residual Standard Deviation6.3018287623476
Sum Squared Residuals1667.94792149796


Multiple Linear Regression - Actuals, Interpolation, and Residuals
Time or IndexActualsInterpolation
Forecast
Residuals
Prediction Error
1595597.538406997237-2.53840699723690
2591598.441363682634-7.44136368263409
3589588.5661484198620.433851580138386
4584581.6988604529692.30113954703075
5573580.193464242644-7.19346424264373
6567563.5637271338653.43627286613481
7569570.436731224323-1.43673122432336
8621621.517159942137-0.517159942136772
9629630.244837528502-1.24483752850162
10628615.28416908535212.7158309146477
11612607.1301851434724.8698148565282
12595594.7670175320190.232982467981304
13597595.0904612842561.90953871574416
14593596.906041560105-3.90604156010503
15590587.0429327273142.95706727268607
16580579.263021169970.73697883002963
17574573.1824005774060.817599422593482
18573561.05524927097711.9447507290226
19573572.55190346360.448096536400176
20620621.867617150418-1.86761715041804
21626626.007963924563-0.00796392456298972
22620609.16151615060310.8384838493965
23588596.420201396503-8.42020139650315
24566569.394524187921-3.39452418792072
25557564.961147108197-7.96114710819718
26561556.6773357391744.32266426082613
27549553.982044900197-4.98204490019733
28532538.085372468643-6.08537246864337
29526525.5074288730860.492571126913469
30511513.295532556787-2.29553255678695
31499512.01545648309-13.0154564830903
32555550.2101970647514.78980293524882
33565562.418878993182.58112100681942
34542549.33188345086-7.33188345085994
35527521.1243933790125.87560662098768
36510509.4075078984180.592492101582176
37514509.7430580806364.25694191936355
38517513.3838855373883.61611446261162
39508509.93335469772-1.93335469771984
40493496.762446607538-3.76244660753850
41490486.0460694828293.95393051717114
42469476.596256797846-7.59625679784636
43478469.8767584713868.12324152861406
44528527.1639558726370.836044127363355
45534534.151131287969-0.151131287969133
46518530.192770739627-12.1927707396267
47506508.325220081013-2.32522008101273
48502499.4309503816432.56904961835724
49516511.6669265296744.33307347032636
50528524.5913734806993.40862651930139
51533529.4755192549073.52448074509272
52536529.1902993008796.80970069912149
53537535.0706368240341.92936317596564
54524529.489234240524-5.48923424052415
55536530.11915035765.88084964239938
56587590.241069970057-3.24106997005736
57597598.177188265786-1.17718826578568
58581585.029660573558-4.02966057355759


Goldfeld-Quandt test for Heteroskedasticity
p-valuesAlternative Hypothesis
breakpoint indexgreater2-sidedless
190.03447397873196360.06894795746392720.965526021268036
200.009776077508697830.01955215501739570.990223922491302
210.002274139549273350.00454827909854670.997725860450727
220.06149572620719570.1229914524143910.938504273792804
230.3378324714780150.675664942956030.662167528521985
240.2776622375250460.5553244750500920.722337762474954
250.2425784168358610.4851568336717220.757421583164139
260.4966261590215840.9932523180431680.503373840978416
270.4676166801237550.935233360247510.532383319876245
280.418347127099580.836694254199160.58165287290042
290.3763024012683790.7526048025367570.623697598731621
300.3600648082397210.7201296164794410.639935191760279
310.8316747262670360.3366505474659290.168325273732964
320.9297821129682260.1404357740635480.0702178870317741
330.9221705724864520.1556588550270970.0778294275135484
340.9228231129683720.1543537740632550.0771768870316277
350.9661564674888860.06768706502222790.0338435325111139
360.9370030672785250.1259938654429510.0629969327214755
370.9223816866229090.1552366267541830.0776183133770914
380.9530769639979350.09384607200413030.0469230360020651
390.9947623078802920.01047538423941590.00523769211970797


Meta Analysis of Goldfeld-Quandt test for Heteroskedasticity
Description# significant tests% significant testsOK/NOK
1% type I error level10.0476190476190476NOK
5% type I error level30.142857142857143NOK
10% type I error level60.285714285714286NOK