Given the following historical returns, what is the variance? Year 1 = 9%; year 2 = -11%; year 3 = 8%; year 4 = -12%; and year 5 = -9%. the correct answer is  .0112. How was that found? Please do not answer in excel format

Please include excel formula   Using the following returns, calculate the arithmetic average returns, the variances, and the standard deviations for X and Y.                     Input area:                               Year X Y           1 13% 27%           2 26% 36%           3 7% 11%           4 -5% -29%           5 11% 16%                           (Use cells A6 to C11 from the given information to complete this question. You must use the built-in Excel function to answers this question. Make sure to use the “sample” Excel formulas.)                 Output area:                               Asset X:               Average return                 Variance                 Standard deviation                 Asset Y:               Average return                 Variance                 Standard deviation

instructure.com/courses/1649755/assignments/8791881 Q Search ! 1 4. Using the following returns, calculate the arithmetic average returns, the variances, and the standard deviations for X and Y. Q A N Year 1 2 3 4 5 @ 2 a. Calculate the average return for X. b. Calculate the average return for Y. c. Calculate the variance for X. d. Calculate the variance for Y. e. Calculate the standard deviation for X. f. Calculate the standard deviation for Y. W S X Returns Alt X 13% 31 20 -21 22 # 3 E D F3 Y 24% 45 -11 -25 53 C $ 4 R F4 F V DII % 5 FS T G * A 6 B F6 Y H * F7 & 7 N U A PrtScn J FB * 8 JO Home M K F9 ( 9 End O F10 ) L 0 PgUPF11 P Alt .... PgDn F12 ? x { :[ B ( } 9:41 AM 11/27/2023 Ins A Del Backsp

Using the following returns, calculate the arithmetic average returns, the variances, and the standard deviations for X and Y. Year X Y 1 15% 21% 2 26 36 3 7 13 4 -13 -26 5 11 15