Multiple Linear Regression - Estimated Regression Equation
y[t] = + 22.6729257443683 + 0.0174685988429137y1[t] + 0.131437577783892y2[t] + 0.300291730285133y3[t] -0.0319892632868462y4[t] + 0.00451269410751495uitvoer[t] + 0.00879190661155511ondernemersvertrouwen[t] -0.00216823737255318invoer[t] -3.25700323627328M1[t] + 0.633033557802868M2[t] -19.234836827881M3[t] -1.94318071962852M4[t] + 2.79138694440754M5[t] + 10.1653722367121M6[t] + 0.0331127764477652M7[t] -7.23163967356985M8[t] -6.33995057650054M9[t] -3.28869162373367M10[t] + 5.43507600211532M11[t] + e[t]


Multiple Linear Regression - Ordinary Least Squares
VariableParameterS.D.T-STAT
H0: parameter = 0
2-tail p-value1-tail p-value
(Intercept)22.672925744368310.8884022.08230.043030.021515
y10.01746859884291370.1163180.15020.8812940.440647
y20.1314375777838920.0939051.39970.1684620.084231
y30.3002917302851330.0928093.23560.0022790.001139
y4-0.03198926328684620.104465-0.30620.7608490.380425
uitvoer0.004512694107514950.0011683.8640.0003550.000178
ondernemersvertrouwen0.008791906611555110.0692710.12690.8995690.449784
invoer-0.002168237372553180.000911-2.37970.0216290.010814
M1-3.257003236273282.151944-1.51350.1371410.06857
M20.6330335578028682.4286590.26070.795550.397775
M3-19.2348368278812.184607-8.804700
M4-1.943180719628524.195265-0.46320.6454650.322732
M52.791386944407543.5846620.77870.440230.220115
M610.16537223671212.9185883.4830.0011160.000558
M70.03311277644776522.5947570.01280.9898750.494937
M8-7.231639673569852.897468-2.49580.0162980.008149
M9-6.339950576500543.823156-1.65830.1042120.052106
M10-3.288691623733673.52406-0.93320.3556920.177846
M115.435076002115322.7186871.99920.0516520.025826


Multiple Linear Regression - Regression Statistics
Multiple R0.971939318067388
R-squared0.9446660380053
Adjusted R-squared0.92253245320742
F-TEST (value)42.6802095833921
F-TEST (DF numerator)18
F-TEST (DF denominator)45
p-value0
Multiple Linear Regression - Residual Statistics
Residual Standard Deviation2.82736393509048
Sum Squared Residuals359.729406965265


Multiple Linear Regression - Actuals, Interpolation, and Residuals
Time or IndexActualsInterpolation
Forecast
Residuals
Prediction Error
198.198.2126858457704-0.11268584577039
2113.9107.7234040544366.17659594556361
380.982.4187825217305-1.51878252173045
495.793.41452381945122.28547618054877
5113.2111.9989124834491.20108751655118
6105.9108.136266679403-2.23626667940299
7108.8106.4674536765972.33254632340276
8102.398.00867453105024.29132546894982
99997.07375192555121.92624807444879
10100.7102.361043037936-1.66104303793599
11115.5115.695653758072-0.19565375807171
12100.7101.653218436107-0.953218436106535
13109.9106.9002131912532.99978680874656
14114.6114.3177856151230.282214384877284
1585.486.9312178978523-1.53121789785226
16100.5100.1621472648720.337852735128445
17114.8114.1599786113630.640021388636504
18116.5114.8482827071681.65171729283243
19112.9111.9365266011240.963473398875858
20102101.2737896666420.726210333358164
21106105.1009460663860.89905393361392
22105.3105.967992678265-0.667992678264846
23118.8118.0987265143350.70127348566528
24106.1108.496166729084-2.39616672908354
25109.3108.578898350950.721101649049747
26117.2118.496871933851-1.29687193385051
2792.591.2647066755041.23529332449606
28104.2104.719301259494-0.519301259494098
29112.5115.13701492345-2.63701492345026
30122.4121.1461879424341.2538120575657
31113.3111.1681968722992.13180312770121
3210099.23064396377650.769356036223451
33110.7106.9569916363163.74300836368439
34112.8109.0651624224473.7348375775528
35109.8113.845530816836-4.045530816836
36117.3115.6302947888061.66970521119373
37109.1110.775007217749-1.6750072177491
38115.9117.316091535858-1.41609153585804
399698.2915522879947-2.29155228799473
4099.899.9826234123155-0.182623412315491
41116.8116.783356358340.0166436416596489
42115.7117.640292328459-1.94029232845949
4399.4100.110975002563-0.71097500256337
4494.394.6518241568002-0.351824156800161
459191.6426872839394-0.642687283939394
4693.292.32927909275320.870720907246779
47103.1101.5911249951631.50887500483729
4894.194.757231725179-0.657231725179031
4991.891.53510558794380.264894412056175
50102.7102.2957394766980.404260523302348
5182.677.6822347617974.91776523820299
5289.187.17209803034191.92790196965811
53104.5103.7207376233970.779262376602925
54105.1103.8289703425361.27102965746434
5595.199.8168478474165-4.71684784741646
5688.794.1350676817313-5.43506768173127
5786.392.2256230878077-5.92562308780771
5891.894.0765227685987-2.27652276859874
59111.5109.4689639155952.03103608440514
6099.797.36308832082462.33691167917537
6197.599.698089806333-2.19808980633299
62111.7115.850107384035-4.15010738403469
6386.287.0115058551216-0.811505855121604
6495.499.2493062135257-3.84930621352573


Goldfeld-Quandt test for Heteroskedasticity
p-valuesAlternative Hypothesis
breakpoint indexgreater2-sidedless
220.0732113970644470.1464227941288940.926788602935553
230.02255659262294210.04511318524588410.977443407377058
240.04353118343722260.08706236687444510.956468816562777
250.01968323089892130.03936646179784260.980316769101079
260.03471497778190450.0694299555638090.965285022218096
270.01508689674379010.03017379348758010.98491310325621
280.008917006901036920.01783401380207380.991082993098963
290.005135391694376150.01027078338875230.994864608305624
300.002990416753053130.005980833506106260.997009583246947
310.003707645709759980.007415291419519970.99629235429024
320.00221653957335760.004433079146715190.997783460426642
330.009319906157267030.01863981231453410.990680093842733
340.06648382371873950.1329676474374790.93351617628126
350.05304186362807550.1060837272561510.946958136371924
360.1456315542231260.2912631084462520.854368445776874
370.1256107518240470.2512215036480930.874389248175953
380.2284724587893490.4569449175786990.77152754121065
390.1757103054746090.3514206109492190.82428969452539
400.1022379902010560.2044759804021130.897762009798944
410.05786567880681610.1157313576136320.942134321193184
420.0314110011280210.0628220022560420.968588998871979


Meta Analysis of Goldfeld-Quandt test for Heteroskedasticity
Description# significant tests% significant testsOK/NOK
1% type I error level30.142857142857143NOK
5% type I error level90.428571428571429NOK
10% type I error level120.571428571428571NOK