Calculate the arithmetic average return, the variance and the standard deviation

Calculating Returns and Variability - Excel FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VEW Sign In 6 Calibri H Conditional Format as Cell Cells Editing Formatting" Table" Styles Paste AAlignment Number Clipboard r Font Styles 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 eturn Squared Deviation Deviation Year 0.07 10 0.21 0.34 0.15 12 13 14 15 16 17 18 19 Sum = Squared deviation total = Average return Variance = 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 12 13 14 15 16 17 18 19 20 21 Sum- Squared deviation total - Average return - Variance - Standard Deviation