Multiple Linear Regression - Estimated Regression Equation
Y[t] = + 28.7874757977706 + 6.15526572196082X[t] + 1.04029525238940Y1[t] + 0.0529115814345462Y2[t] + 0.000173275377241103Y3[t] -0.0312486051569905Y4[t] -0.198417939743371Y5[t] + 0.0757211734654301Y6[t] + 14.3560144531145M1[t] + 62.1202569021121M2[t] + 16.8839583220259M3[t] -6.39068623716835M4[t] -13.4526057109252M5[t] -9.6089386884101M6[t] + 20.2085543548741M7[t] + 18.6461381200220M8[t] + 9.29765253960246M9[t] + 2.08312154381163M10[t] + 3.61754925754264M11[t] -0.203568749204859t + e[t]


Multiple Linear Regression - Ordinary Least Squares
VariableParameterS.D.T-STAT
H0: parameter = 0
2-tail p-value1-tail p-value
(Intercept)28.787475797770626.8453661.07230.2894120.144706
X6.155265721960824.210471.46190.1508760.075438
Y11.040295252389400.1488686.98800
Y20.05291158143454620.2135360.24780.8054510.402726
Y30.0001732753772411030.211498e-040.999350.499675
Y4-0.03124860515699050.213886-0.14610.884510.442255
Y5-0.1984179397433710.218461-0.90830.3686920.184346
Y60.07572117346543010.1570480.48220.6320870.316043
M114.35601445311454.4014823.26160.0021440.001072
M262.12025690211214.71256113.181800
M316.88395832202599.9363661.69920.0963410.04817
M4-6.3906862371683510.226718-0.62490.5352630.267632
M5-13.45260571092529.741921-1.38090.1742840.087142
M6-9.60893868841019.057101-1.06090.2945110.147256
M720.20855435487419.1646792.2050.0327230.016361
M818.64613812002205.3574113.48040.0011420.000571
M99.297652539602466.193551.50120.1404510.070225
M102.083121543811636.2259640.33460.7395270.369763
M113.617549257542645.3896230.67120.5055980.252799
t-0.2035687492048590.09105-2.23580.0304860.015243


Multiple Linear Regression - Regression Statistics
Multiple R0.990492291244139
R-squared0.981074979014064
Adjusted R-squared0.972902810861046
F-TEST (value)120.050757723549
F-TEST (DF numerator)19
F-TEST (DF denominator)44
p-value0
Multiple Linear Regression - Residual Statistics
Residual Standard Deviation6.88896340432147
Sum Squared Residuals2088.14393858754


Multiple Linear Regression - Actuals, Interpolation, and Residuals
Time or IndexActualsInterpolation
Forecast
Residuals
Prediction Error
1543543.442441814016-0.442441814015519
2594597.788557713896-3.78855771389591
3611607.1785259391523.82147406084762
4613606.0318727592826.9681272407183
5611602.1238100088678.87618999113269
6594600.477851905956-6.47785190595618
7595602.105066123513-7.10506612351298
8591600.905710617489-9.90571061748938
9589588.1953624580680.804637541931634
10584579.5647036720194.43529632798065
11573578.77798413377-5.77798413376995
12567561.8880304247845.11196957521583
13569570.147700984444-1.14770098444407
14621619.7197838826691.28021611733133
15629629.664435196745-0.664435196744697
16628619.2518157936048.74818420639645
17612611.6734128093720.326587190628115
18595596.141171277592-1.14117127759233
19597596.8070383417420.192961658258436
20593598.600780679453-5.60078067945272
21590586.2945878317053.70541216829463
22580579.1744947046550.825505295344876
23574572.0420422893511.95795771064883
24573559.89041572001913.1095842799810
25573573.722223850535-0.72222385053484
26620621.833801493568-1.83380149356791
27626627.23214525918-1.23214525918055
28620612.9470923015047.05290769849558
29588599.509536894495-11.5095368944948
30566567.999351639157-1.99935163915652
31557563.51943532362-6.51943532361981
32561553.7770726097847.22292739021642
33549550.550973042783-1.55097304278301
34532537.441933460907-5.44193346090666
35526522.6768818289813.32311817101918
36511511.707317339806-0.707317339805665
37499508.834740029575-9.8347400295755
38555546.3322835853658.66771641463513
39565561.1633548070013.83664519299912
40542551.421040045206-9.4210400452062
41527523.6645055700013.33549442999873
42510509.9802172243960.0197827756040731
43514508.7789184138775.22108158612308
44517513.2469426595733.75305734042712
45508512.814028157548-4.81402815754841
46493497.958607380975-4.95860738097528
47490491.47691182787-1.47691182787005
48469481.564997340684-12.5649973406842
49478473.6987771904994.30122280950121
50528531.992099180980-3.9920991809804
51534541.428084271581-7.42808427158064
52518526.954437953186-8.95443795318585
53506507.028734717265-1.02873471726476
54502492.4014079528999.59859204710095
55516507.7895417972498.21045820275127
56528523.4694934337014.53050656629855
57533531.1450485098951.85495149010515
58536530.8602607814445.13973921855641
59537535.0261799200281.97382007997199
60524528.949239174707-4.94923917470695
61536528.1541161309317.84588386906871
62587587.333474143522-0.333474143522253
63597595.3334545263411.66654547365915
64581585.393741147218-4.39374114721826


Goldfeld-Quandt test for Heteroskedasticity
p-valuesAlternative Hypothesis
breakpoint indexgreater2-sidedless
230.3007581910349210.6015163820698410.69924180896508
240.2589595506792120.5179191013584240.741040449320788
250.1775146127115090.3550292254230170.822485387288491
260.0972854026859920.1945708053719840.902714597314008
270.05114262496038330.1022852499207670.948857375039617
280.09285436580480470.1857087316096090.907145634195195
290.4291991871137330.8583983742274660.570800812886267
300.3303811987350070.6607623974700130.669618801264993
310.4748495297843020.9496990595686040.525150470215698
320.3967058887460810.7934117774921620.603294111253919
330.3063262495884840.6126524991769680.693673750411516
340.3827023896032740.7654047792065490.617297610396726
350.3733041603460150.7466083206920310.626695839653985
360.423381531890960.846763063781920.57661846810904
370.7767065755345440.4465868489309110.223293424465456
380.9855460295780990.02890794084380270.0144539704219013
390.9951520560303060.009695887939387820.00484794396969391
400.9853697319014140.02926053619717210.0146302680985861
410.9540505724474480.09189885510510470.0459494275525523


Meta Analysis of Goldfeld-Quandt test for Heteroskedasticity
Description# significant tests% significant testsOK/NOK
1% type I error level10.0526315789473684NOK
5% type I error level30.157894736842105NOK
10% type I error level40.210526315789474NOK