Question: Please show excel equations. Thank you! D13 A B D E F G 1 1 2 3 Suppose the returns below are normally distributed. Based
Please show excel equations. Thank you! D13 A B D E F G 1 1 2 3 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? Jo Average return Standard deviation Retum less than 6.30% 8.40% -2.10% 10 11 Complete the following analysis. Do not hard code values in your calculations. You must use the built-In Excel function to answer this question. 12 Probability less than -2 10% Lower return Upper return 14 15 16 17 18 Rango 95 percent 99 percent
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
