Assume that historical returns and future returns are independently and identically distributed and drawn from the same distribution. Calculate the 95% confidence intervals for the expected annual return of four different investments included in the tables (the time period spans 92 years). b. Assume that the values in the tables are the true expected return and volatility (i.e., estimated without error) and that these returns are normally distributed. For each investment, calculate the probability that an investor will not lose more than 4% in the next year. (Hint: For each investment, you can use the function normdist(x,mean,volatility,1) in Excel to compute the probability that a normally distributed variable with a given mean and volatility will exceed x where x in this case is -4%. Then subtract that probability from 100% to find the probability that an investor will not lose more than 4%.) c. Do all the probabilities you calculated in part (b) make sense? If so, explain. If not, can you identify the reason? ! Lower Bound 2.75% Upper Bound 4.05% Confidence interval for Treasury bills is (Round to two decimal places.) b. Assume that the values in the tables are the true expected return and volatility (i.e., estimated without error) and that these returns are normally distributed. For each investment, calculate the probability that an investor will not lose more than 4% in the next year. (Hint: For each inbestment, you can use the function nordist(X,mean,volatility,1) in Excel to compute the probability that a normally distributed variable with a given mean and volatility will exceed x where x in this case is -4%.. Then subtract that probability from 100% to find the probability that an investor will not lose more than 4%.) The probability of not losing more than 4% for small stocks is 71.87 %. (Round to two decimal places.) The probability of not losing more than 4% for the S&P 500 is 79.05%. (Round to two decimal places.) The probability of not losing more than 4% for corporate bonds is 94.45 %. (Round to two decimal places.) The probability of not losing more than 4% for Treasury bills is 99.15% (Round to two decimal places.) c. Do all the probabilities you calculated in part (b) make sense? If so, explain. If not, can you identify the reason? (Select the best choice below.) O A No. The probability that you can have a return on small stocks less than 4% is not nearly as high as 71.87%. The problem is that the return of small stocks are not normally distributed. B. No. You cannot lose money on Treasury bills. The problem is that the returns on Treasury bills are not normally distributed. O C. No. The probability that you can have return on the S&P less than 4% is not nearly as high as 79.05%. The problem is that the return of the S&P 500 is not normally distributed. OD. Yes. All these investments involve risk, and so you expect to lose money some of the time. Help me solve this View an example Get more help Similar question - x Data table (Click on the following icon in order to copy its contents into a spreadsheet.) Average Annual Returns for U.S. Small Stocks, Large Stocks (S&P 500), Corporate Bonds, and Treasury Bills, 1926-2017 Investment Average Annual Return Small stocks 18.7% S&P 500 12.0% Corporate bonds 6.2% Treasury bills 3.4% (Click on the following icon in order to copy its contents into a spreadsheet.) Volatility of U.S. Small Stocks, Large Stocks (S&P 500), Corporate Bonds, and Treasury Bills, 1926-2017 Investment Return Volatility (Standard Deviation) Small stocks 39.2% S&P 500 19.8% Corporate bonds 6.4% Treasury bills 3.1% Print Done Assume that historical returns and future returns are independently and identically distributed and drawn from the same distribution. Calculate the 95% confidence intervals for the expected annual return of four different investments included in the tables (the time period spans 92 years). b. Assume that the values in the tables are the true expected return and volatility (i.e., estimated without error) and that these returns are normally distributed. For each investment, calculate the probability that an investor will not lose more than 4% in the next year. (Hint: For each investment, you can use the function normdist(x,mean,volatility,1) in Excel to compute the probability that a normally distributed variable with a given mean and volatility will exceed x where x in this case is -4%. Then subtract that probability from 100% to find the probability that an investor will not lose more than 4%.) c. Do all the probabilities you calculated in part (b) make sense? If so, explain. If not, can you identify the reason? ! Lower Bound 2.75% Upper Bound 4.05% Confidence interval for Treasury bills is (Round to two decimal places.) b. Assume that the values in the tables are the true expected return and volatility (i.e., estimated without error) and that these returns are normally distributed. For each investment, calculate the probability that an investor will not lose more than 4% in the next year. (Hint: For each inbestment, you can use the function nordist(X,mean,volatility,1) in Excel to compute the probability that a normally distributed variable with a given mean and volatility will exceed x where x in this case is -4%.. Then subtract that probability from 100% to find the probability that an investor will not lose more than 4%.) The probability of not losing more than 4% for small stocks is 71.87 %. (Round to two decimal places.) The probability of not losing more than 4% for the S&P 500 is 79.05%. (Round to two decimal places.) The probability of not losing more than 4% for corporate bonds is 94.45 %. (Round to two decimal places.) The probability of not losing more than 4% for Treasury bills is 99.15% (Round to two decimal places.) c. Do all the probabilities you calculated in part (b) make sense? If so, explain. If not, can you identify the reason? (Select the best choice below.) O A No. The probability that you can have a return on small stocks less than 4% is not nearly as high as 71.87%. The problem is that the return of small stocks are not normally distributed. B. No. You cannot lose money on Treasury bills. The problem is that the returns on Treasury bills are not normally distributed. O C. No. The probability that you can have return on the S&P less than 4% is not nearly as high as 79.05%. The problem is that the return of the S&P 500 is not normally distributed. OD. Yes. All these investments involve risk, and so you expect to lose money some of the time. Help me solve this View an example Get more help Similar question - x Data table (Click on the following icon in order to copy its contents into a spreadsheet.) Average Annual Returns for U.S. Small Stocks, Large Stocks (S&P 500), Corporate Bonds, and Treasury Bills, 1926-2017 Investment Average Annual Return Small stocks 18.7% S&P 500 12.0% Corporate bonds 6.2% Treasury bills 3.4% (Click on the following icon in order to copy its contents into a spreadsheet.) Volatility of U.S. Small Stocks, Large Stocks (S&P 500), Corporate Bonds, and Treasury Bills, 1926-2017 Investment Return Volatility (Standard Deviation) Small stocks 39.2% S&P 500 19.8% Corporate bonds 6.4% Treasury bills 3.1% Print Done