Multiple Linear Regression - Estimated Regression Equation
werkl[t] = + 19.4250848391952 + 1.38018027566590`werkl-1`[t] -0.694005422132068`werkl-2`[t] -0.200396397847844`werkl-3`[t] + 0.217499603220255`werkl-4`[t] + 0.0508481331699843`werkl-5`[t] -0.174579752192536afzetp[t] -0.226257796357584M1[t] -0.129506295557380M2[t] -0.148491155978233M3[t] -0.169728355178839M4[t] -0.119227957982638M5[t] + 0.489046736630819M6[t] -0.415557532986574M7[t] -0.10456110042014M8[t] + 0.0158936263692312M9[t] -0.0350934389340346M10[t] + 0.0506195813463781M11[t] + 0.0162133957639823t + e[t]


Multiple Linear Regression - Ordinary Least Squares
VariableParameterS.D.T-STAT
H0: parameter = 0
2-tail p-value1-tail p-value
(Intercept)19.42508483919526.0343773.21910.0022840.001142
`werkl-1`1.380180275665900.1461049.446500
`werkl-2`-0.6940054221320680.247281-2.80650.0071660.003583
`werkl-3`-0.2003963978478440.270402-0.74110.4621670.231084
`werkl-4`0.2174996032202550.2483850.87570.3854890.192745
`werkl-5`0.05084813316998430.1340540.37930.7060960.353048
afzetp-0.1745797521925360.055399-3.15130.0027710.001386
M1-0.2262577963575840.102885-2.19910.0326190.01631
M2-0.1295062955573800.116627-1.11040.2722340.136117
M3-0.1484911559782330.113998-1.30260.198810.099405
M4-0.1697283551788390.108223-1.56830.1232420.061621
M5-0.1192279579826380.106469-1.11980.268240.13412
M60.4890467366308190.1034894.72562e-051e-05
M7-0.4155575329865740.11831-3.51240.0009650.000482
M8-0.104561100420140.152152-0.68720.4951860.247593
M90.01589362636923120.1623640.09790.922420.46121
M10-0.03509343893403460.131428-0.2670.7905770.395289
M110.05061958134637810.1078910.46920.6410270.320513
t0.01621339576398230.0055222.93620.0050480.002524


Multiple Linear Regression - Regression Statistics
Multiple R0.980228972060803
R-squared0.96084883766738
Adjusted R-squared0.946466778034988
F-TEST (value)66.8088481223753
F-TEST (DF numerator)18
F-TEST (DF denominator)49
p-value0
Multiple Linear Regression - Residual Statistics
Residual Standard Deviation0.161355997571108
Sum Squared Residuals1.2757521396562


Multiple Linear Regression - Actuals, Interpolation, and Residuals
Time or IndexActualsInterpolation
Forecast
Residuals
Prediction Error
18.88.747762137510480.0522378624895221
28.38.40459619942178-0.104596199421779
37.57.74705816521561-0.247058165215610
47.27.06289402447790.137105975522094
57.47.347002775777620.0529972242223853
68.88.5022110512790.297788948720997
79.39.250508673905340.0494913260946615
89.39.132735406792920.167264593207078
98.78.72246526764408-0.0224652676440766
108.28.091512280142940.108487719857062
118.38.1869788757780.113021124222003
128.58.71342343324491-0.213423433244914
138.68.71462893300156-0.114628933001559
148.58.597680550532-0.097680550532003
158.28.36119510548206-0.161195105482055
168.17.970230954858120.129769045141880
177.98.10671364797438-0.206713647974380
188.68.550562022561920.0494379774380806
198.78.69934539638350.000654603616493099
208.78.681844336084610.0181556639153870
218.58.59516565440873-0.0951656544087262
228.48.31910650947540.080893490524606
238.58.479159635920630.0208403640793728
248.78.7322520634431-0.0322520634431003
258.78.67046694447170.0295330555283018
268.68.575213554649410.0247864453505907
278.58.37609397942290.123906020577099
288.38.263747548497680.0362524515023253
2988.11911914451816-0.119119144518163
308.28.466643916085-0.266643916085004
318.17.918613452961650.181386547038345
328.17.910706453815360.189293546184643
3388.03619228185078-0.0361922818507823
347.97.929143680442-0.0291436804420043
357.97.96833025266424-0.0683302526642403
3687.896073609228060.103926390771938
3787.874710841321570.125289158678432
387.97.873982446814270.0260175531857289
3987.655694575831270.344305424168731
407.77.84492335205796-0.144923352057959
417.27.41839102276844-0.218391022768442
427.57.484285051407230.0157149485927650
437.37.43373503767901-0.133735037679008
4477.2294504394152-0.229450439415200
4576.836910501902710.163089498097291
4677.10770152817295-0.107701528172952
477.27.20658543244014-0.00658543244013645
487.37.37279579439085-0.0727957943908475
497.17.12925592176717-0.0292559217671732
506.86.8217889909769-0.0217889909768962
516.46.5846827841252-0.184682784125192
526.16.27287141314891-0.172871413148915
536.56.294669005166470.205330994833533
547.77.66671190876970.033288091230301
557.98.06242590932003-0.162425909320034
567.57.61474366719418-0.11474366719418
576.96.90926629419371-0.009266294193706
586.66.65253600176671-0.0525360017667118
596.96.958945803197-0.0589458031969987
607.77.485455099693080.214544900306925
6188.06317522192752-0.0631752219275241
6287.826738257605640.173261742394358
637.77.575275389922970.124724610077028
647.37.285332706959430.0146672930405738
657.47.114104403794930.285895596205067
668.18.22958604989714-0.12958604989714
678.38.235371529750460.0646284702495425
688.28.23051969669773-0.0305196966977268


Goldfeld-Quandt test for Heteroskedasticity
p-valuesAlternative Hypothesis
breakpoint indexgreater2-sidedless
220.0710801763567820.1421603527135640.928919823643218
230.03319186581142940.06638373162285880.96680813418857
240.01633639797573820.03267279595147640.983663602024262
250.006053379292703020.01210675858540600.993946620707297
260.005140484731535220.01028096946307040.994859515268465
270.1391111799607550.2782223599215090.860888820039245
280.09148210740736540.1829642148147310.908517892592635
290.0871075702296650.174215140459330.912892429770335
300.1582125152087830.3164250304175660.841787484791217
310.1221166237913420.2442332475826840.877883376208658
320.1690477554323580.3380955108647160.830952244567642
330.2357313157571210.4714626315142430.764268684242879
340.208334747232820.416669494465640.79166525276718
350.2563930325328730.5127860650657460.743606967467127
360.1919627114134020.3839254228268050.808037288586598
370.1504301874943020.3008603749886040.849569812505698
380.1254608073341950.2509216146683900.874539192665805
390.3823234278627690.7646468557255370.617676572137231
400.4683947096347200.9367894192694410.53160529036528
410.7642258212827550.471548357434490.235774178717245
420.6652775356840010.6694449286319980.334722464315999
430.6743661101654120.6512677796691760.325633889834588
440.6646938816694310.6706122366611380.335306118330569
450.5606921532429820.8786156935140350.439307846757018
460.4366040161299020.8732080322598030.563395983870098


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