### Free Educational Resources

• > A SAMPLE CONTAINING YEARS TO MATURITY AND YIELD...
+

# A SAMPLE CONTAINING YEARS TO MATURITY AND YIELD...

##### Rating:
(0)
Author: angela bedfrd
##### Description:

A SAMPLE CONTAINING YEARS TO MATURITY AND YIELD (%) FOR 40 CORPORATE BONDS ARE CONTAINED IN THE DATA FILE NAMED CORPORATEBONDS (BARRON'S, APRIL 2, 2012).

http://theperfecthomework.com/a-sample-containing-years-to-maturity-and-yield-for-40-corporate-bonds-are-contained-in-the-data-file-named-corporatebonds-barrons-april-2-2012/

Top of Form

Problem 4-17
A sample containing years to maturity and yield (%) for 40 corporate bonds are contained in the data file named CorporateBonds (Barron's, April 2, 2012).
Click on the webfile logo to reference the data.

(a)

Choose a scatter chart below with years to maturity as the independent variable.

(i)

(ii)

(iii)

(iv)

Does a simple linear regression model appear to be appropriate?

Explain.

The input in the box below will not be graded, but may be reviewed and considered by your instructor.

(b)

Develop an estimated quadratic regression equation with years to maturity and squared values of years to maturity as the independent variables.

If required, round your answers to four decimal places. For subtractive or negative numbers use a minus sign even if there is a + sign before the blank. (Example: -300)

= + x + x2

How much variation in the sample values of yield does this regression model explain?

%

Is the overall regression relationship significant at a 0.05 level of significance? If so, then test the relationship between each of the independent variables and the dependent variable at a 0.05 level of significance. How would you interpret this model?

The input in the box below will not be graded, but may be reviewed and considered by your instructor.

(c)

Use Excel to create a plot of the linear and quadratic regression lines overlaid on the scatter chart of years to maturity and yield. Choose the correct chart below.

(i)

(ii)

(iii)

(iv)

Which model does this chart suggest provides a superior fit to the sample data?

(d)

What other independent variables could you include in your regression model to explain more variation in yield?

The input in the box below will not be graded, but may be reviewed and considered by your instructor.

Hide FeedbackShow All Feedback
Check My Work Feedback
Post Submission Feedback
Solution
Check My WorkCheck My Work

Bottom of Form

Icon Key
100% Correct
Partially Correct
Visited, Not Yet Judged
Incorrect

Question 6 of 7
Problem 04-17

Question Saved
Cengage Learning
Cengage Technical Support
Basic Calculatorclose

0
UseEntBSBSpCEHomCEnd
789+
456-
123*
0.=/

(more)
##### Try a College Course Free

Sophia’s self-paced online courses are a great way to save time and money as you earn credits eligible for transfer to over 2,000 colleges and universities.*

No credit card required

26 Sophia partners guarantee credit transfer.

226 Institutions have accepted or given pre-approval for credit transfer.

* The American Council on Education's College Credit Recommendation Service (ACE Credit®) has evaluated and recommended college credit for 21 of Sophia’s online courses. More than 2,000 colleges and universities consider ACE CREDIT recommendations in determining the applicability to their course and degree programs.

Tutorial