amzn.xlsx
table-5
| Date | AMZN | SP500 | Return |
| 1/2/15 | 354.529999 | 1994.98999 | AMZN | SP500 | | SUMMARY OUTPUT |
| 2/2/15 | 380.160004 | 2104.5 | 0.0697992615 | 0.0534388764 |
| 3/2/15 | 372.100006 | 2067.889893 | -0.0214295758 | -0.0175491972 | | Regression Statistics |
| 4/1/15 | 421.779999 | 2085.51001 | 0.1253211972 | 0.0084847225 | | Multiple R | 0.7232727468 |
| 5/1/15 | 429.230011 | 2107.389893 | 0.0175090827 | 0.0104367298 | | R Square | 0.5231234662 |
| 6/1/15 | 434.089996 | 2063.110107 | 0.0112589452 | -0.0212355593 | | Adjusted R Square | 0.4890608566 |
| 7/1/15 | 536.150024 | 2103.840088 | 0.2111621408 | 0.0195496832 | | Standard Error | 0.0660919466 |
| 8/3/15 | 512.890015 | 1972.180054 | -0.044352591 | -0.0646247309 | | Observations | 16 |
| 9/1/15 | 511.890015 | 1920.030029 | -0.001951639 | -0.0267987313 |
| 10/1/15 | 625.900024 | 2079.360107 | 0.2010808648 | 0.0797193795 | | ANOVA |
| 11/2/15 | 664.799988 | 2080.409912 | 0.0602955732 | 0.0005047419 | | | df | SS | MS | F | Significance F |
| 12/1/15 | 675.890015 | 2043.939941 | 0.0165441376 | -0.0176856585 | | Regression | 1 | 0.067084683 | 0.067084683 | 15.3577037403 | 0.0015433129 |
| 1/4/16 | 587 | 1940.23999 | -0.1410055433 | -0.0520676172 | | Residual | 14 | 0.0611540356 | 0.0043681454 |
| 2/1/16 | 552.52002 | 1932.22998 | -0.0605351518 | -0.0041369056 | | Total | 15 | 0.1282387186 |
| 3/1/16 | 593.640015 | 2059.73999 | 0.0717834323 | 0.0639049904 |
| 4/1/16 | 659.590027 | 2065.300049 | 0.1053453705 | 0.0026957616 | | | Coefficients | Standard Error | t Stat | P-value | Lower 95% | Upper 95% | Lower 95.0% | Upper 95.0% |
| 5/2/16 | 717.929993 | 2064.110107 | 0.0847535907 | -0.0005763254 | | Intercept | 0.0404219187 | 0.0165496024 | 2.4424706763 | 0.0284528834 | 0.0049265517 | 0.0759172857 | 0.0049265517 | 0.0759172857 |
| | | | | | | SP500 | 1.7271908635 | 0.4407346436 | 3.9188906262 | 0.0015433129 | 0.781909067 | 2.67247266 | 0.781909067 | 2.67247266 |
| | | | | | | Yahoo | 1.64 |
onlyamor
