Question: Calculate the average return, variance, and standard deviation by using the stock return information provided to you. APPLE INC Value-Weighted Return-incl. dividends Equal-Weighted Return-incl. dividends
- Calculate the average return, variance, and standard deviation by using the stock return information provided to you.
| APPLE INC | Value-Weighted Return-incl. dividends | Equal-Weighted Return-incl. dividends | Return on the S&P 500 Index | Risk-free rate | ||
| Tech | 3% | |||||
| Date | AAPL | |||||
| 20130131 | -0.144094 | 0.054098 | 0.063509 | 0.050428 | ||
| 20130228 | -0.025116 | 0.008338 | 0.0035 | 0.011061 | ||
| 20130328 | 0.002855 | 0.035268 | 0.031419 | 0.035988 | ||
| 20130430 | 0.000271 | 0.014943 | 0.002477 | 0.018086 | ||
| 20130531 | 0.022596 | 0.019047 | 0.023985 | 0.020763 | ||
| 20130628 | -0.118303 | -0.015036 | -0.013012 | -0.014999 | ||
| 20130731 | 0.141225 | 0.052685 | 0.054898 | 0.049462 | ||
| 20130830 | 0.083389 | -0.025716 | -0.017278 | -0.031298 | ||
| 20130930 | -0.021481 | 0.037454 | 0.051828 | 0.029749 | ||
| 20131031 | 0.096386 | 0.039876 | 0.025762 | 0.044596 | ||
| 20131129 | 0.069673 | 0.02495 | 0.023398 | 0.028049 | ||
| 20131231 | 0.008902 | 0.02612 | 0.025242 | 0.023563 | ||
| 20140131 | -0.107697 | -0.02996 | -0.001282 | -0.035583 | ||
| 20140228 | 0.057311 | 0.046159 | 0.044257 | 0.043117 | ||
| 20140331 | 0.019953 | 0.004497 | 0.001028 | 0.006932 | ||
| 20140430 | 0.099396 | 0.001674 | -0.022319 | 0.006201 | ||
| 20140530 | 0.078293 | 0.020216 | 0.006647 | 0.02103 | ||
| 20140630 | 0.027662 | 0.027944 | 0.039501 | 0.019058 | ||
| 20140731 | 0.028731 | -0.020524 | -0.035223 | -0.01508 | ||
| 20140829 | 0.077092 | 0.040186 | 0.033697 | 0.037655 | ||
| 20140930 | -0.017073 | -0.025119 | -0.044988 | -0.015514 | ||
| 20141031 | 0.07196 | 0.021188 | 0.014199 | 0.023201 | ||
| 20141128 | 0.105556 | 0.021149 | -0.002457 | 0.024534 | ||
| 20141231 | -0.071891 | -0.00362 | -0.00019 | -0.004189 | ||
| 20150130 | 0.061424 | -0.027158 | -0.019073 | -0.031041 | ||
| 20150227 | 0.100461 | 0.055957 | 0.054123 | 0.054893 | ||
| 20150331 | -0.031372 | -0.010441 | -0.005112 | -0.017396 | ||
| 20150430 | 0.005786 | 0.008705 | 0.015127 | 0.008521 | ||
| 20150529 | 0.045146 | 0.010331 | 0.003962 | 0.010491 | ||
| 20150630 | -0.037266 | -0.019255 | -0.013473 | -0.021012 | ||
| 20150731 | -0.032888 | 0.012111 | -0.027144 | 0.019742 | ||
| 20150831 | -0.066117 | -0.059998 | -0.047295 | -0.062581 | ||
| 20150930 | -0.021816 | -0.033732 | -0.049922 | -0.026443 | ||
| 20151030 | 0.083409 | 0.073953 | 0.052873 | 0.082983 | ||
| 20151130 | -0.00569 | 0.002443 | 0.007333 | 0.000505 | ||
| 20151231 | -0.110228 | -0.022269 | -0.035887 | -0.01753 | ||
| 20160129 | -0.075242 | -0.057031 | -0.074951 | -0.050735 | ||
| 20160229 | -0.001335 | 0.000692 | 0.005557 | -0.004128 | ||
| 20160331 | 0.127211 | 0.070455 | 0.078191 | 0.065991 | ||
| 20160429 | -0.139921 | 0.011806 | 0.039834 | 0.002699 | ||
| 20160531 | 0.071368 | 0.014301 | -0.000617 | 0.015329 | ||
| 20160630 | -0.04266 | 0.003128 | 0.005839 | 0.000906 | ||
| 20160729 | 0.090063 | 0.038741 | 0.049867 | 0.03561 | ||
| 20160831 | 0.023606 | 0.002783 | 0.013067 | -0.001219 | ||
| 20160930 | 0.065504 | 0.003014 | 0.015373 | -0.001234 | ||
| 20161031 | 0.004334 | -0.021582 | -0.039941 | -0.019426 | ||
| 20161130 | -0.021578 | 0.040421 | 0.050505 | 0.034174 | ||
| 20161230 | 0.047955 | 0.018777 | 0.015889 | 0.018201 | ||
| 20170131 | 0.047746 | 0.02217 | 0.025931 | 0.017884 | ||
| 20170228 | 0.133581 | 0.032639 | 0.01713 | 0.037198 | ||
| 20170331 | 0.04869 | 0.002089 | 0.00639 | -0.000389 | ||
| 20170428 | -0.00007 | 0.009613 | 0.003684 | 0.009091 | ||
| 20170531 | 0.067804 | 0.009333 | -0.011327 | 0.011576 | ||
| 20170630 | -0.057214 | 0.00946 | 0.022916 | 0.004814 | ||
| 20170731 | 0.032704 | 0.020313 | 0.00911 | 0.019349 | ||
| 20170831 | 0.106905 | 0.001596 | -0.008749 | 0.000546 | ||
| 20170929 | -0.060244 | 0.023705 | 0.046757 | 0.019303 | ||
| 20171031 | 0.096808 | 0.019262 | 0.002211 | 0.022188 | ||
| 20171130 | 0.02035 | 0.02728 | 0.020836 | 0.028083 | ||
| 20171229 | -0.015246 | 0.012166 | 0.014222 | 0.009832 | ||
| Average return | ||||||
| Variance | ||||||
| Standard deviation |
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
