The last four years of returns for a stock are as shown here: -3.8%, 27.6%, 11.7%,3.8%
a. What is the average annual return?
b. What is the variance of the stock's returns?
c. What is the standard deviation of the stock's returns?
Note: Notice that the average return and standard deviation must be entered in percentage format. The variance must be entered in decimal format.
Ans:- we will use the excel functions to find the average annual return, Variance, Standard deviation.
Note:- If this answer helps you pls give thumbs up.
Get Answers For Free
Most questions answered within 1 hours.