Multiple Linear Regression - Estimated Regression Equation
werkl[t] = + 26.3106019568154 + 1.31669964010823`werkl-1`[t] -0.717070137986305`werkl-2`[t] -0.232618213537436afzetp[t] + 0.0457433670576205M1[t] + 0.193077155005919M2[t] + 0.213469490726063M3[t] -0.0394471352569172M4[t] -0.00298783299766641M5[t] -0.0692285262308115M6[t] -0.0376573725565223M7[t] + 0.0442625747595174M8[t] + 0.664799937984984M9[t] -0.203343875163899M10[t] + 0.078324253693556M11[t] + 0.0195867962194246t + e[t]


Multiple Linear Regression - Ordinary Least Squares
VariableParameterS.D.T-STAT
H0: parameter = 0
2-tail p-value1-tail p-value
(Intercept)26.31060195681545.2725244.99016e-063e-06
`werkl-1`1.316699640108230.090314.581400
`werkl-2`-0.7170701379863050.087976-8.150700
afzetp-0.2326182135374360.04956-4.69371.8e-059e-06
M10.04574336705762050.1041310.43930.6621750.331087
M20.1930771550059190.1099271.75640.0845850.042292
M30.2134694907260630.1088661.96090.0549680.027484
M4-0.03944713525691720.108836-0.36240.7184080.359204
M5-0.002987832997666410.101962-0.02930.9767290.488364
M6-0.06922852623081150.102329-0.67650.5015410.250771
M7-0.03765737255652230.104668-0.35980.7203890.360194
M80.04426257475951740.1097790.40320.6883660.344183
M90.6647999379849840.1134015.862400
M10-0.2033438751638990.127001-1.60110.1150790.057539
M110.0783242536935560.1035610.75630.4526910.226346
t0.01958679621942460.0052473.73290.0004510.000225


Multiple Linear Regression - Regression Statistics
Multiple R0.977494074989697
R-squared0.955494666639963
Adjusted R-squared0.943356848450863
F-TEST (value)78.7204629163045
F-TEST (DF numerator)15
F-TEST (DF denominator)55
p-value0
Multiple Linear Regression - Residual Statistics
Residual Standard Deviation0.166646632358458
Sum Squared Residuals1.52741050420283


Multiple Linear Regression - Actuals, Interpolation, and Residuals
Time or IndexActualsInterpolation
Forecast
Residuals
Prediction Error
18.48.47666408312547-0.0766640831254713
28.68.66684648864691-0.0668464886469122
38.98.877118263193150.0228817368068487
48.88.779075191096080.0209248089039169
58.38.39528299875307-0.0952829987530737
67.57.73872447413013-0.238724474130125
77.27.071795959576670.128204040423333
87.47.328687100114970.0713128998850345
98.88.44727222897740.352727771022605
109.39.275418859248450.0245811407515535
119.39.207863589844870.0921364101551311
128.78.86037652743881-0.160376527438816
138.28.158948728004670.0410512719953341
148.38.214070681678780.085929318321224
158.58.65120756120735-0.151207561207351
168.68.6560342883743-0.0560342883742955
178.58.60728903785156-0.107289037851557
188.28.38051998438213-0.180519984382127
198.18.015327770627030.0846722293729708
207.98.13050012748633-0.230500127486333
218.68.555729551354470.0442704486455342
228.78.74901448874428-0.0490144887442831
238.78.679990281241570.0200097187584284
248.58.5960694526763-0.096069452676297
258.48.281750581162980.118249418837021
268.58.460415228917140.0395847710828588
278.78.75029498137365-0.0502949813736478
288.78.662074423125620.0379255768743785
298.68.551444672653290.0485553273467098
308.58.326597168921260.173402831078740
318.38.201483061834060.0985169381659373
3288.06483324843903-0.0648332484390293
338.28.45336154344871-0.253361543448713
348.17.87390910375310.226090896246903
358.17.807032751806920.292967248193081
3687.86652595083890.133474049161095
377.97.823447971458870.0765520285411273
387.97.95366742676815-0.0536674267681462
3987.902520823030140.0974791769698596
4087.870646421338640.129353578661364
417.97.831723684664940.0682763153350615
4287.583614359579170.416385640420833
437.77.79162564457484-0.0916256445748447
447.27.37989183957172-0.179891839571723
457.57.5302635776509-0.0302635776509057
467.37.43525152174707-0.135251521747068
4777.1417363706377-0.141736370637692
4876.738355763313380.261644236686618
4977.04206878934006-0.0420687893400602
507.27.16246573080030.0375342691997045
517.37.46578479076151-0.165784790761510
527.17.19744907605777-0.0974490760577733
536.86.87192459000868-0.0719245900086847
546.46.5969366499135-0.196936649913503
556.16.29001214245233-0.190012142452331
566.56.376384334564820.123615665435180
577.77.73504757009515-0.0350475700951526
587.98.10991660203981-0.209916602039813
597.57.74424182549354-0.244241825493542
606.97.0386723057326-0.138672305732600
616.66.71711984690795-0.117119846907950
626.96.94253444318873-0.0425344431887289
637.77.45307358043420.246926419565801
6488.0347206000076-0.0347206000075903
6587.842335016068460.157664983931544
667.77.673607363073820.0263926369261809
677.37.32975542093507-0.0297554209350653
687.47.119703349823130.280296650176870
698.18.17832552847337-0.078325528473368
708.38.15648942446730.143510575532708
718.28.2191351809754-0.0191351809754066


Goldfeld-Quandt test for Heteroskedasticity
p-valuesAlternative Hypothesis
breakpoint indexgreater2-sidedless
190.07085587675891410.1417117535178280.929144123241086
200.2842032777956170.5684065555912340.715796722204383
210.3212532933165920.6425065866331840.678746706683408
220.2050079192057880.4100158384115760.794992080794212
230.1298793697469520.2597587394939050.870120630253048
240.08382530689689510.1676506137937900.916174693103105
250.04586432312073090.09172864624146170.95413567687927
260.0285659189647740.0571318379295480.971434081035226
270.01653748566631150.03307497133262310.983462514333688
280.0082955869253670.0165911738507340.991704413074633
290.0077860047434010.0155720094868020.992213995256599
300.03384258492610860.06768516985221730.966157415073891
310.02165442743122560.04330885486245110.978345572568774
320.01540494507609770.03080989015219540.984595054923902
330.1213777799949960.2427555599899920.878622220005004
340.1134502908264410.2269005816528830.886549709173559
350.1647281295586830.3294562591173670.835271870441317
360.1264747797025950.2529495594051910.873525220297405
370.1230870439589450.2461740879178910.876912956041055
380.1503868931039960.3007737862079930.849613106896004
390.1027287838654950.205457567730990.897271216134505
400.06974092702022810.1394818540404560.930259072979772
410.05534285650959630.1106857130191930.944657143490404
420.2125774910392540.4251549820785070.787422508960747
430.2408796248102730.4817592496205450.759120375189727
440.3764249730877040.7528499461754080.623575026912296
450.3305035363771320.6610070727542640.669496463622868
460.3349304018365260.6698608036730530.665069598163474
470.3515605708632020.7031211417264040.648439429136798
480.6850830546449230.6298338907101540.314916945355077
490.6919447171295250.6161105657409510.308055282870475
500.8380607477058740.3238785045882520.161939252294126
510.7993692595364320.4012614809271360.200630740463568
520.7558985638373220.4882028723253550.244101436162678


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