Multiple Linear Regression - Estimated Regression Equation
Omzet[t] = + 24.2719954836995 -3.31703241456063Uitvoer[t] + 0.347127616231981`Omzet-1`[t] + 0.355694576847724`Omzet-2`[t] + 0.307636566464671`Omzet-3`[t] -0.236660071043794`Omzet-4`[t] -4.91920455650283M1[t] + 6.34477868482915M2[t] -25.1185619148915M3[t] -26.1790950346311M4[t] + 8.80183878654852M5[t] + 22.3700847428009M6[t] -1.49099973052366M7[t] -27.9110842666772M8[t] -9.46201939302143M9[t] -1.42678907684248M10[t] + 20.2095761552773M11[t] + 0.356533729590830t + e[t]


Multiple Linear Regression - Ordinary Least Squares
VariableParameterS.D.T-STAT
H0: parameter = 0
2-tail p-value1-tail p-value
(Intercept)24.271995483699512.6833341.91370.0632140.031607
Uitvoer-3.317032414560634.600685-0.7210.475330.237665
`Omzet-1`0.3471276162319810.1600292.16910.0363950.018197
`Omzet-2`0.3556945768477240.1557912.28310.0281030.014052
`Omzet-3`0.3076365664646710.1520782.02290.0501620.025081
`Omzet-4`-0.2366600710437940.148675-1.59180.1197160.059858
M1-4.919204556502837.632115-0.64450.5230970.261549
M26.344778684829157.9170770.80140.4278810.21394
M3-25.11856191489157.618837-3.29690.0021260.001063
M4-26.179095034631110.452156-2.50470.0166650.008332
M58.8018387865485210.6749720.82450.4147840.207392
M622.37008474280098.9736432.49290.0171460.008573
M7-1.490999730523667.400757-0.20150.8414090.420704
M8-27.91108426667728.188848-3.40840.0015590.00078
M9-9.462019393021439.497802-0.99620.3254390.162719
M10-1.426789076842488.915995-0.160.8737080.436854
M1120.20957615527738.2317922.45510.0187750.009388
t0.3565337295908300.189951.8770.0682130.034107


Multiple Linear Regression - Regression Statistics
Multiple R0.951390734495854
R-squared0.90514432968456
Adjusted R-squared0.862708898227653
F-TEST (value)21.3299193294106
F-TEST (DF numerator)17
F-TEST (DF denominator)38
p-value2.20934381900406e-14
Multiple Linear Regression - Residual Statistics
Residual Standard Deviation10.0190822837749
Sum Squared Residuals3814.516372744


Multiple Linear Regression - Actuals, Interpolation, and Residuals
Time or IndexActualsInterpolation
Forecast
Residuals
Prediction Error
110294.24040323301877.75959676698129
2105.1103.7461002644821.35389973551846
392.482.36598641648110.034013583519
481.476.02740161005695.37259838994313
5105.8100.8551132546244.9448867453756
6120.3114.6965358168665.60346418313407
7100.7104.525863854725-3.82586385472518
888.890.2428085520879-1.44280855208789
994.396.6321992962278-2.33219929622776
1099.993.2391520339436.66084796605706
11103.4116.792915656183-13.3929156561833
12103.3104.654965478633-1.35496547863286
1398.8105.040679705087-6.24067970508657
14104.2111.497952115501-7.29795211550119
1591.283.12296728647028.07703271352985
1674.778.4663610582967-3.76636105829667
17108.5102.8613688062655.63863119373523
18114.5117.372861655084-2.87286165508431
1996.9109.291163297658-12.3911632976583
2089.693.5553410252276-3.95534102522758
2197.197.4133924749686-0.313392474968604
22100.395.66064682088834.63935317911174
23122.6123.351533796078-0.751533796077798
24115.4116.412552625382-1.01255262538195
25109116.492038505162-7.49203850516242
26129.1129.432920983719-0.332920983718978
27102.895.53443104520437.26556895479571
2896.295.90254724349570.297452756504345
29127.7123.9752921821003.7247078179005
30128.9133.639298446054-4.73929844605406
31126.5125.9494385422870.55056145771306
32119.8110.7321232615119.06787673848912
33113.2119.272671493447-6.0726714934468
34114.1121.967919762438-7.867919762438
35134.1140.432468546754-6.33246854675421
36130127.3973247021972.60267529780310
37121.8130.364151564395-8.56415156439549
38132.1143.619611582494-11.5196115824944
39105.3107.177012286022-1.87701228602162
4010399.28133336865653.71866663134348
41117.1129.397061959720-12.2970619597197
42126.3136.715984794680-10.4159847946798
43138.1127.05522745493811.0447725450619
44119.5113.2421663774646.25783362253559
45138129.2817367353578.71826326464317
46135.5138.932281382731-3.43228138273081
47178.6158.12308200098520.4769179990153
48162.2162.435157193788-0.235157193788282
49176.9162.36272699233714.5372730076632
50204.9187.10341505380417.7965849461961
51132.2155.699602965823-23.4996029658230
52142.5148.122356719494-5.62235671949428
53164.3166.311163797292-2.01116379729165
54174.9162.47531928731612.4246807126842
55175.4170.7783068503914.62169314960861
56143152.927560783709-9.92756078370925


Goldfeld-Quandt test for Heteroskedasticity
p-valuesAlternative Hypothesis
breakpoint indexgreater2-sidedless
210.02917241163044990.05834482326089970.97082758836955
220.006806796279493630.01361359255898730.993193203720506
230.07015983371303060.1403196674260610.929840166286969
240.03109095168657130.06218190337314270.968909048313429
250.01447781579747570.02895563159495140.985522184202524
260.005567859998092540.01113571999618510.994432140001907
270.003800194701687220.007600389403374430.996199805298313
280.001468139239912460.002936278479824910.998531860760087
290.0007654810997851370.001530962199570270.999234518900215
300.000246688604539970.000493377209079940.99975331139546
310.0001249093268176660.0002498186536353330.999875090673182
320.0006933478825839930.001386695765167990.999306652117416
330.0003038667486650100.0006077334973300210.999696133251335
340.002116408762089850.00423281752417970.99788359123791
350.0006208108078952280.001241621615790460.999379189192105


Meta Analysis of Goldfeld-Quandt test for Heteroskedasticity
Description# significant tests% significant testsOK/NOK
1% type I error level90.6NOK
5% type I error level120.8NOK
10% type I error level140.933333333333333NOK