S10.00 points Problem 12-9 Calculating Returns and Variability Calculate the arithmetic average retum, the variance and the standard deviation. Caloulating Retuns and Variability-Excel HOME INSERT PAGE LAYOUT FORMULASDATA REVIEW VIEW Sign In Conditi Formatting , as Cel Table Styles . Al You've observed the following returns on Crash-n-Burn Computer's stock over the past ive years: 7 percent,-13 percent, 21 percent, 34 percent, and 15 percent. What was the arithmetic average returm on the stock over this five-year period? What was the variance of the retums over this period? The standard deviation? Complete the following analysis. Do not hard code values in your calculations Deviation Deviation 0.07 (0.13) 0.21 0.34 10 2 4 Calculating Rehums and Varlability-Exce HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIE Calibr Sign In 1 u . iH.? .. Alignment Number Condro al Format asal Cels Formatting" Table Styles Eating A1 A B H I You've observed the following retuns on Crash-n-Burn Computer's stock over the past five years: 7 percent,-13 percent, 21 percent, 34 percent, and 15 percent. What was the arithmetic average return on the stock over this five-year period? What was the variance of the returms over this period? The standard deviation? Complete the following analysis. Do not hard code values in your calculations. Year Deviation Deviation 800 (0.13 0.21 0.34 0.15 12 13 14 15 16 Sum Squared deviation total Average return Variance Sheeti READY 4 oW ERTY U