Multiple Linear Regression - Estimated Regression Equation
Omzet[t] = + 26.1376860921832 -1.44041616513782Uitvoer[t] + 0.314190804274826`Omzet-1`[t] + 0.361312695475143`Omzet-2`[t] + 14.8923044799708M1[t] + 5.18880377075971M2[t] -0.977242744491664M3[t] + 13.8940093239983M4[t] -21.3068427437488M5[t] -22.6258863164955M6[t] + 15.4496362100097M7[t] + 17.2466376332173M8[t] -0.68198202941588M9[t] -18.1300566873355M10[t] -3.72729217804567M11[t] + 0.496577843788959t + e[t]


Multiple Linear Regression - Ordinary Least Squares
VariableParameterS.D.T-STAT
H0: parameter = 0
2-tail p-value1-tail p-value
(Intercept)26.137686092183210.9778872.38090.021880.01094
Uitvoer-1.440416165137824.689712-0.30710.7602520.380126
`Omzet-1`0.3141908042748260.1429182.19840.0334830.016742
`Omzet-2`0.3613126954751430.141962.54520.0146840.007342
M114.89230447997087.3216972.0340.04830.02415
M25.188803770759717.739360.67040.5062450.253123
M3-0.9772427444916647.768238-0.12580.9004910.450245
M413.89400932399837.6701381.81140.0772280.038614
M5-21.30684274374887.796212-2.7330.0091450.004572
M6-22.62588631649558.935556-2.53210.0151650.007583
M715.44963621000977.4628692.07020.0446190.022309
M817.24663763321737.6963422.24090.0303780.015189
M9-0.681982029415887.547821-0.09040.9284350.464217
M10-18.13005668733557.774407-2.3320.0245690.012284
M11-3.727292178045678.020094-0.46470.6445150.322258
t0.4965778437889590.1842562.6950.0100770.005039


Multiple Linear Regression - Regression Statistics
Multiple R0.93939025754965
R-squared0.8824540559792
Adjusted R-squared0.840473361686056
F-TEST (value)21.0204731207443
F-TEST (DF numerator)15
F-TEST (DF denominator)42
p-value8.21565038222616e-15
Multiple Linear Regression - Residual Statistics
Residual Standard Deviation10.7348292040724
Sum Squared Residuals4839.93543770543


Multiple Linear Regression - Actuals, Interpolation, and Residuals
Time or IndexActualsInterpolation
Forecast
Residuals
Prediction Error
194111.526026961989-17.5260269619891
2102.898.82070451622443.97929548377559
310291.471968768036210.5280312319638
4105.1109.767997757077-4.66799775707655
592.477.18908103512815.2109189648720
681.473.4964614478537.90353855214703
7105.8102.5833755734523.21662442654812
8120.3108.56877081452811.7312291854723
9100.7104.508525427262-3.80852542726190
1088.888.0783390988720.72166090112797
1194.392.15708204976762.14291795023239
1299.993.80938041895966.09061958104043
13103.4111.504534906634-8.1045349066338
14103.3105.420630950834-2.12063095083440
1598.8102.424753798245-3.62475379824532
16104.2114.902177656602-10.7021776566022
1791.281.70904281122789.49095718877222
1874.778.753185182263-4.05318518226307
19108.5106.0036560757082.49634392429214
20114.5112.9552250518541.54477494814626
2196.9111.061113330856-14.1611133308561
2289.690.7477345343393-1.14773453433936
2397.196.99438057584940.105619424150556
24100.399.49668278763890.803317212361116
25122.6118.6008209011423.99917909885836
26115.4117.556553596569-2.15655359656862
27109117.682184243423-8.68218424342315
28129.1128.4377416009220.662258399077845
29102.897.73630129184715.0636987081529
3096.297.3534187546496-1.15341875464961
31127.7122.9089197605964.7910802394042
32128.9132.714845572113-3.81484557211349
33126.5127.041182625866-0.541182625866083
34119.8109.76920311604610.0307968839540
35113.2121.696316611343-8.49631661134311
36114.1121.425732265280-7.32573226528043
37134.1134.712722522752-0.612722522751562
38130132.114797168754-2.11479716875361
39121.8132.383400109267-10.5834001092673
40132.1143.693483375045-11.5934833750445
41105.3109.262610332221-3.96261033222091
42103103.741351812092-0.741351812091793
43117.1131.90763309382-14.80763309382
44126.3137.800283501499-11.5002835014988
45138.1128.3533060881839.74669391181748
46119.5118.4333375628661.06666243713393
47138131.7522207630406.24777923696017
48135.5135.0682045281210.431795471878913
49178.6156.35589470748422.2441052925161
50162.2159.7873137676192.41268623238103
51176.9164.53769308102812.3623069189720
52204.9178.59859961035526.3014003896454
53132.2158.002964529576-25.8029645295762
54142.5144.455582803143-1.95558280314255
55164.3159.9964154964244.30358450357553
56174.9172.8608750600062.03912493999372
57175.4166.6358725278338.76412747216665
58143153.671385687877-10.6713856878766


Goldfeld-Quandt test for Heteroskedasticity
p-valuesAlternative Hypothesis
breakpoint indexgreater2-sidedless
190.03893191292266280.07786382584532550.961068087077337
200.01267647748781790.02535295497563580.987323522512182
210.004657020709763270.009314041419526540.995342979290237
220.001135506477402090.002271012954804190.998864493522598
230.0003682445207174360.0007364890414348720.999631755479283
240.0001071481149616780.0002142962299233550.999892851885038
250.01166783492383690.02333566984767370.988332165076163
260.008474934147777610.01694986829555520.991525065852222
270.004557551967921090.009115103935842190.995442448032079
280.01001929200119020.02003858400238040.98998070799881
290.01008511570763890.02017023141527790.98991488429236
300.004949811671904230.009899623343808460.995050188328096
310.004954121560912790.009908243121825570.995045878439087
320.002485556322214380.004971112644428760.997514443677786
330.001715363978784570.003430727957569150.998284636021215
340.01158811010116080.02317622020232170.98841188989884
350.008962959507469450.01792591901493890.99103704049253
360.01753350687069130.03506701374138250.982466493129309
370.01170240506896040.02340481013792070.98829759493104
380.02110179114412810.04220358228825620.978898208855872
390.01151629888483050.02303259776966090.98848370111517


Meta Analysis of Goldfeld-Quandt test for Heteroskedasticity
Description# significant tests% significant testsOK/NOK
1% type I error level90.428571428571429NOK
5% type I error level200.952380952380952NOK
10% type I error level211NOK