D E 20 LNC B 1 Company Ticker Years to Maturity Yield 2 HSBC 23.75 5.846 3 GS 21.25 1.807 4C 24.75 6.736 5 MS 17.25 5.698 6 C 22.00 4353 7 TOTAL 12.25 0.901 8 MS 2 25 3.860 9 WFC 12.00 3.777 10 TOTAL 15.75 7.556 11 TOTAL 4.50 4.762 12 BAC 12 50 3 802 13 RABOBK 24.50 3.004 14 GS 10.75 4.333 5 MP 26.50 5.834 16 MTNA 27.75 3.056 17 MTNA 3.25 5.944 18 JPM 8.50 6949 19 GE 17.75 5015 10.75 2079 21 BAC 28.50 4749 22 FCX 2725 5.362 23 GS 17.00 0.936 24 RABOBK 275 3998 25 GE 23 00 7.750 10.75 5.281 450 4.197 28 VOD 19.25 4811 29 NEM 27.00 4692 150 3.767 5.50 3.610 32 SHBASS 8.75 7.195 33 PAA 5.50 2463 34 GS 5.75 2223 8.25 3588 9.25 37 WFC 3.889 25.50 1978 200 6355 39 BAC 17.50 2742 23 00 5.751 950 42 6349 - HN 27 GE 30 GE 31 C 35 TOTAL 36 MS 38 AIG 40 MS I 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 answe x Open ornadsheet . ? 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. Dyears c. What is the sample mean yield on corporate bonds and what is the sample standard deviation? ? Mean (to 4 decimals) 4 Standard deviation (to 4 decimals) 4 d. Develop a 95% confidence interval for the population mean yleld on corporate bonds. Please round the answer to four decimal places. Check My Work Reset