Question: PLEASE ANSWER IN EXCEL FORM WITH EXACT CELL FORMULAS USED TO SOLVE EACH OF THE YELLOW BOXES. You've observed the following returns on Crash-n-Burn Computer's
PLEASE ANSWER IN EXCEL FORM WITH EXACT CELL FORMULAS USED TO SOLVE EACH OF THE YELLOW BOXES.




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? . Year Returns 7% -13% 21% a A WN- 34% O 15% W N - 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. 5 16 Arithmetic average return 17 18 Variance 19 20 Standard Deviation 21 22 23 24 ... Sheet1 ... + READY 30 D - Attempt(s) 3/3 Step: Use the AVERAGE function to calculate the arithmetic average returns. Variance Standard Deviation ... sheet1 ... 4 # [ - + -+ READY Attempt(s) 3/3 Step: Use the VAR function to calculate the variance of returns. 100% Hint Standard Deviation ... Sheet1 ... + O D - + 100% READY 5 Attempt(s) 3/3 Step: Use the STDEV function to calculate the standard deviation of the returns. Hint
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
