Answered step by step
Verified Expert Solution
Question
1 Approved Answer
A sample containing years to maturity and yield for 40 corporate bonds is contained in the Excel Online file below. Construct a spreadsheet to answer
A sample containing years to maturity and yield for 40 corporate bonds is contained in the Excel Online file below. Construct a spreadsheet to answer the following questions. gpen spreadsheet a. What is the sample mean years to maturity for corporate bonds and what is the sample standard deviation? Mean (to 4 decimals) Standard deviation (to 4 decimals) 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? Mean (to 4 decimals) Standard deviation (to 4 decimals) d. Develop a 95% confidence interval for the population mean yield on corporate bonds. Please round the answer to four decimal places. ( I )0/0 1 Company Ticker Years to Maturity Yield 2 HSBC 20.00 0.866 3 GS 16.75 6.308 4 C 23.75 7.134 MS 14.50 7.087 6 C 27.00 3.290 7 TOTAL 16.25 4.830 8 MS 29.50 3.657 9 WFC 3.75 5.770 10 TOTAL 20.75 4.687 11 TOTAL 19.00 7.512 12 BAC 4.25 1.928 RABOBK 14.25 3.496 14 GS 12.25 6.062 15 AXP 6.00 7.367 16 MTNA 18.00 4.425 17 MTNA 3.25 2.646 18 JPM 1.25 2.784 19 GE 8.00 5.078 20 LNC 19.25 1.456 21 BAC 4.25 6.660 22 FCX 24.75 1.862 23 GS 3.25 6.676 24 RABOBK 9.50 2.405 25 GE 22.50 6.730 26 HCN 5.50 2.490 27 GE 17.25 1.070 28 VOD 12.00 3.122 29 NEM 3.25 3.46827 GE 17.25 1.070 28 VOD 12.00 3.122 29 NEM 3.25 3.468 30 GE 25.75 3.882 31 C 2.50 1.307 32 SHBASS 9.00 0.820 33 PAA 4.75 7.087 34 GS 26.00 2.880 35 TOTAL 7.75 3.786 36 MS 12.00 7.190 37 WFC 10.75 3.153 38 AIG 5.50 3.274 39 BAC 10.25 6.145 40 MS 3.75 3.314 41 T 20.25 2.478 42
Step 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