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

  1. 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 blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!