1. Calculate the arithmetic average return, the variance and the standard deviation Calculating Returns and Variability Excel Sign In HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEWVIEW FILE Calibri 11A A B I U A Alignment Number Conditional Format as CellCells Editing Paste Formatting. Table" Styles Styles Font Clipboard r A1 You've observed the following returns 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 returns over this period? The standard deviation? 4 Complete the following analysis. Do not hard code values in your calculations. Actual etu Squared Deviation Deviation Year 0.07 (0.13) 0.21 0.34 0.15 10 4 12 13 14 15 16 Sum - Squared deviation total 4 Complete the following analysis. Do not hard code values in your calculations. Squared Deviatio Deviation Actual ar 0.07 (0.13) 0.21 0.34 0.15 10 4 12 13 14 15 16 17 18 19 20 21 Sum- Squared deviation total Average return Variance- Standard Deviation 23 24