Multiple Linear Regression - Estimated Regression Equation |
Totaal[t] = + 80.6199751233202 -0.00283909874382477Vrouwen[t] -0.00159293366137467Mannen[t] + 10.4049928272578M1[t] + 9.26659394050718M2[t] + 9.2121611220132M3[t] + 9.1050997513571M4[t] + 5.5323317390141M5[t] + 1.32699196787480M6[t] -0.438357788220186M7[t] -0.0177278005565451M8[t] -0.186935229537426M9[t] -0.554201233792353M10[t] -0.447555437283408M11[t] -0.95454723952818t + 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) | 80.6199751233202 | 7.989903 | 10.0902 | 0 | 0 |
Vrouwen | -0.00283909874382477 | 0.011099 | -0.2558 | 0.798728 | 0.399364 |
Mannen | -0.00159293366137467 | 0.028008 | -0.0569 | 0.954778 | 0.477389 |
M1 | 10.4049928272578 | 9.602324 | 1.0836 | 0.28161 | 0.140805 |
M2 | 9.26659394050718 | 9.690956 | 0.9562 | 0.341678 | 0.170839 |
M3 | 9.2121611220132 | 9.590675 | 0.9605 | 0.339511 | 0.169756 |
M4 | 9.1050997513571 | 9.582632 | 0.9502 | 0.344721 | 0.172361 |
M5 | 5.5323317390141 | 10.313817 | 0.5364 | 0.593083 | 0.296542 |
M6 | 1.32699196787480 | 10.946942 | 0.1212 | 0.903803 | 0.451901 |
M7 | -0.438357788220186 | 9.865543 | -0.0444 | 0.964663 | 0.482332 |
M8 | -0.0177278005565451 | 9.983864 | -0.0018 | 0.998587 | 0.499294 |
M9 | -0.186935229537426 | 9.86326 | -0.019 | 0.984923 | 0.492462 |
M10 | -0.554201233792353 | 9.861989 | -0.0562 | 0.955318 | 0.477659 |
M11 | -0.447555437283408 | 9.86793 | -0.0454 | 0.963931 | 0.481966 |
t | -0.95454723952818 | 0.069849 | -13.6658 | 0 | 0 |
Multiple Linear Regression - Regression Statistics | |
Multiple R | 0.838575876760288 |
R-squared | 0.703209501084286 |
Adjusted R-squared | 0.654326360086404 |
F-TEST (value) | 14.3855220169823 |
F-TEST (DF numerator) | 14 |
F-TEST (DF denominator) | 85 |
p-value | 1.11022302462516e-16 |
Multiple Linear Regression - Residual Statistics | |
Residual Standard Deviation | 19.7181113195452 |
Sum Squared Residuals | 33048.3326908480 |
Multiple Linear Regression - Actuals, Interpolation, and Residuals | |||
Time or Index | Actuals | Interpolation Forecast | Residuals Prediction Error |
1 | 168.836 | 89.6741682853434 | 79.1618317146566 |
2 | 150.581 | 87.6248460551269 | 62.9561539448731 |
3 | 149.514 | 86.5894845733534 | 62.9245154266466 |
4 | 148.281 | 85.5482484009716 | 62.7327515990284 |
5 | 125.968 | 81.039695765655 | 44.928304234345 |
6 | 96.566 | 76.0620898733107 | 20.5039101266893 |
7 | 84.416 | 73.324265154133 | 11.0917348458670 |
8 | 84.222 | 72.8127227765137 | 11.4092772234863 |
9 | 82.354 | 71.7002073755144 | 10.6537926244856 |
10 | 75.213 | 70.3165517409843 | 4.89644825901565 |
11 | 71.639 | 69.4757565940744 | 2.16324340592564 |
12 | 70.339 | 69.0301393556981 | 1.30886064430191 |
13 | 68.503 | 78.45766410582 | -9.95466410582 |
14 | 68.183 | 76.3652189951572 | -8.18221899515724 |
15 | 66.893 | 75.3571934577904 | -8.46419345779045 |
16 | 61.926 | 74.339458434283 | -12.413458434283 |
17 | 61.63 | 69.767345598594 | -8.137345598594 |
18 | 53.911 | 63.6150688365399 | -9.70406883653993 |
19 | 53.077 | 61.9497424295782 | -8.87274242957818 |
20 | 51.337 | 58.6430953912457 | -7.30609539124566 |
21 | 51.314 | 59.9738198860021 | -8.65981988600213 |
22 | 50.978 | 58.9527992929925 | -7.97479929299251 |
23 | 48.921 | 58.1312864447618 | -9.21028644476177 |
24 | 48.809 | 57.5927098960691 | -8.78370989606908 |
25 | 47.727 | 67.0537891183598 | -19.3267891183598 |
26 | 47.216 | 64.7832309663564 | -17.5672309663564 |
27 | 45.698 | 63.9761614171766 | -18.2781614171766 |
28 | 45.568 | 62.919531454469 | -17.3515314544690 |
29 | 44.102 | 58.3867816040563 | -14.2847816040563 |
30 | 42.489 | 53.2021268719709 | -10.7131268719709 |
31 | 42.102 | 50.5023263942436 | -8.40032639424359 |
32 | 38.251 | 49.3091279463212 | -11.0581279463212 |
33 | 37.657 | 48.8578113649368 | -11.2008113649368 |
34 | 36.817 | 47.5373611087309 | -10.7203611087309 |
35 | 35.818 | 46.6899356886906 | -10.8719356886906 |
36 | 35.685 | 46.1961358021216 | -10.5111358021216 |
37 | 35.516 | 55.6341284963133 | -20.1181284963133 |
38 | 35.101 | 52.5079816546146 | -17.4069816546146 |
39 | 34.173 | 52.5385262442664 | -18.3655262442664 |
40 | 33.234 | 51.4576797041484 | -18.2236797041484 |
41 | 29.635 | 44.3666706247043 | -14.7316706247043 |
42 | 27.75 | 41.7966780934392 | -14.0466780934392 |
43 | 27.086 | 39.0609769460366 | -11.9749769460366 |
44 | 26.385 | 38.5342788110774 | -12.1492788110774 |
45 | 25.009 | 37.4203624882323 | -12.4113624882323 |
46 | 24.076 | 36.1145183821435 | -12.0385183821435 |
47 | 23.779 | 35.2648519279336 | -11.4858519279336 |
48 | 23.296 | 34.7442088903132 | -11.4482088903132 |
49 | 23.01 | 44.1906238627731 | -21.1806238627731 |
50 | 22.971 | 41.7473495355205 | -18.7763495355205 |
51 | 22.723 | 41.1076803405487 | -18.3846803405487 |
52 | 21.938 | 40.0419449809578 | -18.1039449809578 |
53 | 21.446 | 33.5323745274941 | -12.0863745274941 |
54 | 21.402 | 30.3619245571503 | -8.95992455715032 |
55 | 21.2 | 27.6354929338431 | -6.43549293384313 |
56 | 20.89 | 27.0950697821455 | -6.20506978214547 |
57 | 20.85 | 25.9883724374437 | -5.13837243744369 |
58 | 19.73 | 24.0577041607592 | -4.32770416075922 |
59 | 19.661 | 23.8195971863115 | -4.15859718631155 |
60 | 19.264 | 23.3022157953447 | -4.03821579534465 |
61 | 18.98 | 32.7631980908499 | -13.7831980908499 |
62 | 18.836 | 30.3539975580862 | -11.5179975580862 |
63 | 17.203 | 29.6630326464873 | -12.4600326464873 |
64 | 17.06 | 28.5969915151768 | -11.5369915151768 |
65 | 16.828 | 22.5363288375538 | -5.70832883755381 |
66 | 16.574 | 16.2446800208474 | 0.329319979152554 |
67 | 16.218 | 16.1941482872857 | 0.0238517127143203 |
68 | 16.055 | 15.6652859268452 | 0.389714073154772 |
69 | 15.471 | 14.5414583687030 | 0.929541631296982 |
70 | 15.237 | 13.2209487567133 | 2.01605124328673 |
71 | 15.105 | 11.2546896215665 | 3.85031037843353 |
72 | 14.56 | 11.5856301821653 | 2.97436981783465 |
73 | 14.29 | 21.3063277091048 | -7.01632770910477 |
74 | 14.148 | 19.2256962742428 | -5.07769627424279 |
75 | 14.105 | 18.2151518893415 | -4.11015188934148 |
76 | 13.995 | 17.1417079627953 | -3.14670796279532 |
77 | 13.961 | 12.6246629320145 | 1.33633706798546 |
78 | 13.916 | 6.6132064199076 | 7.3027935800924 |
79 | 12.982 | 4.74552995343328 | 8.23647004656672 |
80 | 12.671 | 4.21688804642512 | 8.45411195357488 |
81 | 11.415 | 3.0952375342966 | 8.3197624657034 |
82 | 11.393 | 1.77187580600281 | 9.62112419399719 |
83 | 11.363 | 0.922387182405236 | 10.4406128175948 |
84 | 11.152 | 0.408112435848917 | 10.7438875641511 |
85 | 10.73 | 8.6654204431768 | 2.06457955682320 |
86 | 10.402 | 7.76973792458827 | 2.63226207541173 |
87 | 10.004 | 6.7668849498468 | 3.2371150501532 |
88 | 9.902 | 5.70563287388027 | 4.19636712611973 |
89 | 9.857 | 1.17314010992798 | 8.68385989007202 |
90 | 9.738 | -5.54977467316614 | 15.2877746731661 |
91 | 9.625 | -6.70648209855343 | 16.3314820985534 |
92 | 9.228 | -7.23746868057377 | 16.4654686805738 |
93 | 9.145 | -8.36226945512902 | 17.507269455129 |
94 | 8.846 | -9.68175924832662 | 18.5277592483266 |
95 | 8.749 | -10.5235046457436 | 19.2725046457436 |
96 | 8.718 | -11.0361523575609 | 19.7541523575609 |
97 | 8.569 | -1.58432011174113 | 10.1533201117411 |
98 | 8.473 | -4.46705896369276 | 12.9400589636928 |
99 | 8.309 | -5.59211551881115 | 13.9011155188111 |
100 | 8.103 | -5.74419532668216 | 13.8471953266822 |