Multiple Linear Regression - Estimated Regression Equation
Totind[t] = -24.0516684867312 + 0.670388000769807Bouw[t] + 0.253998840317328`Yt-1`[t] + 0.269978457642583`Yt-2`[t] + 0.160638800436104`Yt-3`[t] -6.37661479692486M1[t] -1.88110503246155M2[t] -1.19156849898619M3[t] -2.50634377705874M4[t] + 1.38913552902864M5[t] -6.26009234136988M6[t] -6.86826776767659M7[t] -4.52699001781147M8[t] + 6.45481886381635M9[t] -7.94932174721686M10[t] + 0.517101623635753M11[t] -0.0448299433002486t + e[t]


Multiple Linear Regression - Ordinary Least Squares
VariableParameterS.D.T-STAT
H0: parameter = 0
2-tail p-value1-tail p-value
(Intercept)-24.05166848673126.175792-3.89450.0003650.000182
Bouw0.6703880007698070.04823913.897300
`Yt-1`0.2539988403173280.0566694.48216.1e-053e-05
`Yt-2`0.2699784576425830.0513465.25815e-063e-06
`Yt-3`0.1606388004361040.0665532.41370.0204620.010231
M1-6.376614796924861.715957-3.71610.0006190.000309
M2-1.881105032461553.210205-0.5860.5611830.280592
M3-1.191568498986193.243081-0.36740.7152440.357622
M4-2.506343777058742.561296-0.97850.3336860.166843
M51.389135529028641.8912410.73450.4669220.233461
M6-6.260092341369881.661245-3.76830.0005310.000265
M7-6.868267767676592.043213-3.36150.0017160.000858
M8-4.526990017811472.173725-2.08260.0437270.021863
M96.454818863816353.5339821.82650.0752450.037622
M10-7.949321747216863.093976-2.56930.0140250.007012
M110.5171016236357532.6637180.19410.8470580.423529
t-0.04482994330024860.014545-3.08210.0037130.001856


Multiple Linear Regression - Regression Statistics
Multiple R0.987973486143355
R-squared0.976091609322253
Adjusted R-squared0.966528253051154
F-TEST (value)102.065800086533
F-TEST (DF numerator)16
F-TEST (DF denominator)40
p-value0
Multiple Linear Regression - Residual Statistics
Residual Standard Deviation1.74653764901953
Sum Squared Residuals122.015750377706


Multiple Linear Regression - Actuals, Interpolation, and Residuals
Time or IndexActualsInterpolation
Forecast
Residuals
Prediction Error
1103.9104.969683629408-1.06968362940815
2101.6101.972519572344-0.372519572344110
394.694.39867405313820.201325946861819
495.996.986306182643-1.08630618264294
5104.7103.7346291988840.965370801115925
6102.8104.608374380020-1.80837438002040
798.199.353532073934-1.25353207393411
8113.9113.4908705192580.40912948074217
980.983.492815013044-2.59281501304397
1095.797.3567460350472-1.65674603504723
11113.2112.4176806546050.78231934539542
12105.9107.688100343550-1.78810034354973
13108.8104.5704161219754.22958387802476
14102.399.13439403373583.16560596626418
159997.87246004598221.12753995401782
16100.799.27948360376971.4205163962303
17115.5114.5653382968980.934661703101635
18100.7100.6375762450560.062423754943834
19109.9107.5332291806872.36677081931268
20114.6115.173916596827-0.573916596827391
2185.486.3832920013917-0.983292001391662
22100.5100.3144594626760.185540537324012
23114.8114.2251495879910.574850412009274
24116.5115.1395307734911.36046922650927
25112.9113.894329490909-0.994329490908626
26102103.561089292067-1.56108929206679
27106105.7662820417850.233717958215348
28105.3105.990974116503-0.690974116502855
29118.8119.182672808586-0.38267280858572
30106.1105.9186988097110.181301190288773
31109.3108.9911489898700.308851010130198
32117.2117.20897648659-0.00897648658987273
3392.591.501675319310.99832468069009
34104.2105.269237422476-1.06923742247619
35112.5113.676592704186-1.17659270418602
36122.4122.525515904845-0.125515904844945
37113.3112.7501736358270.549826364172864
38100100.862115563676-0.862115563675945
39110.7110.5358401526430.164159847357327
40112.8111.6012507575161.19874924248398
41109.8107.6873331255532.11266687444738
42117.3117.2711867347080.0288132652919417
43109.1110.140000366385-1.04000036638540
44115.9116.656334518825-0.756334518824865
459696.2669267851151-0.26692678511512
4699.897.25955707980062.54044292019941
47116.8116.980577053219-0.180577053218678
48115.7115.1468529781150.553147021885413
4999.4102.115397121881-2.71539712188085
5094.394.6698815381773-0.369881538177339
519192.7267437064523-1.72674370645231
5293.294.0419853395685-0.841985339568484
53103.1106.730026570079-3.63002657007922
5494.192.56416383050411.53583616949585
5591.892.1820893891234-0.382089389123366
56102.7101.76990187850.930098121499961
5782.679.75529088113932.84470911886066


Goldfeld-Quandt test for Heteroskedasticity
p-valuesAlternative Hypothesis
breakpoint indexgreater2-sidedless
200.2257320035344640.4514640070689280.774267996465536
210.161564782426140.323129564852280.83843521757386
220.09003874231194810.1800774846238960.909961257688052
230.09443936950901820.1888787390180360.905560630490982
240.0753684320008610.1507368640017220.924631567999139
250.1556560935670070.3113121871340150.844343906432993
260.4461536737891210.8923073475782430.553846326210879
270.5181015844853970.9637968310292060.481898415514603
280.3994471806297790.7988943612595580.600552819370221
290.3034143851241310.6068287702482630.696585614875868
300.2259747044290220.4519494088580430.774025295570978
310.1972377408533240.3944754817066480.802762259146676
320.1465918681171600.2931837362343200.85340813188284
330.1005067422596010.2010134845192020.8994932577404
340.08281197431711220.1656239486342240.917188025682888
350.1147846553964280.2295693107928560.885215344603572
360.1113911434746540.2227822869493080.888608856525346
370.05580666141428120.1116133228285620.94419333858572


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 level00OK