Multiple Linear Regression - Estimated Regression Equation
Y(omzet)[t] = -37.7533688137505 + 1.48903215087652`X(prod)`[t] -0.714477893125787M1[t] + 0.398360687926065M2[t] -3.58771567669893M3[t] + 11.7993653902309M4[t] -4.26042698337578M5[t] -5.93922538841844M6[t] -4.85054153031326M7[t] -2.50383254961587M8[t] + 0.748592440063247M9[t] + 2.17500536687042M10[t] + 0.847482927713403M11[t] + e[t]


Multiple Linear Regression - Ordinary Least Squares
VariableParameterS.D.T-STAT
H0: parameter = 0
2-tail p-value1-tail p-value
(Intercept)-37.753368813750513.371138-2.82350.0069460.003473
`X(prod)`1.489032150876520.11958812.451400
M1-0.7144778931257873.06093-0.23340.816450.408225
M20.3983606879260653.0889470.1290.8979370.448969
M3-3.587715676698933.056891-1.17360.2464490.123225
M411.79936539023093.9967472.95220.0049110.002455
M5-4.260426983375783.288474-1.29560.2014530.100726
M6-5.939225388418443.050807-1.94680.0575520.028776
M7-4.850541530313263.048646-1.5910.1183030.059152
M8-2.503832549615873.032442-0.82570.4131560.206578
M90.7485924400632473.2586690.22970.8193040.409652
M102.175005366870423.2487770.66950.5064620.253231
M110.8474829277134033.1933350.26540.7918690.395934


Multiple Linear Regression - Regression Statistics
Multiple R0.932939088464168
R-squared0.870375342784353
Adjusted R-squared0.837279685622912
F-TEST (value)26.2987780704469
F-TEST (DF numerator)12
F-TEST (DF denominator)47
p-value0
Multiple Linear Regression - Residual Statistics
Residual Standard Deviation4.76704844747167
Sum Squared Residuals1068.06329232548


Multiple Linear Regression - Actuals, Interpolation, and Residuals
Time or IndexActualsInterpolation
Forecast
Residuals
Prediction Error
1108.01114.753561618318-6.74356161831793
2101.21107.676723369549-6.46672336954877
3119.93124.537097117195-4.60709711719513
494.76104.187406563088-9.4274065630884
595.26102.124516407721-6.86451640772103
6117.96126.205974212842-8.24597421284223
7115.86121.636335897617-5.77633589761661
8111.44114.453239112704-3.01323911270428
9108.16114.280890155367-6.12089015536737
10108.77105.2840780260393.48592197396112
11109.45105.8922973830213.55770261697864
12124.83118.1482973830216.68170261697865
13115.31114.6046584032300.705341596769839
14109.49108.7190458751620.770954124837636
15124.24128.259677494386-4.01967749438644
1692.8594.508697582391-1.65869758239103
1798.42100.486581041757-2.06658104175687
18120.88124.865845277053-3.98584527705336
19111.72115.08459443376-3.36459443375993
20116.1121.749496651999-5.64949665199923
21109.37115.323212660981-5.95321266098093
22111.65111.835819489896-0.185819489895579
23114.29113.0396517072291.25034829277134
24133.68134.229844612488-0.549844612487789
25114.27111.4776908863892.79230911361052
26126.49126.2896252555050.200374744494649
27131129.3021.69800000000001
28104101.2093422613352.79065773866463
29108.88107.6339353659641.24606463403582
30128.48127.2482967184561.23170328154421
31132.44130.8683352330511.57166476694894
32128.04127.8545284705930.185471529407012
33116.35114.8765030157181.47349698428201
34120.93122.259044546031-1.32904454603124
35118.59119.889199601261-1.29919960126066
36133.1139.143650710380-6.04365071038032
37121.05119.5184645011231.53153549887731
38127.62125.3962059649792.22379403502059
39135.44133.1734835922792.26651640772104
40114.88111.7814705325593.09852946744132
41114.34113.1433543242071.19664567579269
42128.85123.8235227714405.02647722856021
43138.9139.653624923223-0.753624923222548
44129.44128.4501413309440.989858669056423
45114.96111.8984387139653.06156128603505
46127.98129.257495655151-1.2774956551509
47127.03131.056940732835-4.02694073283458
48128.75125.7423613524923.00763864750839
49137.91136.1956245909401.71437540906025
50128.37125.0983995348043.27160046519589
51135.9131.2377417961394.66225820386052
52122.19116.9930830606275.19691693937349
53113.08106.5916128603516.48838713964939
54136.2130.2263610202095.97363897979116
55138129.6771095123508.32289048765015
56115.24107.752594433767.48740556624007
57110.95103.4109554539697.53904454603125
5899.2399.9235622828834-0.693562282883395
59102.39101.8719105756550.518089424345254
60112.67115.765845941619-3.09584594161890


Goldfeld-Quandt test for Heteroskedasticity
p-valuesAlternative Hypothesis
breakpoint indexgreater2-sidedless
160.789394717290860.4212105654182810.210605282709140
170.7318699417891050.536260116421790.268130058210895
180.7153134858618540.5693730282762910.284686514138146
190.7143489194196780.5713021611606440.285651080580322
200.7391582987424160.5216834025151690.260841701257584
210.8283187342195580.3433625315608850.171681265780442
220.7474525009143410.5050949981713190.252547499085659
230.6778721490630130.6442557018739750.322127850936987
240.6017536405377460.7964927189245090.398246359462254
250.6072485024585480.7855029950829050.392751497541452
260.849475428577680.3010491428446410.150524571422321
270.8820231178002270.2359537643995460.117976882199773
280.9387061966513910.1225876066972170.0612938033486086
290.9475234128236580.1049531743526840.0524765871763418
300.9658813917755260.0682372164489480.034118608224474
310.9677685392943640.06446292141127210.0322314607056361
320.9581462824862130.08370743502757340.0418537175137867
330.959249382177240.08150123564552060.0407506178227603
340.9352887924488670.1294224151022660.064711207551133
350.9023590437032270.1952819125935450.0976409562967727
360.9082382601805320.1835234796389370.0917617398194683
370.8705738537291850.2588522925416300.129426146270815
380.8179545408492810.3640909183014370.182045459150719
390.7582104971965830.4835790056068340.241789502803417
400.704785117391590.590429765216820.29521488260841
410.6540652368323930.6918695263352130.345934763167607
420.5840960993238230.8318078013523540.415903900676177
430.6720669663714590.6558660672570820.327933033628541
440.611278305110230.7774433897795380.388721694889769


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