Multiple Linear Regression - Estimated Regression Equation |
FACEBOOK[t] = + 82.282919242259 + 0.431769223184462LINKEDIN[t] -0.0345547988011659NASDAQ[t] -761.520442009693INFLATION[t] + 0.134198894804541CONS.CONF[t] + 38.4397831371381FED.FUNDS.RATE[t] + 0.414752562361286M1[t] + 0.585660782608443M2[t] + 0.0982950525574734M3[t] + 0.330412872399994M4[t] + 0.158974668941033M5[t] + 0.0694178296759307M6[t] -0.18145426471401M7[t] -0.465781129463628M8[t] -0.876691418040543M9[t] -1.31408475815492M10[t] -0.831274393257356M11[t] -0.0451337480006446t + 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) | 82.282919242259 | 13.365071 | 6.1566 | 0 | 0 |
0.431769223184462 | 0.063152 | 6.837 | 0 | 0 | |
NASDAQ | -0.0345547988011659 | 0.005153 | -6.7062 | 0 | 0 |
INFLATION | -761.520442009693 | 141.233007 | -5.3919 | 0 | 0 |
CONS.CONF | 0.134198894804541 | 0.117043 | 1.1466 | 0.254089 | 0.127044 |
FED.FUNDS.RATE | 38.4397831371381 | 16.062802 | 2.3931 | 0.018433 | 0.009216 |
M1 | 0.414752562361286 | 0.944202 | 0.4393 | 0.661349 | 0.330674 |
M2 | 0.585660782608443 | 0.945797 | 0.6192 | 0.537072 | 0.268536 |
M3 | 0.0982950525574734 | 0.949788 | 0.1035 | 0.917765 | 0.458882 |
M4 | 0.330412872399994 | 0.949188 | 0.3481 | 0.728442 | 0.364221 |
M5 | 0.158974668941033 | 0.945237 | 0.1682 | 0.866752 | 0.433376 |
M6 | 0.0694178296759307 | 0.947654 | 0.0733 | 0.941741 | 0.47087 |
M7 | -0.18145426471401 | 0.982704 | -0.1846 | 0.853851 | 0.426926 |
M8 | -0.465781129463628 | 0.979446 | -0.4756 | 0.635351 | 0.317676 |
M9 | -0.876691418040543 | 0.968226 | -0.9055 | 0.367237 | 0.183618 |
M10 | -1.31408475815492 | 0.964027 | -1.3631 | 0.17568 | 0.08784 |
M11 | -0.831274393257356 | 0.959037 | -0.8668 | 0.387984 | 0.193992 |
t | -0.0451337480006446 | 0.013134 | -3.4365 | 0.000838 | 0.000419 |
Multiple Linear Regression - Regression Statistics | |
Multiple R | 0.895946244190784 |
R-squared | 0.802719672479571 |
Adjusted R-squared | 0.771666287592096 |
F-TEST (value) | 25.8496674481158 |
F-TEST (DF numerator) | 17 |
F-TEST (DF denominator) | 108 |
p-value | 0 |
Multiple Linear Regression - Residual Statistics | |
Residual Standard Deviation | 2.14072292871527 |
Sum Squared Residuals | 494.931023012948 |
Multiple Linear Regression - Actuals, Interpolation, and Residuals | |||
Time or Index | Actuals | Interpolation Forecast | Residuals Prediction Error |
1 | 27.72 | 29.6054299940344 | -1.88542999403444 |
2 | 26.9 | 29.5012875949361 | -2.60128759493606 |
3 | 25.86 | 29.1680254748657 | -3.30802547486566 |
4 | 26.81 | 26.7034581050453 | 0.10654189495474 |
5 | 26.31 | 27.4136445815053 | -1.10364458150531 |
6 | 27.1 | 27.6362187838419 | -0.536218783841898 |
7 | 27 | 28.1721007254067 | -1.17210072540669 |
8 | 27.4 | 26.3795860571955 | 1.02041394280447 |
9 | 27.27 | 27.6151432994732 | -0.345143299473246 |
10 | 28.29 | 27.7119882325907 | 0.578011767409308 |
11 | 30.01 | 28.8800306788267 | 1.12996932117334 |
12 | 31.41 | 29.8633269287528 | 1.54667307124722 |
13 | 31.91 | 29.1209424805625 | 2.78905751943752 |
14 | 31.6 | 28.8082524646419 | 2.7917475353581 |
15 | 31.84 | 29.7961320530047 | 2.04386794699529 |
16 | 33.05 | 30.8434492608433 | 2.20655073915667 |
17 | 32.06 | 30.9302072418364 | 1.12979275816364 |
18 | 33.1 | 31.24765020679 | 1.85234979320999 |
19 | 32.23 | 29.2928999815347 | 2.93710001846533 |
20 | 31.36 | 28.8067906094803 | 2.55320939051971 |
21 | 31.09 | 24.6119963570878 | 6.47800364291218 |
22 | 30.77 | 29.4263851060339 | 1.34361489396608 |
23 | 31.2 | 29.0138871344484 | 2.18611286555165 |
24 | 31.47 | 29.6691148207977 | 1.80088517920232 |
25 | 31.73 | 31.6468111990299 | 0.0831888009700907 |
26 | 32.17 | 29.4259073202863 | 2.74409267971373 |
27 | 31.47 | 28.4210972989546 | 3.04890270104542 |
28 | 30.97 | 29.7731850295291 | 1.1968149704709 |
29 | 30.81 | 32.231058409855 | -1.42105840985497 |
30 | 30.72 | 31.4299695226726 | -0.709969522672558 |
31 | 28.24 | 30.120371927909 | -1.880371927909 |
32 | 28.09 | 29.2258602300983 | -1.1358602300983 |
33 | 29.11 | 27.5927764150354 | 1.51722358496457 |
34 | 29 | 26.8962766824043 | 2.10372331759567 |
35 | 28.76 | 27.7049496872177 | 1.05505031278229 |
36 | 28.75 | 29.2006447419468 | -0.4506447419468 |
37 | 28.45 | 30.3707289630653 | -1.9207289630653 |
38 | 29.34 | 30.4534425462744 | -1.11344254627444 |
39 | 26.84 | 27.5970386998552 | -0.757038699855242 |
40 | 23.7 | 26.6660895977091 | -2.96608959770912 |
41 | 23.15 | 27.200958541184 | -4.05095854118399 |
42 | 21.71 | 26.239649539498 | -4.52964953949801 |
43 | 20.88 | 21.2861197324805 | -0.406119732480474 |
44 | 20.04 | 20.3977427738315 | -0.357742773831483 |
45 | 21.09 | 24.4095666307091 | -3.31956663070908 |
46 | 21.92 | 24.4790668594612 | -2.55906685946116 |
47 | 20.72 | 21.5415678836518 | -0.821567883651799 |
48 | 20.72 | 21.7227746263454 | -1.00277462634539 |
49 | 21.01 | 21.9665642445208 | -0.956564244520756 |
50 | 21.8 | 21.8817786042415 | -0.0817786042414891 |
51 | 21.6 | 21.1537520087609 | 0.446247991239088 |
52 | 20.38 | 20.3059450721174 | 0.0740549278826204 |
53 | 21.2 | 19.8102652122782 | 1.38973478772179 |
54 | 19.87 | 19.3483944875324 | 0.521605512467568 |
55 | 19.05 | 17.4261574451901 | 1.62384255480985 |
56 | 20.01 | 17.7833876441521 | 2.22661235584791 |
57 | 19.15 | 18.6426313468648 | 0.507368653135238 |
58 | 19.43 | 18.1372218410991 | 1.29277815890088 |
59 | 19.44 | 19.1501111549722 | 0.28988884502782 |
60 | 19.4 | 19.2360501886906 | 0.163949811309395 |
61 | 19.15 | 19.2982042289261 | -0.148204228926117 |
62 | 19.34 | 20.5137118397519 | -1.1737118397519 |
63 | 19.1 | 20.4846015691004 | -1.38460156910041 |
64 | 19.08 | 21.4745395035849 | -2.39453950358486 |
65 | 18.05 | 20.2127207970097 | -2.16272079700968 |
66 | 17.72 | 19.1359867436606 | -1.41598674366059 |
67 | 18.58 | 22.3606049580917 | -3.78060495809168 |
68 | 18.96 | 22.2447649120454 | -3.28476491204541 |
69 | 18.98 | 21.3573384634367 | -2.37733846343669 |
70 | 18.81 | 21.4589930197307 | -2.64899301973071 |
71 | 19.43 | 21.9222236115575 | -2.49222361155748 |
72 | 20.93 | 23.0828375427932 | -2.15283754279315 |
73 | 20.71 | 21.9831995730746 | -1.27319957307463 |
74 | 22 | 23.1451432135773 | -1.14514321357732 |
75 | 21.52 | 22.0049553947683 | -0.48495539476829 |
76 | 21.87 | 22.2349552182627 | -0.364955218262709 |
77 | 23.29 | 21.9337420662493 | 1.35625793375067 |
78 | 22.59 | 22.5301619606305 | 0.0598380393694708 |
79 | 22.86 | 21.737445245055 | 1.12255475494503 |
80 | 20.79 | 22.3946958134366 | -1.60469581343662 |
81 | 20.28 | 21.8285665167295 | -1.54856651672953 |
82 | 20.62 | 21.7447452433593 | -1.12474524335929 |
83 | 20.32 | 20.6263737782704 | -0.306373778270407 |
84 | 21.66 | 20.5355042045657 | 1.12449579543431 |
85 | 21.99 | 21.3238278289202 | 0.666172171079786 |
86 | 22.27 | 21.9674168475856 | 0.302583152414372 |
87 | 21.83 | 22.1664784152111 | -0.336478415211093 |
88 | 21.94 | 21.6068806356963 | 0.33311936430367 |
89 | 20.91 | 20.4887778112971 | 0.421222188702862 |
90 | 20.4 | 20.8065520955126 | -0.406552095512556 |
91 | 20.22 | 20.4147535181487 | -0.194753518148665 |
92 | 19.64 | 20.0721699882548 | -0.43216998825477 |
93 | 19.75 | 20.4708877343362 | -0.720887734336171 |
94 | 19.51 | 18.7207564899675 | 0.789243510032472 |
95 | 19.52 | 18.6548967531262 | 0.865103246873781 |
96 | 19.48 | 18.3053392343787 | 1.17466076562133 |
97 | 19.88 | 17.4287097280998 | 2.45129027190016 |
98 | 18.97 | 18.3968485901313 | 0.573151409868662 |
99 | 19 | 19.6442533329829 | -0.644253332982917 |
100 | 19.32 | 19.2967789200315 | 0.0232210799685173 |
101 | 19.5 | 18.6358360837717 | 0.864163916228283 |
102 | 23.22 | 21.0492919400378 | 2.17070805996218 |
103 | 22.56 | 19.4260183771471 | 3.13398162285287 |
104 | 21.94 | 18.5281524914649 | 3.41184750853509 |
105 | 21.11 | 20.2389423119576 | 0.871057688042369 |
106 | 21.21 | 20.9035755900013 | 0.306424409998696 |
107 | 21.18 | 22.2372940484321 | -1.05729404843215 |
108 | 21.25 | 23.0222892058999 | -1.77228920589989 |
109 | 21.17 | 21.2234497545678 | -0.0534497545677839 |
110 | 20.47 | 22.6633105854028 | -2.19331058540284 |
111 | 19.99 | 21.4736933406714 | -1.48369334067137 |
112 | 19.21 | 21.0244717987258 | -1.81447179872576 |
113 | 20.07 | 22.2883582488983 | -2.21835824889834 |
114 | 19.86 | 22.9698089112403 | -3.10980891124032 |
115 | 22.36 | 23.7435280890366 | -1.38352808903657 |
116 | 22.17 | 24.5668494800406 | -2.39684948004061 |
117 | 23.56 | 24.6221509243696 | -1.06215092436963 |
118 | 22.92 | 23.0009909353519 | -0.0809909353519383 |
119 | 23.1 | 23.948665269497 | -0.848665269497045 |
120 | 24.32 | 24.7521185058293 | -0.43211850582934 |
121 | 23.99 | 23.7421320051985 | 0.24786799480146 |
122 | 25.94 | 24.0429003931708 | 1.89709960682919 |
123 | 26.15 | 23.2899724118248 | 2.86002758817519 |
124 | 26.36 | 22.7602468584547 | 3.59975314154534 |
125 | 27.32 | 21.5244310061149 | 5.79556899388506 |
126 | 28 | 21.8963158085833 | 6.10368419141671 |
Goldfeld-Quandt test for Heteroskedasticity | |||
p-values | Alternative Hypothesis | ||
breakpoint index | greater | 2-sided | less |
21 | 0.073255582024188 | 0.146511164048376 | 0.926744417975812 |
22 | 0.0230756800430053 | 0.0461513600860107 | 0.976924319956995 |
23 | 0.00775657702204722 | 0.0155131540440944 | 0.992243422977953 |
24 | 0.00309793533689452 | 0.00619587067378903 | 0.996902064663105 |
25 | 0.00576602133451926 | 0.0115320426690385 | 0.994233978665481 |
26 | 0.00341494943751145 | 0.00682989887502291 | 0.996585050562489 |
27 | 0.00173597382839936 | 0.00347194765679872 | 0.998264026171601 |
28 | 0.00175668347837859 | 0.00351336695675718 | 0.998243316521621 |
29 | 0.00144487032353552 | 0.00288974064707103 | 0.998555129676465 |
30 | 0.0017609167830241 | 0.0035218335660482 | 0.998239083216976 |
31 | 0.00962534285532597 | 0.0192506857106519 | 0.990374657144674 |
32 | 0.0236158184427291 | 0.0472316368854582 | 0.976384181557271 |
33 | 0.0209969279840446 | 0.0419938559680891 | 0.979003072015955 |
34 | 0.0660896160238632 | 0.132179232047726 | 0.933910383976137 |
35 | 0.093360496243757 | 0.186720992487514 | 0.906639503756243 |
36 | 0.0951416710396094 | 0.190283342079219 | 0.904858328960391 |
37 | 0.096125829772661 | 0.192251659545322 | 0.903874170227339 |
38 | 0.114279824938499 | 0.228559649876999 | 0.885720175061501 |
39 | 0.19879259642808 | 0.39758519285616 | 0.80120740357192 |
40 | 0.573168853489954 | 0.853662293020092 | 0.426831146510046 |
41 | 0.719275769367494 | 0.561448461265013 | 0.280724230632506 |
42 | 0.767871831043673 | 0.464256337912654 | 0.232128168956327 |
43 | 0.750572295292903 | 0.498855409414195 | 0.249427704707097 |
44 | 0.762248253101767 | 0.475503493796465 | 0.237751746898233 |
45 | 0.979973176710543 | 0.0400536465789131 | 0.0200268232894565 |
46 | 0.985093394030139 | 0.0298132119397228 | 0.0149066059698614 |
47 | 0.983350983181942 | 0.0332980336361157 | 0.0166490168180579 |
48 | 0.981386014270593 | 0.0372279714588131 | 0.0186139857294066 |
49 | 0.978636251687851 | 0.0427274966242979 | 0.021363748312149 |
50 | 0.983572201245251 | 0.0328555975094983 | 0.0164277987547491 |
51 | 0.990258522540515 | 0.0194829549189707 | 0.00974147745948534 |
52 | 0.995167106105916 | 0.00966578778816845 | 0.00483289389408423 |
53 | 0.999437007544333 | 0.00112598491133487 | 0.000562992455667434 |
54 | 0.999325622250822 | 0.00134875549835506 | 0.000674377749177532 |
55 | 0.998943743738871 | 0.00211251252225738 | 0.00105625626112869 |
56 | 0.999230248081879 | 0.00153950383624205 | 0.000769751918121025 |
57 | 0.999071685811364 | 0.00185662837727297 | 0.000928314188636484 |
58 | 0.999116945129854 | 0.0017661097402915 | 0.000883054870145749 |
59 | 0.999313118176673 | 0.00137376364665339 | 0.000686881823326697 |
60 | 0.999385208286591 | 0.0012295834268169 | 0.000614791713408449 |
61 | 0.999280289073828 | 0.00143942185234487 | 0.000719710926172437 |
62 | 0.999293392168541 | 0.00141321566291845 | 0.000706607831459224 |
63 | 0.999307870079247 | 0.00138425984150574 | 0.000692129920752872 |
64 | 0.999008516628168 | 0.00198296674366316 | 0.000991483371831582 |
65 | 0.999314159428757 | 0.00137168114248606 | 0.00068584057124303 |
66 | 0.999734567387187 | 0.000530865225626814 | 0.000265432612813407 |
67 | 0.999705298697299 | 0.000589402605401134 | 0.000294701302700567 |
68 | 0.999711397165477 | 0.000577205669046321 | 0.00028860283452316 |
69 | 0.999563683727977 | 0.000872632544045589 | 0.000436316272022794 |
70 | 0.999307653269067 | 0.00138469346186634 | 0.000692346730933169 |
71 | 0.999194687722783 | 0.00161062455443309 | 0.000805312277216545 |
72 | 0.999305172766788 | 0.00138965446642304 | 0.000694827233211522 |
73 | 0.999015297223637 | 0.00196940555272523 | 0.000984702776362613 |
74 | 0.99844108694511 | 0.00311782610978051 | 0.00155891305489025 |
75 | 0.997686564643516 | 0.00462687071296739 | 0.0023134353564837 |
76 | 0.997342507072223 | 0.00531498585555361 | 0.00265749292777681 |
77 | 0.998812102389753 | 0.00237579522049329 | 0.00118789761024664 |
78 | 0.998606019085317 | 0.0027879618293661 | 0.00139398091468305 |
79 | 0.997904289361281 | 0.00419142127743782 | 0.00209571063871891 |
80 | 0.997719865937211 | 0.004560268125579 | 0.0022801340627895 |
81 | 0.996930391207441 | 0.00613921758511885 | 0.00306960879255943 |
82 | 0.996554249027424 | 0.00689150194515257 | 0.00344575097257629 |
83 | 0.997364886726953 | 0.0052702265460939 | 0.00263511327304695 |
84 | 0.996103237490751 | 0.00779352501849761 | 0.0038967625092488 |
85 | 0.999575248393586 | 0.000849503212827826 | 0.000424751606413913 |
86 | 0.999919392710974 | 0.000161214578051655 | 8.06072890258276e-05 |
87 | 0.999861056202434 | 0.000277887595132382 | 0.000138943797566191 |
88 | 0.999874496027495 | 0.000251007945010163 | 0.000125503972505081 |
89 | 0.999838120499107 | 0.000323759001785753 | 0.000161879500892877 |
90 | 0.999685897078791 | 0.000628205842417618 | 0.000314102921208809 |
91 | 0.999538101156675 | 0.00092379768665101 | 0.000461898843325505 |
92 | 0.999303460346548 | 0.0013930793069038 | 0.0006965396534519 |
93 | 0.998947958276931 | 0.0021040834461383 | 0.00105204172306915 |
94 | 0.998365920366391 | 0.00326815926721836 | 0.00163407963360918 |
95 | 0.996899738282219 | 0.00620052343556296 | 0.00310026171778148 |
96 | 0.994380453889087 | 0.0112390922218257 | 0.00561954611091285 |
97 | 0.990953718119514 | 0.0180925637609721 | 0.00904628188048605 |
98 | 0.987533839002122 | 0.0249323219957563 | 0.0124661609978781 |
99 | 0.984810048133878 | 0.0303799037322449 | 0.0151899518661224 |
100 | 0.982943324142959 | 0.0341133517140827 | 0.0170566758570414 |
101 | 0.978758031686192 | 0.0424839366276165 | 0.0212419683138082 |
102 | 0.999993301416548 | 1.33971669031156e-05 | 6.69858345155778e-06 |
103 | 0.999971093923603 | 5.78121527940155e-05 | 2.89060763970078e-05 |
104 | 0.999838624602619 | 0.000322750794761292 | 0.000161375397380646 |
105 | 0.998183083004196 | 0.0036338339916088 | 0.0018169169958044 |
Meta Analysis of Goldfeld-Quandt test for Heteroskedasticity | |||
Description | # significant tests | % significant tests | OK/NOK |
1% type I error level | 54 | 0.635294117647059 | NOK |
5% type I error level | 73 | 0.858823529411765 | NOK |
10% type I error level | 73 | 0.858823529411765 | NOK |