Use the data file A2Q3.xlsx to answer this question. A sample containing years to maturity and yield for 40 corporate bonds is contained in the file A2Q3.xlsx. A. What is the sample mean years to maturity for corporate bonds and what is the sample standard deviation? B. Develop a 95% confidence interval for the population mean years to maturity. C. What is the sample mean yield on corporate bonds and what is the sample standard deviation? D. Develop a 95% confidence interval for the population mean yield on corporate bonds.

Question must be done in excel but please explain each step as I am confused.

A1 vfs Company Ticker A B D E F 1 Company Ticker 2 HSBC 3 GS 4 C 5 MS 6 C 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 C 32 SHBASS 33 PAA 34 GS 35 TOTAL 36 MS 37 WFC 38 AIG 39 BAC 40 MS 41 T 42 Years to Maturity 12.00 9.75 4.75 9.25 9.75 5.00 5.00 10.00 10.00 3.25 9.75 9.75 9.25 5.00 5.00 10.00 8.25 28.00 10.00 8.00 15.00 25.50 4.75 24.75 8.00 11.50 5.00 12.00 1.00 29.75 5.00 10.25 5.75 1.75 6.00 1.75 5.00 29.75 2.00 28.50 Yield 4.079 5.367 3.332 5.798 4.814 2.069 4.739 3.682 3.270 1.748 4.009 3.203 5.755 2.181 4.366 6.046 2.310 5.030 4.163 3.699 4.030 6.013 2.755 5.008 4.184 3.778 1.855 3.866 0.767 8.004 2.261 3.856 3.558 1.378 3.413 1.797 3.452 4.000 1.016 4.930 A1 vfs Company Ticker A B D E F 1 Company Ticker 2 HSBC 3 GS 4 C 5 MS 6 C 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 C 32 SHBASS 33 PAA 34 GS 35 TOTAL 36 MS 37 WFC 38 AIG 39 BAC 40 MS 41 T 42 Years to Maturity 12.00 9.75 4.75 9.25 9.75 5.00 5.00 10.00 10.00 3.25 9.75 9.75 9.25 5.00 5.00 10.00 8.25 28.00 10.00 8.00 15.00 25.50 4.75 24.75 8.00 11.50 5.00 12.00 1.00 29.75 5.00 10.25 5.75 1.75 6.00 1.75 5.00 29.75 2.00 28.50 Yield 4.079 5.367 3.332 5.798 4.814 2.069 4.739 3.682 3.270 1.748 4.009 3.203 5.755 2.181 4.366 6.046 2.310 5.030 4.163 3.699 4.030 6.013 2.755 5.008 4.184 3.778 1.855 3.866 0.767 8.004 2.261 3.856 3.558 1.378 3.413 1.797 3.452 4.000 1.016 4.930