Qw.4. Excel McGraw Hill Excel Question - SavedFileA112345677891011.12You've observed the following returns on Pine Computer's stock overthe past five years: 8 percent, -12 percent, 14 percent, 21 percent,and 16 percent. What was the arithmetic average return on thecompany's stock over this five-year period? What was the variance2 the company's returns over this period? The standard deviation?5 6 7 8 9 20 21 22Home Insert Draw Formulas15Input area:17Year123416 Output area:19 Variance18 Average returnCalibri20 Standard deviationData ReviewReturnsB 田くAv固く Generalfx Accessibility tab summary: Students please use the information below to complete the question compBCDEFGH1K8%-12%14%21%16%13 (Use cells A6 to 811 from the given information to complete this question. You must use the built-in Excel14 function to answers this question. Make sure to use the "sample" Excel formulas.)Search (Option+Q)ViewHelp...J

The mean return that any investment earns over time is recognized as average return of the stock or…

You've observed the following returns on Pine Computer's stock over the past five years: 8 percent, -12 percent, 14 percent, 21 percent, and 16 percent. What was the arithmetic average return on the company's stock over this five-year period? What was the variance 2 the company's returns over this period? The standard deviation? 3 4 Input area: 5 6 7 В 9 10 11 12 Year 1 2 3 4 17 18 Average return 19 Variance Returns 20 Standard deviation 21 8% -12% 14% 13 (Use cells A6 to 811 from the given information to complete this question. You must use the built-in Excel 14 function to answers this question. Make sure to use the "sample" Excel formulas.) 15 16 Output area: 21% 16%