Multiple Linear Regression - Estimated Regression Equation
werkl[t] = + 68.14802305098 -0.600110625503214afzetp[t] -0.102420103023981M1[t] -0.495816819253388M2[t] -0.74391950407523M3[t] -0.705361053505565M4[t] -0.283423175642895M5[t] -0.278179620822697M6[t] -0.362915784660241M7[t] -0.714346271540255M8[t] -0.892417612469521M9[t] -0.95384072431599M10[t] -0.215263836162456M11[t] + 0.0514304868800148t + e[t]


Multiple Linear Regression - Ordinary Least Squares
VariableParameterS.D.T-STAT
H0: parameter = 0
2-tail p-value1-tail p-value
(Intercept)68.148023050988.0456968.470100
afzetp-0.6001106255032140.081786-7.337600
M1-0.1024201030239810.20811-0.49210.6244450.312222
M2-0.4958168192533880.216436-2.29080.0255630.012782
M3-0.743919504075230.216175-3.44130.001070.000535
M4-0.7053610535055650.217236-3.2470.0019250.000963
M5-0.2834231756428950.21591-1.31270.194370.097185
M6-0.2781796208226970.215978-1.2880.2027740.101387
M7-0.3629157846602410.215532-1.68380.0975020.048751
M8-0.7143462715402550.215729-3.31130.0015880.000794
M9-0.8924176124695210.215374-4.14360.0001115.5e-05
M10-0.953840724315990.215406-4.42814.2e-052.1e-05
M11-0.2152638361624560.215547-0.99870.3220240.161012
t0.05143048688001480.0100195.13323e-062e-06


Multiple Linear Regression - Regression Statistics
Multiple R0.874136061372917
R-squared0.764113853792555
Adjusted R-squared0.712138940221424
F-TEST (value)14.7015896957059
F-TEST (DF numerator)13
F-TEST (DF denominator)59
p-value5.59552404411079e-14
Multiple Linear Regression - Residual Statistics
Residual Standard Deviation0.372864172098382
Sum Squared Residuals8.20263375924211


Multiple Linear Regression - Actuals, Interpolation, and Residuals
Time or IndexActualsInterpolation
Forecast
Residuals
Prediction Error
18.48.68608151001797-0.286081510017968
28.48.58415953086973-0.184159530869726
38.48.38748733292790.0125126670720988
48.68.53748733292790.0625126670720989
58.98.77081144746930.129188552530704
68.88.52743017641790.2725698235821
78.38.25408024925910.0459197507409085
87.57.89406918670877-0.394069186708767
97.27.7074172701092-0.507417270109196
107.47.63741358259243-0.237413582592426
118.88.427420957625970.372579042374027
129.38.634104218118120.665895781881884
139.38.523103539423830.776896460576166
148.78.36117049772540.338829502274594
158.28.2245093623339-0.0245093623338956
168.38.61455361253518-0.314553612535182
178.58.84787772707659-0.347877727076587
188.69.02457389387744-0.424573893877444
198.58.75122396671863-0.251223966718626
208.28.51123502926894-0.311235029268944
218.18.14454992501841-0.0445499250184129
227.97.954524112401-0.0545241124009965
238.68.68452042488422-0.0845204248842189
248.78.89120368537637-0.191203685376372
258.78.8402140692324-0.140214069232406
268.58.61826996498366-0.118269964983657
278.48.121542454290220.278457545709778
288.58.21153139173990.288468608260097
298.78.80492188158322-0.104921881583225
308.78.7415737981828-0.0415737981828007
318.68.64825705867494-0.048257058674946
328.58.22823493357430.271765066425699
338.37.801538766773440.498461233226558
3487.671524016706350.328475983293646
358.28.4615313917399-0.261531391739903
368.18.18812615182948-0.0881261518294768
378.17.897092285484220.202907714515778
3887.675148181235470.324851818764526
397.97.538487045843970.361512954156027
407.97.688487045843970.211512954156029
4187.74177797273440.258222027265595
4287.978485202085580.0215147979144207
437.97.885168462577730.0148315374222672
4487.405135274926770.594864725073230
457.77.158472295776880.541527704223125
467.27.028457545709780.171542454290223
477.57.69844279564268-0.198442795642681
487.37.96513711868515-0.665137118685151
4977.61409218978958-0.614092189789578
5077.0320817102389-0.0320817102389058
5176.89542057484740.104579425152604
527.26.865387387196430.334612612803567
537.37.33875575193912-0.0387557519391175
547.17.33541873108901-0.235418731089011
556.87.18209092903084-0.382090929030839
566.46.94210199158116-0.542101991581165
576.16.69543901243127-0.59543901243127
586.56.9254906376661-0.425490637666097
597.77.655486950149330.0445130498506734
607.97.742148085540840.157851914459165
617.57.51112528174591-0.0111252817459069
626.97.22917011494683-0.329170114946832
636.67.33255322975661-0.732553229756612
646.97.48255322975661-0.58255322975661
657.77.595855219197370.104144780802630
6687.592518198347260.407481801652736
6787.379179333738770.620820666261235
687.77.319223583940050.380776416059947
697.37.19258272989080.107417270109197
707.47.182590104924350.217409895075650
718.17.97259747995790.127402520042102
728.38.179280740450050.120719259549950
738.28.128291124306080.0717088756939148


Goldfeld-Quandt test for Heteroskedasticity
p-valuesAlternative Hypothesis
breakpoint indexgreater2-sidedless
170.4928159552312040.9856319104624080.507184044768796
180.5007428900093260.9985142199813480.499257109990674
190.4711637423573590.9423274847147190.528836257642641
200.5780210056092910.8439579887814180.421978994390709
210.6272813546945240.7454372906109510.372718645305476
220.5355045989312790.9289908021374420.464495401068721
230.4857946024862240.9715892049724480.514205397513776
240.5569829005328210.8860341989343580.443017099467179
250.4900684598861420.9801369197722840.509931540113858
260.4085339310858380.8170678621716770.591466068914162
270.3260562076432510.6521124152865030.673943792356749
280.2487589040059400.4975178080118810.75124109599406
290.1973312831402750.3946625662805500.802668716859725
300.1498515042449400.2997030084898810.85014849575506
310.1210069381397160.2420138762794330.878993061860283
320.1347395738661850.269479147732370.865260426133815
330.1357237851819630.2714475703639270.864276214818037
340.09849723049110740.1969944609822150.901502769508893
350.1382679719680370.2765359439360740.861732028031963
360.1875712976113050.375142595222610.812428702388695
370.1598322856910490.3196645713820980.840167714308951
380.1184045730395190.2368091460790380.881595426960481
390.09949427421440450.1989885484288090.900505725785596
400.070548966976490.141097933952980.92945103302351
410.04775433719405070.09550867438810140.95224566280595
420.03209624706148550.0641924941229710.967903752938514
430.02149785165979540.04299570331959080.978502148340205
440.02688974482904850.0537794896580970.973110255170952
450.07698538259141630.1539707651828330.923014617408584
460.1358757124467720.2717514248935430.864124287553228
470.1497913753953320.2995827507906630.850208624604668
480.2111216387944460.4222432775888930.788878361205554
490.2486503964476460.4973007928952910.751349603552354
500.3446819344109250.6893638688218490.655318065589075
510.5444151515367210.9111696969265570.455584848463279
520.7503639005457090.4992721989085830.249636099454291
530.7567302129080180.4865395741839630.243269787091981
540.6404407471282550.719118505743490.359559252871745
550.5609573524413680.8780852951172640.439042647558632
560.6234974370160220.7530051259679560.376502562983978


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