In: Finance
Use the following returns for X and
Y.
| Returns | ||||||||||
| Year | X | Y | ||||||||
| 1 | 21.9 | % | 26.7 | % | ||||||
| 2 | – | 16.9 | –3.9 | |||||||
| 3 | 9.9 | 28.7 | ||||||||
| 4 | 19.8 | –14.8 | ||||||||
| 5 | 4.9 | 32.7 | ||||||||
Calculate the average returns for X and Y.
(Do not round intermediate calculations and enter your
answers as a percent rounded to 2 decimal places, e.g.,
32.16.)
| Average returns | ||
| X | % | |
| Y | % | |
Calculate the variances for X and Y. (Do
not round intermediate calculations and round your answers to 6
decimal places, e.g., 32.161616.)
| Variances | ||
| X | ||
| Y | ||
Calculate the standard deviations for X and Y. (Do not
round intermediate calculations and enter your answers as a percent
rounded to 2 decimal places, e.g., 32.16.)
| Standard deviations | ||
| X | % | |
| Y | % | |
rev: 04_07_2017_QC_CS-85233
The following are the data inputs in spreadsheet:

The following are the obtained results in spreadsheet:
