Multiple Linear Regression - Estimated Regression Equation
wkl[t] = + 38.5210955524794 -0.00152089568579747bvg[t] + 1.09898403346457Y1[t] -0.082394676964828Y2[t] + 0.409148238270283Y3[t] -0.483746709978272Y4[t] -7.65892149435435M1[t] -15.0130071036027M2[t] -11.2938298789452M3[t] -12.1334166166230M4[t] -4.62991986405527M5[t] + 13.4100542052650M6[t] -6.78455588173178M7[t] -18.0900002095661M8[t] -23.8068515987059M9[t] -12.9528577185224M10[t] + 2.41394734964293M11[t] -0.0688079449944023t + e[t]


Multiple Linear Regression - Ordinary Least Squares
VariableParameterS.D.T-STAT
H0: parameter = 0
2-tail p-value1-tail p-value
(Intercept)38.521095552479422.3081041.72680.0921220.046061
bvg-0.001520895685797470.002951-0.51540.609190.304595
Y11.098984033464570.1437917.64300
Y2-0.0823946769648280.22076-0.37320.7109980.355499
Y30.4091482382702830.2264941.80640.078570.039285
Y4-0.4837467099782720.157295-3.07540.003830.001915
M1-7.658921494354353.784777-2.02360.0499010.02495
M2-15.01300710360274.295187-3.49530.0011960.000598
M3-11.29382987894524.014019-2.81360.0076360.003818
M4-12.13341661662303.601294-3.36920.0017090.000854
M5-4.629919864055273.654506-1.26690.2127020.106351
M613.41005420526503.3922353.95320.0003150.000157
M7-6.784555881731783.848867-1.76270.085780.04289
M8-18.09000020956615.252776-3.44390.0013840.000692
M9-23.80685159870595.934347-4.01170.0002640.000132
M10-12.95285771852244.268398-3.03460.0042740.002137
M112.413947349642933.7460940.64440.5230950.261547
t-0.06880794499440230.075876-0.90680.3700560.185028


Multiple Linear Regression - Regression Statistics
Multiple R0.988899182665083
R-squared0.97792159347567
Adjusted R-squared0.968297672683013
F-TEST (value)101.613636951569
F-TEST (DF numerator)17
F-TEST (DF denominator)39
p-value0
Multiple Linear Regression - Residual Statistics
Residual Standard Deviation4.71069167719526
Sum Squared Residuals865.434027026272


Multiple Linear Regression - Actuals, Interpolation, and Residuals
Time or IndexActualsInterpolation
Forecast
Residuals
Prediction Error
1463459.3718738367213.62812616327886
2462459.8952901120432.10470988795653
3456459.187772888032-3.18777288803227
4455452.2698188554322.7301811445679
5456457.400820147714-1.40082014771398
6472474.440778964047-2.44077896404659
7472474.033641304716-2.03364130471551
8471462.2263646702698.7736353297309
9465462.2332345537762.76676544622374
10459458.5236202957630.476379704237281
11465467.27491064952-2.27491064952004
12468469.725256519834-1.72525651983418
13467465.5640482519841.43595174801603
14463461.6611070163611.33889298363914
15460458.4027574041641.59724259583569
16462453.8331279517598.16687204824076
17461462.175336005547-1.1753360055466
18476480.492162009258-4.49216200925834
19476478.286737171548-2.28673717154764
20471464.7288156694156.27118433058544
21453460.146772131966-7.14677213196571
22443444.572174944957-1.57217494495710
23442448.262942482809-6.26294248280918
24444440.404083825433.59591617456951
25438440.092821851425-2.09282185142451
26427430.058187902105-3.05818790210455
27424423.244282849470.755717150529872
28416416.644566318303-0.644566318302859
29406413.644404556278-7.64440455627754
30431425.6432927059555.35670729404479
31434431.9963989070922.00360109290750
32418420.906172282792-2.90617228279153
33412412.78617091795-0.786170917950232
34404407.940565399571-3.94056539957111
35409407.1518090835091.8481909164906
36412415.279301153185-3.27930115318458
37406410.693974701347-4.69397470134713
38398402.32745703837-4.32745703837046
39397395.8320063407611.16799365923901
40385390.674992804677-5.67499280467734
41390385.0259533282844.9740466717162
42413412.0594816873040.940518312696215
43413413.271941748622-0.271941748622342
44401407.070052338508-6.07005233850753
45397395.4791307243741.52086927562637
46397391.9636393597095.03636064029093
47409402.3103377841616.68966221583862
48419417.5913585015511.40864149844925
49424422.2772813585231.72271864147675
50428424.0579579311213.94204206887936
51430430.333180517572-0.333180517572299
52424428.577494069828-4.57749406982845
53433427.7534859621785.24651403782191
54456455.3642846334360.635715366563918
55459456.4112808680222.588719131978
56446452.068595039017-6.06859503901729
57441437.3546916719343.64530832806583


Goldfeld-Quandt test for Heteroskedasticity
p-valuesAlternative Hypothesis
breakpoint indexgreater2-sidedless
210.507276847126970.985446305746060.49272315287303
220.4130923489823150.826184697964630.586907651017685
230.3597732179046780.7195464358093550.640226782095322
240.4014801067370470.8029602134740950.598519893262953
250.3258122359020370.6516244718040750.674187764097963
260.2158547669062570.4317095338125130.784145233093743
270.2537656638768860.5075313277537730.746234336123114
280.3138462535973980.6276925071947970.686153746402602
290.4846393491962030.9692786983924070.515360650803797
300.895556641169320.2088867176613590.104443358830679
310.9898371695429280.02032566091414370.0101628304570718
320.9809800725925550.03803985481488910.0190199274074445
330.9544438949201250.09111221015974890.0455561050798744
340.922383082598750.1552338348024990.0776169174012495
350.9562595214172660.08748095716546850.0437404785827342
360.9502742806386670.0994514387226670.0497257193613335


Meta Analysis of Goldfeld-Quandt test for Heteroskedasticity
Description# significant tests% significant testsOK/NOK
1% type I error level00OK
5% type I error level20.125NOK
10% type I error level50.3125NOK