Multiple Linear Regression - Estimated Regression Equation
WLH[t] = + 28.0537721653424 + 4.5783344490655X[t] + 0.89389373351237`Y(t-1)`[t] + 0.269258267201097`Y(t-2)`[t] -0.239285433868153`Y(t-3)`[t] -0.102477680079240`Y(t-4)`[t] -4.41387550198146M1[t] -7.48459972952515M2[t] -5.74169225100387M3[t] -9.06607666309207M4[t] -2.46464716599568M5[t] + 28.2278520152218M6[t] + 4.32563125183533M7[t] -12.8925239435589M8[t] -15.4919697862306M9[t] -9.03535197334436M10[t] -1.16080135981364M11[t] -0.182589577259004t + e[t]


Multiple Linear Regression - Ordinary Least Squares
VariableParameterS.D.T-STAT
H0: parameter = 0
2-tail p-value1-tail p-value
(Intercept)28.05377216534248.9024643.15120.0031660.001583
X4.57833444906551.2778073.5830.0009520.000476
`Y(t-1)`0.893893733512370.1497155.97061e-060
`Y(t-2)`0.2692582672010970.2025921.32910.1917510.095876
`Y(t-3)`-0.2392854338681530.206193-1.16050.2530870.126543
`Y(t-4)`-0.1024776800792400.15661-0.65440.5168270.258413
M1-4.413875501981461.710078-2.58110.0138330.006917
M2-7.484599729525152.199846-3.40230.0015860.000793
M3-5.741692251003872.412995-2.37950.0224610.011231
M4-9.066076663092072.203365-4.11470.0002011e-04
M5-2.464647165995682.424432-1.01660.3157790.157889
M628.22785201522182.26301812.473500
M74.325631251835334.8752510.88730.3805190.190259
M8-12.89252394355895.422589-2.37760.0225640.011282
M9-15.49196978623066.683822-2.31780.025940.01297
M10-9.035351973344363.373712-2.67820.0108750.005437
M11-1.160801359813642.258899-0.51390.6103120.305156
t-0.1825895772590040.053886-3.38840.0016490.000825


Multiple Linear Regression - Regression Statistics
Multiple R0.99431080101004
R-squared0.988653969005226
Adjusted R-squared0.98357811303388
F-TEST (value)194.775812116472
F-TEST (DF numerator)17
F-TEST (DF denominator)38
p-value0
Multiple Linear Regression - Residual Statistics
Residual Standard Deviation2.23576648500679
Sum Squared Residuals189.948767468226


Multiple Linear Regression - Actuals, Interpolation, and Residuals
Time or IndexActualsInterpolation
Forecast
Residuals
Prediction Error
1127127.483508875378-0.483508875378087
2122122.184141070298-0.184141070297849
3117120.073553392053-3.07355339205266
4112111.9810641011390.0189358988611628
5113114.088004226987-1.08800422698736
6149145.8543317981903.14566820181027
7157155.9277697009281.07223029907242
8157155.6445753821411.35542461785918
9147146.2998528004860.70014719951383
10137138.031463747192-1.03146374719181
11132133.272083335695-1.27208333569496
12125129.481098117358-4.4810981173583
13123120.6987167070002.30128329300029
14117115.9940115348981.00598846510224
15114113.8398369381570.160163061843093
16111107.2315467733573.768453226643
17112111.8015986544210.198401345578616
18144143.7303495723690.269650427631110
19150149.5446863131620.455313686837538
20149146.1917160983882.80828390161191
21134136.371724984291-2.37172498429149
22123124.253090584287-1.25309058428748
23116117.697765897299-1.69776589729938
24117113.1486397941573.85136020584309
25111111.730565551759-0.730565551759419
26105106.185400131032-1.18540013103232
27102101.2448643547000.755135645299677
289594.77389448473910.226105515260888
299396.178282152071-3.17828215207097
30124124.348318800677-0.348318800676983
31130129.4181287418280.581871258172482
32124126.923667281773-2.92366728177347
33115113.1809259742211.81907402577911
34106105.1818403193650.818159680635145
35105103.2262798719491.77372012805115
36105103.655708501471.34429149852994
37101101.865853180555-0.865853180555036
389596.1985489962842-1.19854899628418
399391.4209491077471.57905089225291
408485.4677797836412-1.46777978364118
418785.1486828909911.85131710900907
42116117.010386238888-1.01038623888843
43120122.014793236677-2.01479323667678
44117120.780890415079-3.780890415079
45109109.147496241001-0.147496241001446
46105103.5336053491561.46639465084415
47107105.8038708950571.19612910494319
48109109.714553587015-0.714553587014742
49109109.221355685308-0.221355685307748
50108106.4378982674881.5621017325121
51107106.4207962073430.579203792656976
5299101.545714857124-2.54571485712387
53103100.7834320755292.21656792447064
54131133.056613589876-2.05661358987597
55137137.094622007406-0.0946220074056544
56135132.4591508226192.54084917738138


Goldfeld-Quandt test for Heteroskedasticity
p-valuesAlternative Hypothesis
breakpoint indexgreater2-sidedless
210.8589785670740720.2820428658518560.141021432925928
220.7489106007343880.5021787985312240.251089399265612
230.7950264933598630.4099470132802730.204973506640137
240.9054659668124110.1890680663751780.094534033187589
250.903244334439060.1935113311218790.0967556655609394
260.8723999809060380.2552000381879240.127600019093962
270.8340753102733110.3318493794533780.165924689726689
280.8557840049721930.2884319900556130.144215995027807
290.9103074412432770.1793851175134470.0896925587567233
300.9465570477450360.1068859045099280.0534429522549638
310.9545349624402940.09093007511941150.0454650375597057
320.941613119485810.1167737610283790.0583868805141893
330.9480207366816560.1039585266366880.0519792633183439
340.8964840291895950.207031941620810.103515970810405
350.8547373496773250.2905253006453500.145262650322675


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