PLEASE ANSWER IN EXCEL FORM WITH EXACT CELL FORMULAS USED TO SOLVE EACH OF THE YELLOW BOXES.

Suppose the returns below are normally distributed. Based on these values, what is the approximate probability that your return will be less than -2.1 percent in a given year? What range of returns would you expect to see 95 percent of the time? What range would you expect to see 99 percent of the time? Average return Standard deviation Return less than 6.30% 8.40% -2.10% Complete the following analysis. Do not hard code values in your calculations. You must use the built-in Excel function to answer this question. Probability less than -2.10% Lower return Upper return Range 95 percent 99 percent ... Sheet1 ... + READY 1 0 U - Attempt(s) 3/3 Step: Use the NORM.DIST formula to calculate the probability a return is less than a specific value. + 100% Hint Suppose the returns below are normally distributed. Based on these values, what is the approximate probability that your return will be less than -2.1 percent in a given year? What range of returns would you expect to see 95 percent of the time? What range would you expect to see 99 percent of the time? Average return Standard deviation Return less than 6.30% 8.40% -2.10% Complete the following analysis. Do not hard code values in your calculations. You must use the built-in Excel function to answer this question. Probability less than -2.10% Lower return Upper return Range 95 percent 99 percent ... Sheet1 ... + READY + 100% Attempt(s) 3/3 Hint Step: In a normal distribution, 95 percent of the returns are within plus or minus two standard deviations of the mean