x8

A sample containing years to matunty and vild for 40 corporate bonds is contained in the Excel Online file below. Construct a spreadsheet to answer the following questions, HH Weens die 2. 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) 1. Develop a 95% confidence interval for the population mean years to maturity. Please round the answer to four decimal places years c. What 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 o . D E A 1 Company Ticker 2 HSBC GS 4 5 MS 6 7 TOTAL 8 MS 9 WFC 10 TOTAL 11 TOTAL 12 BAC 13 RABOBK 14 GS 15 XP 16 MTNA 17 MTNA 18 JPM 19 GE 20 LNC 21 BAC 22 FCX B C Years to Maturity Yield 22.50 2.357 26.50 5.962 1.50 5.965 18.00 7.692 15.25 7 298 3.75 4.072 10.50 7.381 5.00 5.153 23.50 2.742 14.75 1.106 12 25 3.167 27.50 3.318 19.00 2.020 21.75 5.126 25.25 5.830 21 25 3.920 18.50 1.172 10.75 3.965 14.00 6.856 29.00 6.291 11.25 6.018 Data + Calculation Mode: Automatic Workbook Statistics O BE Type here to search GS RABOBK GE HCN GE VOD NEM GE SHBASS GS 5 TOTAL 6 MS 7 WFC 8 AIG 39 BAC 10 MS 27.00 3.50 2.00 23.50 15.75 6.00 16.00 20.75 1.00 28.50 2.00 26.00 2.00 20.50 17.00 27.50 3.50 19.75 10.25 7.474 2.065 6.788 5.222 6.134 8.128 7.474 7.540 1.571 5.834 4.324 6.217 7.880 2.091 2.726 6.178 5.168 3.739 3.813 42 43 44 Data + Calculation Mode: Automatic Workbook Statistics Type here to search O