Home /
Expert Answers /
Statistics and Probability /
answer-the-questions-using-the-data-sheet-begin-tabular-c-c-c-c-hline-1-company-ticker-ye-pa131
(Solved): answer the questions using the data sheet \begin{tabular}{|c|c|c|c|} \hline 1 & Company Ticker & Ye ...
answer the questions using the data sheet
\begin{tabular}{|c|c|c|c|} \hline 1 & Company Ticker & Years to Maturity & Yield \\ \hline 2 & HSBC & 22.75 & 5.678 \\ \hline 3 & GS & 9.75 & 7.143 \\ \hline 4 & C & 8.50 & 1.041 \\ \hline 5 & MS & 19.00 & 4.153 \\ \hline 6 & c & 16.25 & 1.249 \\ \hline 7 & TOTAL. & 19.25 & 1.621 \\ \hline 8 & MS & 17.75 & 8.116 \\ \hline 9 & WFC & 17.00 & 2.786 \\ \hline 10 & TOTAL & 3.75 & 5.637 \\ \hline 11 & TOTAL & 23.25 & 7.825 \\ \hline 12 & BAC & 13.75 & 7.365 \\ \hline 13 & RABOBK & 17.75 & 7.299 \\ \hline 14 & GS & 28.75 & 3.640 \\ \hline 15 & AXP & 16.50 & 4.035 \\ \hline 16 & MTNA & 26.00 & 1.407 \\ \hline 17 & MTNA & 26.50 & 6.530 \\ \hline 18 & JPM & 23.25 & 7.100 \\ \hline 19 & GE & 7.00 & 3.674 \\ \hline 20 & LNC & 17.75 & 7.370 \\ \hline 21 & BAC & 24.25 & 5.707 \\ \hline 22 & & 9.25 & 1.672 \\ \hline 23 & GS & 14.25 & 1.369 \\ \hline 24 & RABOBK & 6.50 & 4.557 \\ \hline 25 & GE & 11.25 & 6.978 \\ \hline 26 & & 27.75 & 3.774 \\ \hline 27 & GE & 4.25 & 0.961 \\ \hline 28 & VOD & 4.75 & 3.640 \\ \hline 29 & NEM & 8.50 & 5.795 \\ \hline 30 & GE & 13.00 & 1.589 \\ \hline 31 & C & 18.50 & 1.243 \\ \hline 32 & SHBASS & 15.50 & 3.020 \\ \hline 33 & PAA & 12.75 & 1.992 \\ \hline 34 & GS & 2.75 & 6.015 \\ \hline 35 & TOTAL & 17.00 & 6.813 \\ \hline 36 & MS & 25.75 & 1.162 \\ \hline 37 & WFC & 25.75 & 6.395 \\ \hline 38 & AIG & 3.25 & 2.826 \\ \hline 39 & BAC & 16.25 & 1.296 \\ \hline 40 & MS & 1.75 & 5.242 \\ \hline 41 & & 18.75 & 4.774 \\ \hline \multicolumn{4}{|l|}{42} \\ \hline 43 & & & \\ \hline 44 & & & \\ \hline \end{tabular}
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. a. What is the sample mean years to maturity for corporate bonds and what is the sample standard deviation? Mean (to 4 decimals) Standard (to 4 deviation decimals) b. Develop a 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 (to 4 deviation decimals) d. Develop a confidence interval for the population mean yield on corporate bonds. Please round the answer to four decimal places. )