Essentials of Business Analytics (MindTap Course List)
2nd Edition
ISBN: 9781305627734
Author: Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Textbook Question
Chapter 7, Problem 17P
A sample containing years to maturity and (percent) yield for 40 corporate bonds is contained in the file named CorporateBonds (Barron’s, April 2. 2012).
- a. Develop a scatter chart of the data using years to maturity as the independent variable. Does a simple linear regression model appear to be appropriate?
- b. Develop an estimated quadratic regression equation with years to maturity and squared values of years to maturity as the independent variables. How much variation in the sample values of yield is explained by this regression model? 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?
- c. Create a plot of the linear and quadratic regression lines overlaid on the scatter chart of years to maturity and yield. Does this helps you better understand the difference in how the quadratic regression model and a simple linear regression model fit the sample data? 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?
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
The regional transit authority for a major metropolitan area wants to determine whetherthere is a relationship between the age of a bus and the annual maintenance cost. A sampleof ten buses resulted in the following data:
a. Develop a scatter chart for these data. What does the scatter chart indicate about therelationship between age of a bus and the annual maintenance cost?b. Use the data to develop an estimated regression equation that could be used to predictthe annual maintenance cost given the age of the bus. What is the estimated regressionmodel?c. Test whether each of the regression parameters b0 and b1 is equal to zero at a 0.05level of significance. What are the correct interpretations of the estimated regressionparameters? Are these interpretations reasonable?d. How much of the variation in the sample values of annual maintenance cost does themodel you estimated in part b explain?e. What do you predict the annual maintenance cost to be for a 3.5-year-old bus?
A marketing professor at Givens College is interested in the relationship between hoursspent studying and total points earned in a course. Data collected on 156 students whotook the course last semester are provided in the file MktHrsPts.a. Develop a scatter chart for these data. What does the scatter chart indicate about therelationship between total points earned and hours spent studying?b. Develop an estimated regression equation showing how total points earned is relatedto hours spent studying. What is the estimated regression model?c. Test whether each of the regression parameters b0 and b1 is equal to zero at a 0.01level of significance. What are the correct interpretations of the estimated regressionparameters? Are these interpretations reasonable?d. How much of the variation in the sample values of total point earned does the modelyou estimated in part b explain?e. Mark Sweeney spent 95 hours studying. Use the regression model you estimated inpart b to predict the total points…
The Transactional Records Access Clearinghouse at Syracuse University reported data showing the odds of an Internal Revenue Service audit. The following table shows the average adjusted gross income reported and the percent of the returns that were audited for 20 selected IRS districts.
Develop the estimated regression equation that could be used to predict the percent audited given the average adjusted gross income reported.
At the .05 level of significance, determine whether the adjusted gross income and the percent audited are related.
Did the estimated regression equation provide a good fit?
District
Adjusted Gross Income ($)
Percent Audited
Los Angeles
36,664
1.3
Sacramento
38,845
1.1
Atlanta
34,886
1.1
Boise
32,512
1.1
Dallas
34,531
1.0
Providence
35,995
1.0
San Jose
37,799
0.9
Cheyenne
33,876
0.9
Fargo
30,513
0.9
New Orleans
30,174
0.9
Oklahoma City
30,060
0.8
Houston
37,153…
Chapter 7 Solutions
Essentials of Business Analytics (MindTap Course List)
Ch. 7 - Bicycling World, a magazine devoted to cycling,...Ch. 7 - In a manufacturing process the assembly line speed...Ch. 7 - Jensen Tire Auto is deciding whether to purchase...Ch. 7 - A sociologist was hired by a large city hospital...Ch. 7 - The regional transit authority for a major...Ch. 7 - A marketing professor at Givens College is...Ch. 7 - The Dow Jones Industrial Average (DJIA) and the...Ch. 7 - The Toyota Camry is one of the best-selling cars...Ch. 7 - Dixie Showtime Movie Theaters, Inc., owns and...Ch. 7 - Prob. 10P
Ch. 7 - The American Association of Individual Investors...Ch. 7 - The National Football League (NFL) records a...Ch. 7 - Johnson Filtration. Inc., provides maintenance...Ch. 7 - A study investigated the relationship between...Ch. 7 - The U.S. Department of Energys Fuel Economy Guide...Ch. 7 - A highway department is studying the relationship...Ch. 7 - A sample containing years to maturity and...Ch. 7 - In 2011, home prices and mortgage rates fell so...Ch. 7 - A recent 10-year study conducted by a research...Ch. 7 - The Scholastic Aptitude Test (or SAT) is a...Ch. 7 - Consider again the example introduced in Section...Ch. 7 - Alumni donations are an important source of...
Knowledge Booster
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
- Find the equation of the regression line for the following data set. x 1 2 3 y 0 3 4arrow_forwardOlympic Pole Vault The graph in Figure 7 indicates that in recent years the winning Olympic men’s pole vault height has fallen below the value predicted by the regression line in Example 2. This might have occurred because when the pole vault was a new event there was much room for improvement in vaulters’ performances, whereas now even the best training can produce only incremental advances. Let’s see whether concentrating on more recent results gives a better predictor of future records. (a) Use the data in Table 2 (page 176) to complete the table of winning pole vault heights shown in the margin. (Note that we are using x=0 to correspond to the year 1972, where this restricted data set begins.) (b) Find the regression line for the data in part ‚(a). (c) Plot the data and the regression line on the same axes. Does the regression line seem to provide a good model for the data? (d) What does the regression line predict as the winning pole vault height for the 2012 Olympics? Compare this predicted value to the actual 2012 winning height of 5.97 m, as described on page 177. Has this new regression line provided a better prediction than the line in Example 2?arrow_forwardWhat does the y -intercept on the graph of a logistic equation correspond to for a population modeled by that equation?arrow_forward
- Suppose the athletic director at a university would like to develop a regression model to predict the point differential for games played by the men's basketball team. A point differential is the difference between the final points scored by two competing teams. A positive differential is a win, and a negative differential is a loss. For a random sample of games, the point differential was calculated, along with the number of assists, rebounds, turnovers, and personal fouls. Use the data in the accompanying table attached below to complete parts a through e below. Assume a = 0.05. a) Using technology, construct a regression model using all three independent variables. y = __ + (_)x1 + (_)x2 + (_)x3 + (_)x4 b) Test the significance of each independent variable using a= 0.10. c) interpret the p-value for each independent variable. d) Construxt a 90% confidence interval for the regression coefficients for each independent variable and interpret the meaning. e) Using the results from…arrow_forwardfind the (a) explained variation, (b) unexplained variation, and (c) indicated prediction interval. In each case, there is sujficient evidence to support a claim of a linear correlation, so it is reasonable to use the regression equation when making predictions. Altitude and Temperature Listed below are altitudes (thousands of feet) and outside air temperatures (°F) recorded by the author during Delta Flight 1053 from New Orleans to Atlanta. For the prediction interval, use a 95% confidence level with the altitude of 6327 ft (or 6.327 thousand feet).arrow_forwardUse the Manufacturing database from “Excel Databases.xls” on Blackboard. Use Excel to develop a multiple regression model to predict Cost of Materials by Number of Employees, New Capital Expenditures, Value Added by Manufacture, and End-of-Year Inventories. Use Excel to perform a test of the overall model. Write the test statistic. Round your answer to 2 decimal places SIC Code No. Emp. No. Prod. Wkrs. Value Added by Mfg. Cost of Materials Value of Indus. Shipmnts New Cap. Exp. End Yr. Inven. Indus. Grp. 201 433 370 23518 78713 4 1833 3630 1 202 131 83 15724 42774 4 1056 3157 1 203 204 169 24506 27222 4 1405 8732 1 204 100 70 21667 37040 4 1912 3407 1 205 220 137 20712 12030 4 1006 1155 1 206 89 69 12640 13674 3 873 3613 1 207 26 18 4258 19130 3 487 1946 1 208 143 72 35210 33521 4 2011 7199 1 209 171 126 20548 19612 4 1135 3135 1 211 21 15 23442 5557 3 605 5506 2 212 3 2 287 163 1 2 42 2 213 2 2 1508 314 1 15 155 2 214 6 4 624 2622 1 27 554 2 221…arrow_forward
- Refer to the Buena School bus data. Develop a regression equation that expresses the relationship between age of the bus and maintenance. The age of the bus is the inde- pendent variable. Draw a scatter diagram. What does this diagram suggest as to the relationship between the two variables? Is it direct or indirect? Does it appear to be strong or weak? Develop a regression equation. How much does an additional year add to the main- tenance cost. What is the estimated maintenance cost for a 10-year-old bus? Conduct a test of hypothesis to determine whether the slope of the regression line is greater than zero. Use the .05 significance level. Interpret your findings from parts (a), (b), and (c) in a brief report.arrow_forwardRegarding a scatterplot, a. identify one of its uses. b. what property should it have to obtain a regression line for the data?arrow_forward
arrow_back_ios
arrow_forward_ios
Recommended textbooks for you
Algebra and Trigonometry (MindTap Course List)AlgebraISBN:9781305071742Author:James Stewart, Lothar Redlin, Saleem WatsonPublisher:Cengage Learning
College AlgebraAlgebraISBN:9781305115545Author:James Stewart, Lothar Redlin, Saleem WatsonPublisher:Cengage Learning
Linear Algebra: A Modern IntroductionAlgebraISBN:9781285463247Author:David PoolePublisher:Cengage Learning
Glencoe Algebra 1, Student Edition, 9780079039897...AlgebraISBN:9780079039897Author:CarterPublisher:McGraw Hill
Big Ideas Math A Bridge To Success Algebra 1: Stu...AlgebraISBN:9781680331141Author:HOUGHTON MIFFLIN HARCOURTPublisher:Houghton Mifflin Harcourt
Algebra and Trigonometry (MindTap Course List)
Algebra
ISBN:9781305071742
Author:James Stewart, Lothar Redlin, Saleem Watson
Publisher:Cengage Learning
College Algebra
Algebra
ISBN:9781305115545
Author:James Stewart, Lothar Redlin, Saleem Watson
Publisher:Cengage Learning
Linear Algebra: A Modern Introduction
Algebra
ISBN:9781285463247
Author:David Poole
Publisher:Cengage Learning
Glencoe Algebra 1, Student Edition, 9780079039897...
Algebra
ISBN:9780079039897
Author:Carter
Publisher:McGraw Hill
Big Ideas Math A Bridge To Success Algebra 1: Stu...
Algebra
ISBN:9781680331141
Author:HOUGHTON MIFFLIN HARCOURT
Publisher:Houghton Mifflin Harcourt
Correlation Vs Regression: Difference Between them with definition & Comparison Chart; Author: Key Differences;https://www.youtube.com/watch?v=Ou2QGSJVd0U;License: Standard YouTube License, CC-BY
Correlation and Regression: Concepts with Illustrative examples; Author: LEARN & APPLY : Lean and Six Sigma;https://www.youtube.com/watch?v=xTpHD5WLuoA;License: Standard YouTube License, CC-BY