finance project
Bfh
Investmentanalysis1.xlsxCORRELATION ANALYSIS
| Column 1 | Column 2 | Column 3 | |
| Column 1 | 1 | ||
| Column 2 | 0.4777454386 | 1 | |
| Column 3 | 0.1132111976 | 0.5262512489 | 1 |
DATA ANALYSIS
| Date | MSFT | NFLX | SP500 | RSP500 | RMSFT | RNFLX | |
| 11/1/18 | 105.777542 | 286.130005 | 2723.23 | ||||
| 12/1/18 | 97.305817 | 267.660004 | 2567.31 | -5.73% | -8.01% | -6.46% | |
| 1/1/19 | 100.045731 | 339.5 | 2607.39 | 1.56% | 2.82% | 26.84% | |
| 2/1/19 | 107.326653 | 358.100006 | 2754.86 | 5.66% | 7.28% | 5.48% | |
| 3/1/19 | 113.471092 | 356.559998 | 2803.98 | 1.78% | 5.72% | -0.43% | |
| 4/1/19 | 125.651398 | 370.540009 | 2903.80 | 3.56% | 10.73% | 3.92% | |
| 5/1/19 | 118.993576 | 343.279999 | 2854.71 | -1.69% | -5.30% | -7.36% | |
| 6/1/19 | 129.361145 | 367.320007 | 2890.17 | 1.24% | 8.71% | 7.00% | |
| 7/1/19 | 131.591843 | 322.98999 | 2996.11 | 3.67% | 1.72% | -12.07% | |
| 8/1/19 | 133.127243 | 293.75 | 2897.50 | -3.29% | 1.17% | -9.05% | |
| 9/1/19 | 134.704147 | 267.619995 | 2982.16 | 2.92% | 1.18% | -8.90% | |
| 10/1/19 | 138.909134 | 287.410004 | 2977.68 | -0.15% | 3.12% | 7.39% | |
| 11/1/19 | 146.669891 | 314.660004 | 3104.90 | 4.27% | 5.59% | 9.48% | |
| 12/1/19 | 153.313156 | 323.570007 | 3176.75 | 2.31% | 4.53% | 2.83% | |
| 1/1/20 | 165.494598 | 345.089996 | 3278.20 | 3.19% | 7.95% | 6.65% | |
| 2/1/20 | 157.503296 | 369.029999 | 3277.31 | -0.03% | -4.83% | 6.94% | |
| 3/1/20 | 153.741684 | 375.5 | 2652.39 | -19.07% | -2.39% | 1.75% | |
| 4/1/20 | 174.700668 | 419.850006 | 2761.98 | 4.13% | 13.63% | 11.81% | |
| 5/1/20 | 178.639038 | 419.730011 | 2919.62 | 5.71% | 2.25% | -0.03% | |
| 6/1/20 | 198.941757 | 455.040009 | 3104.66 | 6.34% | 11.37% | 8.41% | |
| 7/1/20 | 200.408096 | 488.880005 | 3207.62 | 3.32% | 0.74% | 7.44% | |
| 8/1/20 | 220.467529 | 529.559998 | 3391.71 | 5.74% | 10.01% | 8.32% | |
| 9/1/20 | 206.105713 | 500.029999 | 3365.52 | -0.77% | -6.51% | -5.58% | |
| 10/1/20 | 198.403610 | 475.73999 | 3418.70 | 1.58% | -3.74% | -4.86% | |
| 11/1/20 | 209.770584 | 490.700012 | 3548.99 | 3.81% | 5.73% | 3.14% | |
| 12/1/20 | 218.523483 | 540.72998 | 3695.31 | 4.12% | 4.17% | 10.20% | |
| 1/1/21 | 227.896393 | 532.390015 | 3793.75 | 2.66% | 4.29% | -1.54% | |
| 2/1/21 | 228.309021 | 538.849976 | 3883.43 | 2.36% | 0.18% | 1.21% | |
| 3/1/21 | 232.173141 | 521.659973 | 3910.51 | 0.70% | 1.69% | -3.19% | |
| 4/1/21 | 248.332779 | 513.469971 | 4141.18 | 5.90% | 6.96% | -1.57% | |
| 5/1/21 | 245.870911 | 502.809998 | 4167.85 | 0.64% | -0.99% | -2.08% | |
| 6/1/21 | 267.383179 | 528.210022 | 4238.49 | 1.69% | 8.75% | 5.05% | |
| 7/1/21 | 281.211304 | 517.570007 | 4363.71 | 2.95% | 5.17% | -2.01% | |
| 8/1/21 | 297.961060 | 569.190002 | 4454.21 | 2.07% | 5.96% | 9.97% | |
| 9/1/21 | 278.792816 | 610.340027 | 4445.54 | -0.19% | -6.43% | 7.23% | |
| 10/1/21 | 327.941528 | 690.309998 | 4460.71 | 0.34% | 17.63% | 13.10% | |
| 11/1/21 | 326.922943 | 641.900024 | 4667.39 | 4.63% | -0.31% | -7.01% | |
| 12/1/21 | 333.197906 | 602.440002 | 4674.77 | 0.16% | 1.92% | -6.15% | |
| 1/1/22 | 308.093109 | 427.140015 | 4573.82 | -2.16% | -7.53% | -29.10% | |
| 2/1/22 | 296.016296 | 394.519989 | 4435.98 | -3.01% | -3.92% | -7.64% | |
| 3/1/22 | 306.079468 | 374.589996 | 4391.27 | -1.01% | 3.40% | -5.05% | |
| 4/1/22 | 275.512238 | 190.360001 | 4391.30 | 0.00% | -9.99% | -49.18% | |
| 5/1/22 | 269.903137 | 197.440002 | 4040.36 | -7.99% | -2.04% | 3.72% | |
| 6/1/22 | 255.565750 | 174.869995 | 3898.95 | -3.50% | -5.31% | -11.43% | |
| 7/1/22 | 279.358093 | 224.899994 | 3911.73 | 0.33% | 9.31% | 28.61% | |
| 8/1/22 | 260.182922 | 223.559998 | 4158.56 | 6.31% | -6.86% | -0.60% | |
| 9/1/22 | 232.245483 | 235.440002 | 3850.52 | -7.41% | -10.74% | 5.31% | |
| 10/1/22 | 231.477661 | 291.880005 | 3726.05 | -3.23% | -0.33% | 23.97% | |
| AVERAGE | 0.78% | 1.88% | 0.95% | ||||
| STDEV | 4.52% | 6.47% | 12.60% | ||||
| CORRELATION | 0.4777454386 | 0.1132111976 | |||||
| SLOPE | 0.6842265686 | 1.0242729769 | |||||
| W | 0.0225808097 |
STOCK ANALYSIS
MSFT 43405 43435 43466 43497 43525 43556 43586 43617 43647 43678 43709 43739 43770 43800 43831 43862 43891 43922 43952 43983 44013 44044 44075 44105 44136 44166 44197 44228 44256 44287 44317 44348 44378 44409 44440 44470 44501 44531 44562 44593 44621 44652 44682 44713 44743 44774 44805 44835 105.777542 97.305817000000005 100.045731 107.32665299999999 113.471092 125.651398 118.993576 129.36114499999999 131.59184300000001 133.12724299999999 134.70414700000001 138.90913399999999 146.66989100000001 153.31315599999999 165.494598 157.50329600000001 153.74168399999999 174.70066800000001 178.639038 198.941757 200.408096 220.46752900000001 206.10571300000001 198.40360999999999 209.77058400000001 218.523483 227.89639299999999 228.309021 232.17314099999999 248.33277899999999 245.87091100000001 267.38317899999998 281.21130399999998 297.96105999999997 278.79281600000002 327.94152800000001 326.92294299999998 333.19790599999999 308.09310900000003 296.01629600000001 306.07946800000002 275.51223800000002 269.90313700000002 255.56575000000001 279.358093 260.18292200000002 232.24548300000001 231.47766100000001 NFLX 43405 43435 43466 43497 43525 43556 43586 43617 43647 43678 43709 43739 43770 43800 43831 43862 43891 43922 43952 43 983 44013 44044 44075 44105 44136 44166 44197 44228 44256 44287 44317 44348 44378 44409 44440 44470 44501 44531 44562 44593 44621 44652 44682 44713 44743 44774 44805 44835 286.13000499999998 267.66000400000001 339.5 358.10000600000001 356.55999800000001 370.540009 343.27999899999998 367.32000699999998 322.98998999999998 293.75 267.61999500000002 287.41000400000001 314.66000400000001 323.57000699999998 345.08999599999999 369.02999899999998 375.5 419.85000600000001 419.73001099999999 455.040009 488.88000499999998 529.55999799999995 500.02999899999998 475.73998999999998 490.70001200000002 540.72997999999995 532.39001499999995 538.84997599999997 521.65997300000004 513.46997099999999 502.80999800000001 528.21002199999998 517.57000700000003 569.19000200000005 610.34002699999996 690.30999799999995 641.90002400000003 602.44000200000005 427.14001500000001 394.51998900000001 374.58999599999999 190.36000100000001 197.44000199999999 174.86999499999999 224.89999399999999 223.55999800000001 235.44000199999999 291.88000499999998 SP500 43405 43435 43466 43497 43525 43556 43586 43617 43647 43678 43709 43739 43770 43800 43831 43862 43891 43922 43952 43983 44013 44044 44075 44105 44136 44166 44197 44228 44256 44287 44317 44348 44378 44409 44440 44470 44501 44531 44562 44593 44621 44652 44682 44713 44743 44774 44805 44835 2723.2295238095239 2567.3073684210526 2607.39 2754.8642105263157 2803.9838095238097 2903.8 2854.7059090909092 2890.1660000000002 2996.1136363636365 2897.4981818181818 2982.1559999999999 2977.6752173913042 3104.9045000000001 3176.7495238095239 3278.2028571428573 3277.3142105263159 2652.3936363636362 2761.9752380952382 2919.6149999999998 3104.6609090909092 3207.619090909091 3391.71 3365.5166666666669 3418.7013636363636 3548.9924999999998 3695.31 3793.7484210526318 3883.4321052631581 3910.5082608695652 4141.1761904761906 4167.8495000000003 4238.4895454545458 4363.7128571428575 4454.2063636363637 4445.5433333333331 4460.7071428571426 4667.3866666666663 46 74.772727272727 4573.8154999999997 4435.9805263157896 4391.2652173913048 4391.2960000000003 4040.36 3898.9466666666667 3911.7294999999999 4158.5630434782606 3850.5204761904761 3726.0509523809524
