Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please give the the EXCEL formula for each! 3 Suppose the returns on long-term corporate bonds and T-bills are normally distributed. Based on the values
Please give the the EXCEL formula for each!
3 Suppose the returns on long-term corporate bonds and T-bills are normally distributed. Based on the values below answer the following questions: a. What is the probability that in any given year, the return on long-term corporate bonds will be greater than 10 percent? Less than 0 percent? b. What is the probability that in any given year, the return on T-bills will be greater than 10 percent? Less than 0 percent? c. In 1979, the return on long-term corporate bonds was -2.76 percent. How likely is it that such a low return will recur at some point in the future? T-bills had a return of 10.56 percent in this same year. How likely is it that such a high return on T-bills will recur at some point in the future? 4 5 6 6 7 6.30% 8.40% 8 9 10 11 Long-term corporate bonds Average return Standard deviation T-bills Average return Standard deviation a. Return greater than Return less than b. Return greater than Return less than C. Return less than 12 55 13 3.50% 3.10% 10.00% 0.00% 10.00% 0.00% -2.76% 14 15 16 Sheet1 A B D E F G H 13 14 15 Return less than b. Return greater than Return less than c. Return less than Return greater than 0.00% 10.00% 0.00% -2.76% 10.56% 16 17 18 19 20 Complete the following analysis. Do not hard code values in your calculations. You must use the built-in Excel functions to answer this question. 21 22 a. Probability of return greater than 10% Probability of return less than 0% 23 24 25 b. Probability of return greater than 10% Probability of return less than 0% 26 27 28 c. Probability of return less than -2.76% Probability of return greater than 10.56% 29 30 31 32 33 Sheet1 E 100 READY Attempt(s) 6/6 HintStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started