B Video 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. 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 1 2 Company Ticker HSBC GS 3 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 26 HCN 27 GE 28 VOD 29 NEM 30 GE 31 32 SHBASS 33 PAA 34 GS Years to Maturity Yield 10.75 6.133 27.00 4.035 29.00 6.538 22.00 7.317 13.75 2.195 12.50 6.913 18.50 4.042 14.50 2.407 6.00 1.322 25.50 4.938 18.00 3.021 8.75 2.927 22.50 1.800 20.50 8.086 17.75 2.002 25.00 5.025 5.25 6.074 21.50 6.534 3.00 1.465 11.00 2.338 28.25 7.253 5.00 1.283 16.25 5.621 10.25 7.005 21.50 5.131 29.50 5.518 4.00 2.194 11.00 6.391 17.00 7.224 11.00 1.763 22.25 7.845 25.25 6.172 15.25 6.436 34 GS 35 TOTAL 36 MS 37 WFC 38 AIG 39 BAC 40 MS 41 T 15.25 10.75 23.00 8.00 26.00 9.25 2.00 14.00 6.436 3.859 3.867 1.095 4.899 5.947 6.133 5.292 B Video 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. 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 1 2 Company Ticker HSBC GS 3 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 26 HCN 27 GE 28 VOD 29 NEM 30 GE 31 32 SHBASS 33 PAA 34 GS Years to Maturity Yield 10.75 6.133 27.00 4.035 29.00 6.538 22.00 7.317 13.75 2.195 12.50 6.913 18.50 4.042 14.50 2.407 6.00 1.322 25.50 4.938 18.00 3.021 8.75 2.927 22.50 1.800 20.50 8.086 17.75 2.002 25.00 5.025 5.25 6.074 21.50 6.534 3.00 1.465 11.00 2.338 28.25 7.253 5.00 1.283 16.25 5.621 10.25 7.005 21.50 5.131 29.50 5.518 4.00 2.194 11.00 6.391 17.00 7.224 11.00 1.763 22.25 7.845 25.25 6.172 15.25 6.436 34 GS 35 TOTAL 36 MS 37 WFC 38 AIG 39 BAC 40 MS 41 T 15.25 10.75 23.00 8.00 26.00 9.25 2.00 14.00 6.436 3.859 3.867 1.095 4.899 5.947 6.133 5.292