Multiple Linear Regression - Estimated Regression Equation |
geboortes[t] = + 9430.3111111111 + 286.706944444442x[t] + 99.1618551587258M1[t] -638.203273809524M2[t] -284.711259920635M3[t] -37.555158730158M4[t] -920.277430555555M5[t] + 41.0002976190481M6[t] -338.555307539682M7[t] -164.444246031746M8[t] -214.333184523809M9[t] + 355.611210317461M10[t] + 228.722271825397M11[t] + 5.2222718253969t + e[t] |
Multiple Linear Regression - Ordinary Least Squares | |||||
Variable | Parameter | S.D. | T-STAT H0: parameter = 0 | 2-tail p-value | 1-tail p-value |
(Intercept) | 9430.3111111111 | 140.713171 | 67.018 | 0 | 0 |
x | 286.706944444442 | 134.583356 | 2.1303 | 0.037185 | 0.018593 |
M1 | 99.1618551587258 | 158.573874 | 0.6253 | 0.534083 | 0.267042 |
M2 | -638.203273809524 | 158.462983 | -4.0275 | 0.000159 | 7.9e-05 |
M3 | -284.711259920635 | 158.413321 | -1.7973 | 0.077243 | 0.038622 |
M4 | -37.555158730158 | 166.197782 | -0.226 | 0.821983 | 0.410991 |
M5 | -920.277430555555 | 165.759024 | -5.5519 | 1e-06 | 0 |
M6 | 41.0002976190481 | 165.377825 | 0.2479 | 0.80503 | 0.402515 |
M7 | -338.555307539682 | 165.054585 | -2.0512 | 0.044552 | 0.022276 |
M8 | -164.444246031746 | 164.789644 | -0.9979 | 0.322268 | 0.161134 |
M9 | -214.333184523809 | 164.583284 | -1.3023 | 0.197717 | 0.098859 |
M10 | 355.611210317461 | 164.435725 | 2.1626 | 0.034501 | 0.01725 |
M11 | 228.722271825397 | 164.347126 | 1.3917 | 0.169067 | 0.084533 |
t | 5.2222718253969 | 3.116074 | 1.6759 | 0.098874 | 0.049437 |
Multiple Linear Regression - Regression Statistics | |
Multiple R | 0.857999753809147 |
R-squared | 0.736163577536557 |
Adjusted R-squared | 0.679936143241069 |
F-TEST (value) | 13.0926048246813 |
F-TEST (DF numerator) | 13 |
F-TEST (DF denominator) | 61 |
p-value | 3.89466237038505e-13 |
Multiple Linear Regression - Residual Statistics | |
Residual Standard Deviation | 284.606401731326 |
Sum Squared Residuals | 4941049.03829364 |
Multiple Linear Regression - Actuals, Interpolation, and Residuals | |||
Time or Index | Actuals | Interpolation Forecast | Residuals Prediction Error |
1 | 9700 | 9534.69523809526 | 165.304761904736 |
2 | 9081 | 8802.55238095238 | 278.44761904762 |
3 | 9084 | 9161.26666666666 | -77.2666666666647 |
4 | 9743 | 9413.64503968254 | 329.354960317462 |
5 | 8587 | 8536.14503968254 | 50.8549603174615 |
6 | 9731 | 9502.64503968254 | 228.354960317461 |
7 | 9563 | 9128.3117063492 | 434.688293650795 |
8 | 9998 | 9307.64503968254 | 690.354960317462 |
9 | 9437 | 9262.97837301587 | 174.021626984128 |
10 | 10038 | 9838.14503968254 | 199.854960317462 |
11 | 9918 | 9716.47837301587 | 201.521626984128 |
12 | 9252 | 9492.97837301587 | -240.978373015872 |
13 | 9737 | 9597.3625 | 139.637500000006 |
14 | 9035 | 8865.21964285714 | 169.780357142858 |
15 | 9133 | 9223.93392857143 | -90.9339285714277 |
16 | 9487 | 9476.3123015873 | 10.6876984126986 |
17 | 8700 | 8598.8123015873 | 101.187698412699 |
18 | 9627 | 9565.3123015873 | 61.6876984126987 |
19 | 8947 | 9190.97896825397 | -243.978968253968 |
20 | 9283 | 9370.3123015873 | -87.3123015873014 |
21 | 8829 | 9325.64563492063 | -496.645634920634 |
22 | 9947 | 9900.8123015873 | 46.1876984126987 |
23 | 9628 | 9779.14563492063 | -151.145634920635 |
24 | 9318 | 9555.64563492063 | -237.645634920635 |
25 | 9605 | 9660.02976190476 | -55.0297619047573 |
26 | 8640 | 8927.8869047619 | -287.886904761905 |
27 | 9214 | 9286.60119047619 | -72.6011904761906 |
28 | 9567 | 9538.97956349206 | 28.0204365079358 |
29 | 8547 | 8661.47956349206 | -114.479563492064 |
30 | 9185 | 9627.97956349206 | -442.979563492064 |
31 | 9470 | 9253.64623015873 | 216.353769841269 |
32 | 9123 | 9432.97956349206 | -309.979563492064 |
33 | 9278 | 9388.3128968254 | -110.312896825398 |
34 | 10170 | 9963.47956349206 | 206.520436507936 |
35 | 9434 | 9841.8128968254 | -407.812896825397 |
36 | 9655 | 9618.3128968254 | 36.6871031746026 |
37 | 9429 | 9722.69702380952 | -293.69702380952 |
38 | 8739 | 8990.55416666667 | -251.554166666667 |
39 | 9552 | 9349.26845238095 | 202.731547619047 |
40 | 9687 | 9888.35376984127 | -201.353769841269 |
41 | 9019 | 9010.85376984127 | 8.14623015873069 |
42 | 9672 | 9977.35376984127 | -305.353769841269 |
43 | 9206 | 9603.02043650794 | -397.020436507936 |
44 | 9069 | 9782.35376984127 | -713.35376984127 |
45 | 9788 | 9737.6871031746 | 50.3128968253973 |
46 | 10312 | 10312.8537698413 | -0.853769841269287 |
47 | 10105 | 10191.1871031746 | -86.1871031746026 |
48 | 9863 | 9967.6871031746 | -104.687103174603 |
49 | 9656 | 10072.0712301587 | -416.071230158725 |
50 | 9295 | 9339.92837301587 | -44.9283730158728 |
51 | 9946 | 9698.64265873016 | 247.357341269842 |
52 | 9701 | 9951.02103174603 | -250.021031746032 |
53 | 9049 | 9073.52103174603 | -24.5210317460321 |
54 | 10190 | 10040.021031746 | 149.978968253968 |
55 | 9706 | 9665.6876984127 | 40.3123015873013 |
56 | 9765 | 9845.02103174603 | -80.021031746032 |
57 | 9893 | 9800.35436507937 | 92.6456349206346 |
58 | 9994 | 10375.521031746 | -381.521031746032 |
59 | 10433 | 10253.8543650794 | 179.145634920635 |
60 | 10073 | 10030.3543650794 | 42.6456349206347 |
61 | 10112 | 10134.7384920635 | -22.7384920634879 |
62 | 9266 | 9402.59563492064 | -136.595634920636 |
63 | 9820 | 9761.30992063492 | 58.6900793650788 |
64 | 10097 | 10013.6882936508 | 83.3117063492052 |
65 | 9115 | 9136.1882936508 | -21.1882936507949 |
66 | 10411 | 10102.6882936508 | 308.311706349205 |
67 | 9678 | 9728.35496031746 | -50.3549603174615 |
68 | 10408 | 9907.6882936508 | 500.311706349205 |
69 | 10153 | 9863.02162698413 | 289.978373015872 |
70 | 10368 | 10438.1882936508 | -70.1882936507949 |
71 | 10581 | 10316.5216269841 | 264.478373015872 |
72 | 10597 | 10093.0216269841 | 503.978373015872 |
73 | 10680 | 10197.4057539683 | 482.594246031749 |
74 | 9738 | 9465.2628968254 | 272.737103174602 |
75 | 9556 | 9823.97718253968 | -267.977182539684 |
Goldfeld-Quandt test for Heteroskedasticity | |||
p-values | Alternative Hypothesis | ||
breakpoint index | greater | 2-sided | less |
17 | 0.128704094160692 | 0.257408188321383 | 0.871295905839308 |
18 | 0.0585261049506291 | 0.117052209901258 | 0.941473895049371 |
19 | 0.332367614469383 | 0.664735228938767 | 0.667632385530617 |
20 | 0.550884107448718 | 0.898231785102564 | 0.449115892551282 |
21 | 0.586756671353637 | 0.826486657292726 | 0.413243328646363 |
22 | 0.513449018504325 | 0.97310196299135 | 0.486550981495675 |
23 | 0.407871981551796 | 0.815743963103592 | 0.592128018448204 |
24 | 0.370593804769147 | 0.741187609538295 | 0.629406195230853 |
25 | 0.319036561008134 | 0.638073122016268 | 0.680963438991866 |
26 | 0.249508717541665 | 0.49901743508333 | 0.750491282458335 |
27 | 0.280486322768488 | 0.560972645536976 | 0.719513677231512 |
28 | 0.242372334677351 | 0.484744669354702 | 0.757627665322649 |
29 | 0.182497335099524 | 0.364994670199048 | 0.817502664900476 |
30 | 0.197747143157017 | 0.395494286314035 | 0.802252856842983 |
31 | 0.299959030274241 | 0.599918060548483 | 0.700040969725759 |
32 | 0.28770785260175 | 0.575415705203501 | 0.71229214739825 |
33 | 0.288768577780508 | 0.577537155561016 | 0.711231422219492 |
34 | 0.382424533003739 | 0.764849066007479 | 0.617575466996261 |
35 | 0.374207099953584 | 0.748414199907168 | 0.625792900046416 |
36 | 0.442915661496232 | 0.885831322992463 | 0.557084338503768 |
37 | 0.384864629026904 | 0.769729258053809 | 0.615135370973096 |
38 | 0.359014037214078 | 0.718028074428156 | 0.640985962785922 |
39 | 0.44630739378285 | 0.892614787565699 | 0.55369260621715 |
40 | 0.375181631546515 | 0.75036326309303 | 0.624818368453485 |
41 | 0.364361540384443 | 0.728723080768885 | 0.635638459615557 |
42 | 0.316459530508155 | 0.63291906101631 | 0.683540469491845 |
43 | 0.282369215667823 | 0.564738431335647 | 0.717630784332177 |
44 | 0.545537159609201 | 0.908925680781599 | 0.454462840390799 |
45 | 0.562852318887975 | 0.87429536222405 | 0.437147681112025 |
46 | 0.627185925495234 | 0.745628149009532 | 0.372814074504766 |
47 | 0.564436560349906 | 0.871126879300189 | 0.435563439650094 |
48 | 0.503167450735575 | 0.99366509852885 | 0.496832549264425 |
49 | 0.559425109492357 | 0.881149781015287 | 0.440574890507643 |
50 | 0.483790186403116 | 0.967580372806233 | 0.516209813596883 |
51 | 0.783017429210443 | 0.433965141579113 | 0.216982570789557 |
52 | 0.705302666891455 | 0.58939466621709 | 0.294697333108545 |
53 | 0.648188520995924 | 0.703622958008151 | 0.351811479004076 |
54 | 0.584657412834872 | 0.830685174330256 | 0.415342587165128 |
55 | 0.58036611538795 | 0.8392677692241 | 0.41963388461205 |
56 | 0.558480063448771 | 0.883039873102458 | 0.441519936551229 |
57 | 0.429348480632675 | 0.858696961265349 | 0.570651519367325 |
58 | 0.293459673420112 | 0.586919346840224 | 0.706540326579888 |
Meta Analysis of Goldfeld-Quandt test for Heteroskedasticity | |||
Description | # significant tests | % significant tests | OK/NOK |
1% type I error level | 0 | 0 | OK |
5% type I error level | 0 | 0 | OK |
10% type I error level | 0 | 0 | OK |