•Assignment: •There’s a list of stock prices (BB attachment). Calculate Standard
ID: 1123402 • Letter: #
Question
•Assignment:
•There’s a list of stock prices (BB attachment). Calculate Standard Deviations to find out the riskier investments.
•Is it a risky portfolio?
28-12-12 STDEV.P Risky portfolio? FNJN US Equity GOOGL US Equity MSTR US Equity IBM US Equity FFIV US Equity VMW US Equily SINA US Equity SOHU US Equity PLPC US Equity CTXS US Equity TDC US Equity TIVO US Equity ULTI US Equity TECD US Equit 6.425 560.898 124.24 158.7374168.1425 167.8438 90.86 89.71 73.0901 72.93 68.8595 S0.3653 45.49 19.31 153.22 9 354.033 93.38 1.1327 792.45 197.4 163.0946 144.72 6497.05 182.95 37.99 13.47 19.72 11.95 12.82 11.68 8.20 17437.4986 323.263 108.32 530.66 162.4 147.0528 130.465 82.52 32.4546 53.18 52.1332 50.8033 43.68 22.154 146.815 63.23 778.01 179.29 130.256 96.96 56.57 42.8564 57.19 40.9853 60.2393 26.42 16.3384 195.51 66.38 106.12 83.19 45.112 97.15 94.14 43.5678 56.0956 33.89 57.6349 71.1166 27.17 20.4966 182.35 84.68 54.7555 48.3507 55.4574 S2.2525 61.89 15.1322 94.41 45.53 12.35 24.1056 65.12 49.41 46.15 13.24 Calculate Standard Deviations to find out the riskier investments POPULATION STANDARD DEVIATION 13-81Explanation / Answer
So the Standard deviation is a already calculated we need to figure out riskier portfolio. So lower the standard deviation the better the portfolio as it will be less risky. so lower is better as the deviation wont be high. so the lowest is TIVO US Equity which has the lowest standard deviation the best portfolio.
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.