The annual returns of three shares of stock during the last seven years are presented in the following table:REQUIRED:Determine the average return and the standard deviation of returns for each stock. The formula for the average is AVERAGE(X1:Y5) and for the standard deviation is STDEVP(X1:Y5)Which stock has the highest expected return and which one has the highest risk in terms of volatility?
The annual returns of three shares of stock during the last seven years are presented in the following table:
REQUIRED: Determine the average return and the standard deviation of returns for each stock. The formula for the average is AVERAGE(X1:Y5) and for the standard deviation is STDEVP(X1:Y5) Which stock has the highest expected return and which one has the highest risk in terms of volatility?
Worksheet:
Attachments: