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. X Open 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. % Check My Work Reset Problem D NM00 A Company Ticker 2 HSBC 3 GS 4 5 MS 6 7 TOTAL 8 MS 9 WFC 10 TOTAL 11 TOTAL 12 BAC 13 RABOBK 14 GS 15 AXP 16 MTNA 17 MTNA 18 JPM 19 GE 20 LNC 21 BAC 22 FCX 23 GS 24 RABOBK 25 GE 25 HCM 27 GE 28 VOD 29 NEM 30 GE 31 32 SHBASS 33 PAA 34 GS 35 TOTAL 36 MS 37 WFC 38 AIG 39 BAC 40 MS 41 T 42 B Years to Maturity Yield 4.00 2.845 7.50 6.384 19.75 7.681 2.00 3.485 13.25 4.382 14.00 5.729 28.00 3.658 16.75 6.750 26.25 3.519 9.50 8.027 4.25 1.042 26.75 1.903 4.75 0.895 21.00 7.649 11.00 5.793 10.50 6.389 25.50 1.959 6.00 6.750 9.25 1.113 29.00 5.521 13.25 4.838 17.75 2.926 4.50 8. 115 5.75 0.967 27.00 8.086 5.25 2.372 20.50 7.194 19.75 2.988 19.50 5.410 18.25 2.787 19.75 4.549 28.00 3.065 6.75 4.042 23.25 7.835 24.25 5.781 20.25 5.985 2.75 4.908 18.25 3.660 23.75 1.352 17.25 6.624 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. X Open 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. % Check My Work Reset Problem D NM00 A Company Ticker 2 HSBC 3 GS 4 5 MS 6 7 TOTAL 8 MS 9 WFC 10 TOTAL 11 TOTAL 12 BAC 13 RABOBK 14 GS 15 AXP 16 MTNA 17 MTNA 18 JPM 19 GE 20 LNC 21 BAC 22 FCX 23 GS 24 RABOBK 25 GE 25 HCM 27 GE 28 VOD 29 NEM 30 GE 31 32 SHBASS 33 PAA 34 GS 35 TOTAL 36 MS 37 WFC 38 AIG 39 BAC 40 MS 41 T 42 B Years to Maturity Yield 4.00 2.845 7.50 6.384 19.75 7.681 2.00 3.485 13.25 4.382 14.00 5.729 28.00 3.658 16.75 6.750 26.25 3.519 9.50 8.027 4.25 1.042 26.75 1.903 4.75 0.895 21.00 7.649 11.00 5.793 10.50 6.389 25.50 1.959 6.00 6.750 9.25 1.113 29.00 5.521 13.25 4.838 17.75 2.926 4.50 8. 115 5.75 0.967 27.00 8.086 5.25 2.372 20.50 7.194 19.75 2.988 19.50 5.410 18.25 2.787 19.75 4.549 28.00 3.065 6.75 4.042 23.25 7.835 24.25 5.781 20.25 5.985 2.75 4.908 18.25 3.660 23.75 1.352 17.25 6.624