Homework SourseThe past five monthly returns for PGE are 319 percent 393 pe
The past five monthly returns for PG&E are ?3.19 percent, 3.93 percent, 3.79 percent, 6.50 percent, and 3.60 percent. Compute the standard deviation of PG&E’s monthly returns. (Do not round intermediate calculations and round your final answer to 2 decimal places.)
Solution
Use Stdev.s function in Excel
standard dev = 3.62%
| -3.19% | |
| 3.93% | |
| 3.79% | |
| 6.50% | |
| 3.60% | |
| average | 2.93% |
| std dev | 3.62% |
