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: