Multiple Linear Regression - Estimated Regression Equation |
Popularity[t] = -0.983357375578792 + 0.0893813706555356month[t] + 0.104378264723487FindingFriends[t] + 0.211622867223575KnowingPeople[t] + 0.385193850989470Liked[t] + 0.594410135928509Celebrity[t] + 0.307649945898061bestfriend[t] -0.0324002150208811secondbestfriend[t] + 0.411552931191423thirdbestfriend[t] -0.00181007322403901t + 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) | -0.983357375578792 | 6.011657 | -0.1636 | 0.870292 | 0.435146 |
month | 0.0893813706555356 | 0.640842 | 0.1395 | 0.889267 | 0.444634 |
FindingFriends | 0.104378264723487 | 0.098559 | 1.059 | 0.291327 | 0.145664 |
KnowingPeople | 0.211622867223575 | 0.06405 | 3.304 | 0.001199 | 6e-04 |
Liked | 0.385193850989470 | 0.099038 | 3.8894 | 0.000152 | 7.6e-05 |
Celebrity | 0.594410135928509 | 0.156961 | 3.787 | 0.000222 | 0.000111 |
bestfriend | 0.307649945898061 | 0.211991 | 1.4512 | 0.148859 | 0.074429 |
secondbestfriend | -0.0324002150208811 | 0.20236 | -0.1601 | 0.873014 | 0.436507 |
thirdbestfriend | 0.411552931191423 | 0.214612 | 1.9177 | 0.057107 | 0.028553 |
t | -0.00181007322403901 | 0.006864 | -0.2637 | 0.792389 | 0.396194 |
Multiple Linear Regression - Regression Statistics | |
Multiple R | 0.719101919830673 |
R-squared | 0.51710757110416 |
Adjusted R-squared | 0.487340229596882 |
F-TEST (value) | 17.3716410307495 |
F-TEST (DF numerator) | 9 |
F-TEST (DF denominator) | 146 |
p-value | 0 |
Multiple Linear Regression - Residual Statistics | |
Residual Standard Deviation | 2.1026328891003 |
Sum Squared Residuals | 645.475499683636 |
Multiple Linear Regression - Actuals, Interpolation, and Residuals | |||
Time or Index | Actuals | Interpolation Forecast | Residuals Prediction Error |
1 | 13 | 11.2049026711581 | 1.79509732884189 |
2 | 12 | 11.0501976167471 | 0.94980238325289 |
3 | 15 | 13.1284642259693 | 1.87153577403075 |
4 | 12 | 11.4502389709335 | 0.549761029066484 |
5 | 10 | 10.9719246015601 | -0.97192460156013 |
6 | 12 | 9.36122331907425 | 2.63877668092575 |
7 | 15 | 16.9268608320424 | -1.92686083204242 |
8 | 9 | 10.3094079411661 | -1.30940794116615 |
9 | 12 | 13.0209978602754 | -1.02099786027543 |
10 | 11 | 7.54336622238227 | 3.45663377761773 |
11 | 11 | 13.0149485846245 | -2.01494858462453 |
12 | 11 | 12.1838317170145 | -1.18383171701454 |
13 | 15 | 12.2991592688119 | 2.70084073118813 |
14 | 7 | 11.4832734656525 | -4.48327346565248 |
15 | 11 | 11.2781603020676 | -0.278160302067564 |
16 | 11 | 10.8220760751143 | 0.177923924885652 |
17 | 10 | 11.8347311899754 | -1.83473118997540 |
18 | 14 | 14.8674128169904 | -0.867412816990426 |
19 | 10 | 8.568239700105 | 1.43176029989501 |
20 | 6 | 9.3425500044131 | -3.34255000441309 |
21 | 11 | 8.77932092658329 | 2.22067907341672 |
22 | 15 | 14.0737626346785 | 0.926237365321513 |
23 | 11 | 11.5803388330651 | -0.580338833065076 |
24 | 12 | 9.74160524658529 | 2.25839475341471 |
25 | 14 | 13.0843361390877 | 0.915663860912256 |
26 | 15 | 14.5245748735349 | 0.475425126465101 |
27 | 9 | 14.3087353508027 | -5.30873535080275 |
28 | 13 | 12.4834032242154 | 0.516596775784634 |
29 | 13 | 13.4529879522718 | -0.452987952271807 |
30 | 16 | 11.1694519977055 | 4.83054800229448 |
31 | 13 | 8.75162527439104 | 4.24837472560896 |
32 | 12 | 13.6248490819480 | -1.62484908194797 |
33 | 14 | 14.5697830251290 | -0.569783025128966 |
34 | 11 | 9.60790170281558 | 1.39209829718442 |
35 | 9 | 10.2281357490962 | -1.22813574909621 |
36 | 16 | 14.1849071539586 | 1.81509284604136 |
37 | 12 | 13.1540413424309 | -1.15404134243088 |
38 | 10 | 9.71307390046835 | 0.286926099531649 |
39 | 13 | 13.1545469131956 | -0.154546913195559 |
40 | 16 | 15.2287736182529 | 0.771226381747053 |
41 | 14 | 13.1151849345199 | 0.884815065480128 |
42 | 15 | 8.0705833181084 | 6.9294166818916 |
43 | 5 | 9.71510528588548 | -4.71510528588548 |
44 | 8 | 10.3134380241432 | -2.31343802414315 |
45 | 11 | 11.1487052586015 | -0.148705258601461 |
46 | 16 | 14.2175074662198 | 1.78249253378025 |
47 | 17 | 14.2475308431785 | 2.75246915682147 |
48 | 9 | 8.0287939713907 | 0.9712060286093 |
49 | 9 | 11.3995874334900 | -2.39958743349003 |
50 | 13 | 14.8178416598702 | -1.81784165987018 |
51 | 10 | 10.8886453480061 | -0.888645348006098 |
52 | 6 | 11.9910442211409 | -5.99104422114089 |
53 | 12 | 11.8495190412859 | 0.150480958714054 |
54 | 8 | 10.4331664434410 | -2.43316644344105 |
55 | 14 | 11.8091063908163 | 2.19089360918366 |
56 | 12 | 12.8761180336080 | -0.876118033608047 |
57 | 11 | 11.1092335643711 | -0.109233564371141 |
58 | 16 | 14.1747570596022 | 1.82524294039776 |
59 | 8 | 10.2776291475077 | -2.27762914750773 |
60 | 15 | 14.6575447101163 | 0.342455289883676 |
61 | 7 | 9.15112059843979 | -2.15112059843979 |
62 | 16 | 13.9464110345232 | 2.05358896547682 |
63 | 14 | 12.9130473900452 | 1.08695260995478 |
64 | 16 | 13.661414209331 | 2.338585790669 |
65 | 9 | 10.2507224958308 | -1.25072249583076 |
66 | 14 | 12.3894985830801 | 1.61050141691992 |
67 | 11 | 13.2954002601194 | -2.29540026011941 |
68 | 13 | 10.4232974364030 | 2.57670256359698 |
69 | 15 | 13.0175810545881 | 1.98241894541193 |
70 | 5 | 5.82162779891743 | -0.821627798917435 |
71 | 15 | 12.938348305903 | 2.061651694097 |
72 | 13 | 11.9737875527751 | 1.02621244722486 |
73 | 11 | 13.0575037847135 | -2.05750378471349 |
74 | 11 | 14.1346593713084 | -3.13465937130841 |
75 | 12 | 12.2462910576543 | -0.246291057654347 |
76 | 12 | 13.4605564914878 | -1.46055649148783 |
77 | 12 | 12.8158509750580 | -0.81585097505803 |
78 | 12 | 12.1256704010635 | -0.125670401063508 |
79 | 14 | 11.0986370101107 | 2.90136298988934 |
80 | 6 | 8.02152943171598 | -2.02152943171598 |
81 | 7 | 9.46530618764306 | -2.46530618764306 |
82 | 14 | 12.6302867701622 | 1.36971322983782 |
83 | 14 | 14.0434433176965 | -0.0434433176964516 |
84 | 10 | 10.9996709892448 | -0.999670989244844 |
85 | 13 | 9.39576007708632 | 3.60423992291368 |
86 | 12 | 12.4552688010383 | -0.455268801038252 |
87 | 9 | 9.09895259471804 | -0.0989525947180386 |
88 | 12 | 12.3827335866523 | -0.382733586652303 |
89 | 16 | 15.1126325964851 | 0.887367403514898 |
90 | 10 | 10.8271360363588 | -0.827136036358803 |
91 | 14 | 13.0149414140629 | 0.985058585937127 |
92 | 10 | 13.6743590227115 | -3.67435902271151 |
93 | 16 | 15.0189494268598 | 0.98105057314016 |
94 | 15 | 13.3269385259384 | 1.67306147406163 |
95 | 12 | 11.4956913796953 | 0.504308620304676 |
96 | 10 | 9.29698432053747 | 0.703015679462536 |
97 | 8 | 10.2975523598291 | -2.29755235982907 |
98 | 8 | 8.4817653155485 | -0.4817653155485 |
99 | 11 | 12.5542135160764 | -1.55421351607642 |
100 | 13 | 13.0145764114289 | -0.0145764114288983 |
101 | 16 | 15.8957167506989 | 0.104283249301138 |
102 | 16 | 15.1898453567617 | 0.81015464323831 |
103 | 14 | 15.6944063024031 | -1.69440630240307 |
104 | 11 | 8.99400888584843 | 2.00599111415157 |
105 | 4 | 7.37063441742283 | -3.37063441742284 |
106 | 14 | 14.6930170629043 | -0.69301706290434 |
107 | 9 | 10.5659658154158 | -1.56596581541582 |
108 | 14 | 15.2574638574311 | -1.25746385743105 |
109 | 8 | 10.0167137756442 | -2.01671377564416 |
110 | 8 | 10.4697500279441 | -2.46975002794406 |
111 | 11 | 11.9652097964192 | -0.965209796419187 |
112 | 12 | 13.1931382162864 | -1.19313821628645 |
113 | 11 | 11.0137981823412 | -0.0137981823411839 |
114 | 14 | 13.0197127994167 | 0.980287200583345 |
115 | 15 | 14.4011837376831 | 0.598816262316856 |
116 | 16 | 13.3534432962753 | 2.64655670372468 |
117 | 16 | 12.8731118109995 | 3.12688818900047 |
118 | 11 | 12.6472019672902 | -1.64720196729016 |
119 | 14 | 13.3630666028829 | 0.63693339711708 |
120 | 14 | 10.9961495101169 | 3.00385048988306 |
121 | 12 | 11.5554143228783 | 0.444585677121667 |
122 | 14 | 13.0527898702698 | 0.947210129730188 |
123 | 8 | 10.8065061752171 | -2.80650617521711 |
124 | 13 | 14.2747980236383 | -1.27479802363834 |
125 | 16 | 14.5086598466098 | 1.49134015339024 |
126 | 12 | 10.5694280782661 | 1.43057192173394 |
127 | 16 | 15.8410718755826 | 0.158928124417362 |
128 | 12 | 12.6796300217692 | -0.6796300217692 |
129 | 11 | 11.2682259994715 | -0.26822599947148 |
130 | 4 | 5.69832608065275 | -1.69832608065275 |
131 | 16 | 16.0766810985428 | -0.0766810985427819 |
132 | 15 | 13.0638986707597 | 1.93610132924026 |
133 | 10 | 11.1235806511745 | -1.12358065117449 |
134 | 13 | 14.2784553749570 | -1.27845537495702 |
135 | 15 | 12.5641071957015 | 2.43589280429851 |
136 | 12 | 10.1741917457575 | 1.82580825424246 |
137 | 14 | 12.8469543039562 | 1.15304569604381 |
138 | 7 | 10.3775092422047 | -3.37750924220472 |
139 | 19 | 13.7053566491609 | 5.29464335083911 |
140 | 12 | 13.0227660694378 | -1.02276606943781 |
141 | 12 | 11.8821733463978 | 0.117826653602175 |
142 | 13 | 13.2070126965691 | -0.207012696569090 |
143 | 15 | 12.4076173372964 | 2.59238266270357 |
144 | 8 | 8.9046262949945 | -0.904626294994503 |
145 | 12 | 11.1211270460751 | 0.878872953924872 |
146 | 10 | 10.3911752139798 | -0.391175213979777 |
147 | 8 | 11.2623122209065 | -3.26231222090646 |
148 | 10 | 14.2774505151922 | -4.27745051519218 |
149 | 15 | 14.1609097605415 | 0.839090239458515 |
150 | 16 | 13.9641477830056 | 2.03585221699443 |
151 | 13 | 13.1799642692192 | -0.179964269219202 |
152 | 16 | 14.9690796300644 | 1.03092036993557 |
153 | 9 | 9.6862486002568 | -0.6862486002568 |
154 | 14 | 13.2785335658949 | 0.721466434105089 |
155 | 14 | 13.3355686009417 | 0.664431399058298 |
156 | 12 | 9.96088127603094 | 2.03911872396906 |
Goldfeld-Quandt test for Heteroskedasticity | |||
p-values | Alternative Hypothesis | ||
breakpoint index | greater | 2-sided | less |
13 | 0.836001792063908 | 0.327996415872184 | 0.163998207936092 |
14 | 0.90195839407854 | 0.196083211842921 | 0.0980416059214603 |
15 | 0.879240557644519 | 0.241518884710961 | 0.120759442355481 |
16 | 0.808616793673195 | 0.38276641265361 | 0.191383206326805 |
17 | 0.726585161757706 | 0.546829676484589 | 0.273414838242294 |
18 | 0.666797038131056 | 0.666405923737887 | 0.333202961868944 |
19 | 0.607910346534051 | 0.784179306931898 | 0.392089653465949 |
20 | 0.702128356781856 | 0.595743286436289 | 0.297871643218144 |
21 | 0.69419228673152 | 0.61161542653696 | 0.30580771326848 |
22 | 0.745316120165674 | 0.509367759668652 | 0.254683879834326 |
23 | 0.683418423843554 | 0.633163152312892 | 0.316581576156446 |
24 | 0.707777132038689 | 0.584445735922622 | 0.292222867961311 |
25 | 0.684535775162727 | 0.630928449674546 | 0.315464224837273 |
26 | 0.626079763990605 | 0.74784047201879 | 0.373920236009395 |
27 | 0.806167163016805 | 0.38766567396639 | 0.193832836983195 |
28 | 0.770975653320348 | 0.458048693359304 | 0.229024346679652 |
29 | 0.717035116657027 | 0.565929766685945 | 0.282964883342973 |
30 | 0.818623909680047 | 0.362752180639907 | 0.181376090319953 |
31 | 0.860156619654828 | 0.279686760690343 | 0.139843380345172 |
32 | 0.829666210992467 | 0.340667578015067 | 0.170333789007533 |
33 | 0.787312593252715 | 0.425374813494571 | 0.212687406747285 |
34 | 0.754905410599089 | 0.490189178801822 | 0.245094589400911 |
35 | 0.73641206799925 | 0.5271758640015 | 0.26358793200075 |
36 | 0.75671946346538 | 0.486561073069240 | 0.243280536534620 |
37 | 0.740078036428823 | 0.519843927142354 | 0.259921963571177 |
38 | 0.696462188811621 | 0.607075622376758 | 0.303537811188379 |
39 | 0.646302343994341 | 0.707395312011317 | 0.353697656005659 |
40 | 0.602581686654113 | 0.794836626691774 | 0.397418313345887 |
41 | 0.552645639537822 | 0.894708720924356 | 0.447354360462178 |
42 | 0.84317630073654 | 0.313647398526920 | 0.156823699263460 |
43 | 0.970814918196872 | 0.0583701636062555 | 0.0291850818031278 |
44 | 0.971754476204528 | 0.0564910475909433 | 0.0282455237954716 |
45 | 0.96311606905583 | 0.0737678618883389 | 0.0368839309441695 |
46 | 0.968695846103813 | 0.0626083077923736 | 0.0313041538961868 |
47 | 0.975019136896097 | 0.0499617262078063 | 0.0249808631039031 |
48 | 0.971592200610986 | 0.0568155987780278 | 0.0284077993890139 |
49 | 0.968059130521681 | 0.0638817389566376 | 0.0319408694783188 |
50 | 0.959432758930122 | 0.0811344821397565 | 0.0405672410698782 |
51 | 0.952729142815977 | 0.0945417143680463 | 0.0472708571840232 |
52 | 0.98927272721028 | 0.0214545455794396 | 0.0107272727897198 |
53 | 0.9858034259063 | 0.0283931481873983 | 0.0141965740936991 |
54 | 0.989154915195705 | 0.0216901696085893 | 0.0108450848042947 |
55 | 0.992767891002053 | 0.0144642179958943 | 0.00723210899794713 |
56 | 0.990211719081638 | 0.0195765618367242 | 0.0097882809183621 |
57 | 0.986513154464591 | 0.0269736910708180 | 0.0134868455354090 |
58 | 0.985847831176755 | 0.0283043376464893 | 0.0141521688232447 |
59 | 0.989059578811089 | 0.0218808423778230 | 0.0109404211889115 |
60 | 0.987859033576145 | 0.0242819328477109 | 0.0121409664238554 |
61 | 0.987798331713595 | 0.0244033365728104 | 0.0122016682864052 |
62 | 0.98944721857309 | 0.0211055628538185 | 0.0105527814269092 |
63 | 0.987885575354576 | 0.0242288492908479 | 0.0121144246454240 |
64 | 0.988287441365562 | 0.0234251172688757 | 0.0117125586344379 |
65 | 0.98765989832796 | 0.0246802033440793 | 0.0123401016720396 |
66 | 0.985670308211707 | 0.0286593835765867 | 0.0143296917882934 |
67 | 0.987314716348945 | 0.0253705673021098 | 0.0126852836510549 |
68 | 0.98886990629376 | 0.0222601874124777 | 0.0111300937062389 |
69 | 0.98829809144191 | 0.0234038171161807 | 0.0117019085580904 |
70 | 0.985082355025686 | 0.0298352899486286 | 0.0149176449743143 |
71 | 0.985556940612977 | 0.0288861187740467 | 0.0144430593870233 |
72 | 0.982164316846268 | 0.0356713663074635 | 0.0178356831537317 |
73 | 0.982498792377714 | 0.0350024152445722 | 0.0175012076222861 |
74 | 0.987403010396265 | 0.0251939792074701 | 0.0125969896037350 |
75 | 0.983349535585278 | 0.0333009288294438 | 0.0166504644147219 |
76 | 0.980156242237186 | 0.0396875155256273 | 0.0198437577628136 |
77 | 0.974293116574388 | 0.0514137668512235 | 0.0257068834256118 |
78 | 0.96666173246263 | 0.0666765350747412 | 0.0333382675373706 |
79 | 0.975640128211654 | 0.0487197435766918 | 0.0243598717883459 |
80 | 0.9739942985895 | 0.0520114028209998 | 0.0260057014104999 |
81 | 0.974966944190363 | 0.0500661116192741 | 0.0250330558096371 |
82 | 0.972983482915995 | 0.0540330341680098 | 0.0270165170840049 |
83 | 0.964448945316955 | 0.0711021093660903 | 0.0355510546830452 |
84 | 0.955210581156971 | 0.0895788376860576 | 0.0447894188430288 |
85 | 0.98199807376122 | 0.0360038524775582 | 0.0180019262387791 |
86 | 0.976014075078278 | 0.0479718498434442 | 0.0239859249217221 |
87 | 0.968722511477614 | 0.0625549770447716 | 0.0312774885223858 |
88 | 0.959748950399903 | 0.0805020992001947 | 0.0402510496000973 |
89 | 0.95100817915353 | 0.097983641692941 | 0.0489918208464705 |
90 | 0.938475804561582 | 0.123048390876836 | 0.0615241954384181 |
91 | 0.930631177696469 | 0.138737644607062 | 0.0693688223035308 |
92 | 0.954772078472272 | 0.0904558430554558 | 0.0452279215277279 |
93 | 0.94515126031908 | 0.109697479361840 | 0.0548487396809199 |
94 | 0.943430756043238 | 0.113138487913524 | 0.056569243956762 |
95 | 0.932003167323058 | 0.135993665353884 | 0.067996832676942 |
96 | 0.919702800854297 | 0.160594398291405 | 0.0802971991457026 |
97 | 0.912761396376892 | 0.174477207246215 | 0.0872386036231077 |
98 | 0.894459962283811 | 0.211080075432378 | 0.105540037716189 |
99 | 0.878928225372388 | 0.242143549255224 | 0.121071774627612 |
100 | 0.853022706717131 | 0.293954586565737 | 0.146977293282869 |
101 | 0.822265889314234 | 0.355468221371531 | 0.177734110685766 |
102 | 0.795713023220719 | 0.408573953558562 | 0.204286976779281 |
103 | 0.808179866772119 | 0.383640266455763 | 0.191820133227881 |
104 | 0.864435874821128 | 0.271128250357745 | 0.135564125178872 |
105 | 0.861859391898908 | 0.276281216202184 | 0.138140608101092 |
106 | 0.829887256031704 | 0.340225487936593 | 0.170112743968296 |
107 | 0.797467852063355 | 0.40506429587329 | 0.202532147936645 |
108 | 0.783656372757128 | 0.432687254485745 | 0.216343627242872 |
109 | 0.764854625535924 | 0.470290748928153 | 0.235145374464076 |
110 | 0.784143309068946 | 0.431713381862108 | 0.215856690931054 |
111 | 0.769045385873406 | 0.461909228253187 | 0.230954614126594 |
112 | 0.834324256100616 | 0.331351487798769 | 0.165675743899384 |
113 | 0.797250203792304 | 0.405499592415392 | 0.202749796207696 |
114 | 0.766332162739473 | 0.467335674521053 | 0.233667837260527 |
115 | 0.722976130244069 | 0.554047739511862 | 0.277023869755931 |
116 | 0.73217013175785 | 0.535659736484299 | 0.267829868242150 |
117 | 0.744374822732677 | 0.511250354534647 | 0.255625177267323 |
118 | 0.725622971067391 | 0.548754057865218 | 0.274377028932609 |
119 | 0.67537991833969 | 0.64924016332062 | 0.32462008166031 |
120 | 0.77131854741068 | 0.457362905178641 | 0.228681452589320 |
121 | 0.740958354445508 | 0.518083291108985 | 0.259041645554492 |
122 | 0.688252418566369 | 0.623495162867262 | 0.311747581433631 |
123 | 0.674328362110953 | 0.651343275778093 | 0.325671637889046 |
124 | 0.631483536872456 | 0.737032926255088 | 0.368516463127544 |
125 | 0.612176877947887 | 0.775646244104226 | 0.387823122052113 |
126 | 0.612552819280793 | 0.774894361438414 | 0.387447180719207 |
127 | 0.54603567075918 | 0.90792865848164 | 0.45396432924082 |
128 | 0.50487872917079 | 0.99024254165842 | 0.49512127082921 |
129 | 0.482994137738118 | 0.965988275476237 | 0.517005862261882 |
130 | 0.465009250028874 | 0.930018500057748 | 0.534990749971126 |
131 | 0.392923101575466 | 0.785846203150932 | 0.607076898424534 |
132 | 0.371462252534147 | 0.742924505068294 | 0.628537747465853 |
133 | 0.325667334331613 | 0.651334668663226 | 0.674332665668387 |
134 | 0.281323824371727 | 0.562647648743455 | 0.718676175628273 |
135 | 0.237546151569608 | 0.475092303139215 | 0.762453848430392 |
136 | 0.219069151340992 | 0.438138302681984 | 0.780930848659008 |
137 | 0.184306688933709 | 0.368613377867419 | 0.81569331106629 |
138 | 0.197580908202362 | 0.395161816404724 | 0.802419091797638 |
139 | 0.616069745068915 | 0.76786050986217 | 0.383930254931085 |
140 | 0.526150517910436 | 0.947698964179127 | 0.473849482089564 |
141 | 0.405569862606172 | 0.811139725212344 | 0.594430137393828 |
142 | 0.400851681624013 | 0.801703363248025 | 0.599148318375987 |
143 | 0.278089005617193 | 0.556178011234387 | 0.721910994382807 |
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 | 29 | 0.221374045801527 | NOK |
10% type I error level | 48 | 0.366412213740458 | NOK |