Question

Homework 4 (Makeup for Oct 22 and 24) Saved Help Save FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign In Arial - - 12 - R A - Paste B I U . Alignment Number Cells Editing Conditional Format as Cell Formatting Table Styles Styles Clipboard Font D11 Joints D E F G H I eBook Using the following returns, calculate the arithmetic average returns, the variances, and the standard deviations for X and Y. References Year х 15% 26% 7% mo 21% 36% 13% -26% 15% 5 -13% 11% 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. Arithmetic average return Variance Standard Deviation Sheet1 ... + READY

Answer 1

Year 2 SEGUE BEHOV AWNH X 15% 26% 7% -13% 11% Y 21% 36% 13% -26% 15% Arithmetic average return Variance Stancard deviation 9.20% 0.02042 14.29% 11.80% 0.05277 22.97%

Year 0.21 0.36 0.15 0.26 0.07 -0.13 0.11 0.13 -0.26 0.15 Arithmetic average return Variance Stancard deviation =AVERAGE(C7:C11) =AVERAGE(D7:011) =VAR.S(C7:011) EVAR.S(D7:011) ESTDEV.S(07:011) ESTDEV.S(D7:011) 18