Answer:
1. the arithmetic average quarterly return = 8.79%
2. the standard deviation of quarterly returns = 17.8788%
3. the Sharpe ratio of Samsung stock for the next quarter= 0.435593
Step-by-step explanation:
From the given question;
We use the EXCEL SOFTWARE TO CALCULATE THE:
the arithmetic average quarterly return
the standard deviation of quarterly returns &
the Sharpe ratio of Samsung stock for the next quarter
In the two diagram attached below, the first show the data entry and the output and the second diagram show how we compute the cell reference to estimate the answers.