Question

Homework 4 (Makeup for Oct 22 and 24) i Saved Help Save Sign In FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW AA Calibri 11 Alignment Number Conditional Format as Cell Formatting Table Styles BI U Cells Paste Editing Clipboard Font Styles Al 10 points A B C. D E F G Н K 1 2. eBook You've observed the following returns on Crash-n-Burn Computer's stock over the past five years. What is the arithmetic average return? The variance? The standard deviation? 3 4 5 References Year Returns 7% 1 7 -13% 2 8 21% 3 9 4 34% 10 15% 5 12. 13 Complete the following analysis. Do not hard code values in your calculations. Make sure to use the "sample" Excel formulas in your calculations. You must use the built-in Excel functions to answer this question 14 15 Arithmetic average return 16 17 Variance 18 19 Sheet1 100% READY +

Answer 1

A B D 1 2 Year Return 7% -13% 2 9 21% 10 34% 4 11 15% 5 12 Arithmetic average return 13 12.80% 14 Variance 0.03052 15

A В C 1 2 3 4 5 6 Year Return 7 0.07 1 8 2 -0.13 9 0.21 3 10 0.34 4 11 5 0.15 12 =AVERAGE (C7:C11) Arithmetic average return 13 =VAR.S(C7:C11) 14 Variance 15 16 17 18 Ln st Lr LC CC