Multiple Linear Regression - Estimated Regression Equation
Omzet[t] = + 29.6444465901532 + 0.832814320948403Productie[t] -13.2023060390343M1[t] -14.0192330461690M2[t] -7.22885821757064M3[t] -12.0853823690019M4[t] -11.0120699935285M5[t] -8.77747562585243M6[t] -10.5632622060097M7[t] -20.7979652292691M8[t] -14.2683565650436M9[t] -10.2440374584020M10[t] -8.42173846251315M11[t] + 0.697992924868762t + e[t]


Multiple Linear Regression - Ordinary Least Squares
VariableParameterS.D.T-STAT
H0: parameter = 0
2-tail p-value1-tail p-value
(Intercept)29.644446590153214.963411.98110.0525850.026293
Productie0.8328143209484030.1577475.27942e-061e-06
M1-13.20230603903432.641013-4.9996e-063e-06
M2-14.01923304616902.649091-5.29212e-061e-06
M3-7.228858217570643.168455-2.28150.0264120.013206
M4-12.08538236900192.761009-4.37725.4e-052.7e-05
M5-11.01206999352852.684727-4.10170.0001376.8e-05
M6-8.777475625852433.277109-2.67840.0097350.004868
M7-10.56326220600973.288779-3.21190.0022050.001102
M8-20.79796522926912.680361-7.759400
M9-14.26835656504363.283533-4.34546e-053e-05
M10-10.24403745840203.448381-2.97070.0043990.002199
M11-8.421738462513152.972414-2.83330.0064280.003214
t0.6979929248687620.03954217.652100


Multiple Linear Regression - Regression Statistics
Multiple R0.979694556876288
R-squared0.959801424773025
Adjusted R-squared0.95029994335574
F-TEST (value)101.015976627284
F-TEST (DF numerator)13
F-TEST (DF denominator)55
p-value0
Multiple Linear Regression - Residual Statistics
Residual Standard Deviation4.35053862743482
Sum Squared Residuals1040.99524918413


Multiple Linear Regression - Actuals, Interpolation, and Residuals
Time or IndexActualsInterpolation
Forecast
Residuals
Prediction Error
1104.298.2562483363625.94375166363801
2103.297.80418852571675.39581147428328
3112.7112.2881965751500.411803424849511
4106.4105.8810666820270.518933317972653
5102.6103.821426106007-1.22142610600683
6110.6112.084025052621-1.48402505262144
795.296.7551065091152-1.5551065091152
88989.3004322130956-0.300432213095634
9112.5113.101038789063-0.601038789063119
10116.8119.405698030375-2.60569803037536
11107.2111.016122346709-3.8161223467089
12113.6118.720069388479-5.12006938847858
13101.8104.716690496606-2.91669049660587
14102.6106.180103624142-3.58010362414194
15122.7126.743656216499-4.04365621649898
16110.3114.423544644642-4.12354464464214
17110.5111.614371179768-1.11437117976810
18121.6126.206358965591-4.60635896559055
19100.3105.131021607540-4.83102160754035
20100.7103.422766126065-2.72276612606474
21123.4125.058055467566-1.65805546756638
22127.1126.6156730794730.484326920527255
23124.1123.8059533461610.294046653839383
24131.2131.0102117953610.189788204638797
25111.6112.676198434557-1.0761984345568
26114.2113.6399229695240.560077030476217
27130.1128.4570567473371.64294325266311
28125.9122.7161783109723.18382168902757
29119120.573256302857-1.57325630285711
30133.8136.664309866387-2.86430986638669
31107.5108.093643619801-0.593643619800858
32113.5110.8825854714472.61741452855336
33134.4132.6844376771381.71556232286203
34126.8131.327205165725-4.52720516572491
35135.6136.262658617233-0.662658617232932
36139.9139.969096918450-0.0690969184502082
37129.8124.7164965451555.08350345484509
38131126.0133468085014.98665319149873
39153.1145.8273665120057.2726334879952
40134.1129.3431833354064.75681666459406
41144.1138.7763803884735.32361961152656
42155.9145.62319498947610.2768050105243
43123.3120.2172231624943.0827768375062
44128.1123.2560093104244.84399068957587
45144.3142.3928556890811.90714431091945
46153148.5309520662034.46904793379688
47149.9148.0531124315471.84688756845348
48150.9148.0951677205912.80483227940916
49141138.9221118902192.07788810978111
50138.9138.2202077832890.679792216710943
51157.4156.9515688695600.448431130440338
52142.9142.2162957669520.683704233047565
53151.7146.6526068943305.04739310567046
54161156.1644273223674.83557267763329
55138.5134.5061199396533.99388006034739
56135.9134.7133373963581.18666260364164
57151.5148.8532978493242.64670215067564
58164161.8204716582242.17952834177614
59159.1156.7621532583512.33784674164897
60157154.8054541771192.19454582288084
61142.1151.212254297102-9.11225429710153
62144.8152.842230288827-8.04223028882722
63152.1157.832155079449-5.73215507944917
64154.9159.919731260000-5.01973125999971
65148.4154.861959128565-6.46195912856498
66157.3163.457683803559-6.15768380355891
67145.7145.796885161397-0.0968851613971864
68133.8139.424869482611-5.6248694826105
69156.8160.810314527828-4.01031452782762


Goldfeld-Quandt test for Heteroskedasticity
p-valuesAlternative Hypothesis
breakpoint indexgreater2-sidedless
170.2599450519939760.5198901039879520.740054948006024
180.1431063400571540.2862126801143080.856893659942846
190.089702392089890.179404784179780.91029760791011
200.04745900127902560.09491800255805120.952540998720974
210.03217307685107230.06434615370214460.967826923148928
220.0878895033655670.1757790067311340.912110496634433
230.1194542563181140.2389085126362270.880545743681886
240.1666858923969350.3333717847938710.833314107603065
250.1172247483263370.2344494966526740.882775251673663
260.08851620245946340.1770324049189270.911483797540537
270.1026057038611980.2052114077223960.897394296138802
280.1149379489743100.2298758979486210.88506205102569
290.08737740043449760.1747548008689950.912622599565502
300.1134231581151650.2268463162303300.886576841884835
310.1168198575774330.2336397151548670.883180142422567
320.1129330246584860.2258660493169720.887066975341514
330.1073621920021910.2147243840043820.89263780799781
340.2667928990362050.533585798072410.733207100963795
350.3774355459366080.7548710918732160.622564454063392
360.6044215263695470.7911569472609060.395578473630453
370.5696226625652530.8607546748694950.430377337434748
380.5187329604974680.9625340790050630.481267039502532
390.5438514628760670.9122970742478660.456148537123933
400.4859991504345470.9719983008690930.514000849565453
410.4224672894448290.8449345788896580.577532710555171
420.5938154964280870.8123690071438260.406184503571913
430.6673798609968740.6652402780062520.332620139003126
440.5740791772327470.8518416455345070.425920822767253
450.6399664962731850.720067007453630.360033503726815
460.6177026506000370.7645946987999260.382297349399963
470.7572399193315510.4855201613368970.242760080668449
480.8967690802553220.2064618394893570.103230919744678
490.9003202335432960.1993595329134080.099679766456704
500.8533822716539060.2932354566921880.146617728346094
510.8292170591418550.341565881716290.170782940858145
520.6969861771168650.606027645766270.303013822883135


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 level20.0555555555555556OK