Question: 1. What is the arverage arithmatic return, average geometric return, variance and stardard deviation for the following stock. What is the probability that your return
1. What is the arverage arithmatic return, average geometric return, variance and stardard deviation for the following stock. What is the probability that your return will be greater than 12 percent?
please post excel functions to explain how you got the answer.
Year 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 Retum 35% 13% 9% -12% 29% 16% 11% -9% 46% 21% -3% 7% 19% 7% 5% 24% 6% 17% -18% 16% 9% 15% 13% 6% -20% Year 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 Retum 35% 13% 9% -12% 29% 16% 11% -9% 46% 21% -3% 7% 19% 7% 5% 24% 6% 17% -18% 16% 9% 15% 13% 6% -20%
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
