Excel Online DATAfile Activity: CorporateBonds A sample containing years to matu
ID: 421823 • Letter: E
Question
Excel Online DATAfile Activity: CorporateBonds
A sample containing years to maturity and yield for 40 corporate bonds is contained in the Excel Online file above. Construct a spreadsheet to answer the following questions.
***Please include Excel formulas. Thank you.***
a. What is the sample mean years to maturity for corporate bonds and what is the sample standard deviation?
b. Develop a 95% confidence interval for the population mean years to maturity. Please round the answer to four decimal places.
(_______,________ ) years ???????
c. What is the sample mean yield on corporate bonds and what is the sample standard deviation?
d. Develop a 95% confidence interval for the population mean yield on corporate bonds. Please round the answer to four decimal places.
(_____,____ ) % ???????
A B C 1 Company Ticker Years to Maturity Yield 2 HSBC 25.25 4.504 3 GS 15.50 5.249 4 C 20.25 7.039 5 MS 27.75 5.490 6 C 28.25 6.463 7 TOTAL 3,25 7.150 8 MS 24.25 3.979 9 WFC 6.50 5.063 10 TOTAL 20.50 4.714 11 TOTAL 3.50 0.987 12 BAC 24.75 3.415 13 RABOBK 19.50 2.555 14 GS 9.00 7.136 15 AXP 23.25 2.679 16 MTNA 19.75 4.859 17 MTNA 6.25 1.392 18 JPM 2.00 1.387 19 GE 25.50 4.087 20 LNC 3.50 5.110 21 BAC 22.25 2.456 22 FCX 13.25 7.156 23 GS 17.75 3.965 24 RABOBK 28.00 1.903 25 GE 15.50 0.813 26 HCN 28.00 6.889 27 GE 23.25 5.248 28 VOD 9.00 2.364 29 NEM 24.75 5.723 30 GE 18.00 7.004 31 C 17.25 0.955 32 SHBASS 13.00 6.877 33 PAA 28.00 5.696 34 GS 20.00 4.788 35 TOTAL 18.50 6.219 36 MS 23.00 6.340 37 WFC 18.00 6.763 38 AIG 11.00 6.219 39 BAC 13.75 4.411 40 MS 21.00 3.561 41 T 6.50 1.662Explanation / Answer
Z value for 95% confidence interval = 1.96
b)Therefore , 95% confidence interval for the population mean years to maturity
= Mean + /- Standard deviation
= 17.4563 + / - 7.9126
= 9.5437 , 25.3689
d)95% confidence interval for the population mean yield on corporate bonds
= 4.5068 + / - 2.0294
= 2.4774 , 6.5362
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.