Use the data file A2Q2.xlsx to answer this question. A sample containing years tomaturity and yield for 40 corporate bonds is contained in the file A2Q2.xlsx.a. What is the sample mean years to maturity for corporate bonds and what is thesample 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 corporatebonds. Company TickerYears to MaturityYieldHSBC12.004.079GS9.755.367C4.753.332MS9.255.798C9.754.814TOTAL5.002.069MS5.004.739WFC10.003.682TOTAL10.003.270TOTAL3.251.748BAC9.754.009RABOBK9.753.203GS9.255.755AXP5.002.181MTNA5.004.366MTNA10.006.046JPM8.252.310GE28.005.030LNC10.004.163BAC8.003.699FCX15.004.030GS25.506.013RABOBK4.752.755GE24.755.008HCN8.004.184GE11.503.778VOD5.001.855NEM12.003.866GE1.000.767C29.758.004SHBASS5.002.261PAA10.253.856GS5.753.558TOTAL1.751.378MS6.003.413WFC1.751.797AIG5.003.452BAC29.754.000MS2.001.016T28.504.930 **Bonds Data Overview**The table presented contains information on various bonds from different companies. It lists the company ticker, years until maturity, and the yield percentage.**Data Table Description:**- **Company Ticker**: The identifier for the issuing company.- **Years to Maturity**: The number of years remaining until the bond matures.- **Yield**: The yield percentage, representing the annual return on investment from the bond.**Detailed Dataset:**1. HSBC - 12.00 years, Yield: 4.079%2. GS - 9.75 years, Yield: 5.367%3. C - 4.75 years, Yield: 3.332%4. MS - 9.25 years, Yield: 5.798%5. C - 9.75 years, Yield: 4.814%6. TOTAL - 5.00 years, Yield: 2.069%7. MS - 5.00 years, Yield: 4.739%8. WFC - 10.00 years, Yield: 3.682%9. TOTAL - 10.00 years, Yield: 3.270%10. TOTAL - 3.25 years, Yield: 1.748%11. BAC - 11.00 years, Yield: 4.009%12. RABOBK - 9.75 years, Yield: 3.203%13. GS - 9.25 years, Yield: 5.755%14. AXP - 5.00 years, Yield: 2.181%15. MTNA - 5.00 years, Yield: 4.366%16. MTNA - 10.00 years, Yield: 6.046%17. JPM - 8.25 years, Yield: 2.310%18. GE - 28.00 years, Yield: 5.030%19. LNC - 10.00 years, Yield: 4.163%20. BAC - 8.00 years, Yield: 3.699%21. FCX - 15.00 years, Yield: 4.341%22. GS - 25.50 years, Yield: 6.013%23. RABOBK - 4.75 years, Yield: 2.755%24

Since you have posted a question with multiple sub-parts, we will solve first three sub-parts for…

Answered: Use the data file A2Q2.xlsx to answer…

MATLAB: An Introduction with Applications

6th Edition

ISBN:9781119256830

Author:Amos Gilat

Publisher:Amos Gilat

Chapter1: Starting With Matlab

Section: Chapter Questions

Problem 1P

See similar textbooks

Related questions

Concept explainers

Question

Use the data file A2Q2.xlsx to answer this question. A sample containing years to
maturity and yield for 40 corporate bonds is contained in the file A2Q2.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.

Company Ticker	Years to Maturity	Yield
HSBC	12.00	4.079
GS	9.75	5.367
C	4.75	3.332
MS	9.25	5.798
C	9.75	4.814
TOTAL	5.00	2.069
MS	5.00	4.739
WFC	10.00	3.682
TOTAL	10.00	3.270
TOTAL	3.25	1.748
BAC	9.75	4.009
RABOBK	9.75	3.203
GS	9.25	5.755
AXP	5.00	2.181
MTNA	5.00	4.366
MTNA	10.00	6.046
JPM	8.25	2.310
GE	28.00	5.030
LNC	10.00	4.163
BAC	8.00	3.699
FCX	15.00	4.030
GS	25.50	6.013
RABOBK	4.75	2.755
GE	24.75	5.008
HCN	8.00	4.184
GE	11.50	3.778
VOD	5.00	1.855
NEM	12.00	3.866
GE	1.00	0.767
C	29.75	8.004
SHBASS	5.00	2.261
PAA	10.25	3.856
GS	5.75	3.558
TOTAL	1.75	1.378
MS	6.00	3.413
WFC	1.75	1.797
AIG	5.00	3.452
BAC	29.75	4.000
MS	2.00	1.016
T	28.50	4.930

**Bonds Data Overview**

The table presented contains information on various bonds from different companies. It lists the company ticker, years until maturity, and the yield percentage.

**Data Table Description:**

- **Company Ticker**: The identifier for the issuing company.
- **Years to Maturity**: The number of years remaining until the bond matures.
- **Yield**: The yield percentage, representing the annual return on investment from the bond.

**Detailed Dataset:**

1. HSBC - 12.00 years, Yield: 4.079%
2. GS - 9.75 years, Yield: 5.367%
3. C - 4.75 years, Yield: 3.332%
4. MS - 9.25 years, Yield: 5.798%
5. C - 9.75 years, Yield: 4.814%
6. TOTAL - 5.00 years, Yield: 2.069%
7. MS - 5.00 years, Yield: 4.739%
8. WFC - 10.00 years, Yield: 3.682%
9. TOTAL - 10.00 years, Yield: 3.270%
10. TOTAL - 3.25 years, Yield: 1.748%
11. BAC - 11.00 years, Yield: 4.009%
12. RABOBK - 9.75 years, Yield: 3.203%
13. GS - 9.25 years, Yield: 5.755%
14. AXP - 5.00 years, Yield: 2.181%
15. MTNA - 5.00 years, Yield: 4.366%
16. MTNA - 10.00 years, Yield: 6.046%
17. JPM - 8.25 years, Yield: 2.310%
18. GE - 28.00 years, Yield: 5.030%
19. LNC - 10.00 years, Yield: 4.163%
20. BAC - 8.00 years, Yield: 3.699%
21. FCX - 15.00 years, Yield: 4.341%
22. GS - 25.50 years, Yield: 6.013%
23. RABOBK - 4.75 years, Yield: 2.755%
24

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 3 steps with 2 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

$Point Estimation, Limit Theorems, Approximations, and Bounds$

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, statistics and related others by exploring similar questions and additional content below.

Similar questions