Question

You have watched the following returns on Crash-n-Burn Computer’s stock over the past five years: 16 percent, –5 percent, 19 percent, 13 percent, and 10 percent.

a.	What was the arithmetic average return on the company’s stock over this five-year period? (Do not round intermediate calculations and enter your answer as a percent rounded to 1 decimal place, e.g., 32.1.)
b-1.	What was the variance of the company’s returns over this period? (Do not round intermediate calculations and round your answer to 5 decimal places, e.g., .16161.)
b-2.	What was the standard deviation of the company’s returns over this period? (Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.)

a.	Average Variance	10.6%
b-1.	Variance	?
b-2.	Standard Deviation	? %

Answer 1

Please refer to below spreadsheet for calculation and answer. Cell reference also provided.

Cell reference -

Hope this will help, please do comment if you need any further explanation. Your feedback would be appreciated.