Essentials Of Business Analytics
1st Edition
ISBN: 9781285187273
Author: Camm, Jeff.
Publisher: Cengage Learning,
expand_more
expand_more
format_list_bulleted
Concept explainers
Textbook Question
Chapter 4, 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 solutionStudents have asked these similar questions
Home Price Sales. Where we considered the regression of sale price of a home on size, presence of a pool, lot area, age, number of baths, number of stories, number of garage stalls, presence of traffic, and type of roof based on data for 88 homes in northeast Phoenix. Describe and discuss problems that could have arisen in the collection of the data for this regression analysis.
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…
Chapter 4 Solutions
Essentials Of Business Analytics
Ch. 4 - Bicycling World, a magazine devoted to cycling,...Ch. 4 - In a manufacturing process the assembly line speed...Ch. 4 - Jensen Tire Auto is deciding whether to purchase...Ch. 4 - A sociologist was hired by a large city hospital...Ch. 4 - The regional transit authority for a major...Ch. 4 - A marketing professor at Givens College is...Ch. 4 - The Dow Jones Industrial Average (DJIA) and the...Ch. 4 - The Toyota Camry is one of the best-selling cars...Ch. 4 - Dixie Showtime Movie Theaters, Inc., owns and...Ch. 4 - Prob. 10P
Ch. 4 - The American Association of Individual Investors...Ch. 4 - The National Football League (NFL) records a...Ch. 4 - Johnson Filtration. Inc., provides maintenance...Ch. 4 - A study investigated the relationship between...Ch. 4 - The U.S. Department of Energys Fuel Economy Guide...Ch. 4 - A highway department is studying the relationship...Ch. 4 - A sample containing years to maturity and...Ch. 4 - In 2011, home prices and mortgage rates fell so...Ch. 4 - A recent 10-year study conducted by a research...Ch. 4 - The Scholastic Aptitude Test (or SAT) is a...Ch. 4 - Consider again the example introduced in Section...Ch. 4 - 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
- The Cadet is a popular model of sport utility vehicle, known for its relatively high resale value. The bivariate data given below were taken from a sample of sixteen Cadets, each bought new two years ago, and each sold used within the past month. For each Cadet in the sample, we have listed both the mileage x (in thousands of miles) that the Cadet had on its odometer at the time it was sold used and the price y (in thousands of dollars) at which the Cadet was sold used. With the aim of predicting the used selling price from the number of miles driven, we might examine the least-squares regression line, y=41.57 – 0.49.x. This line is shown in the scatter plot in Figure 1. Used selling price, Mileage, x (in thousands) (in thousands of dollars) 25.9 26.1 28.1 26.2 40- 21.1 31.4 24.0 27.5 35 27.2 30.9 38.7 21.4 30. 34.6 25.5 37.2 23.5 15.6 34.0 25- 23.8 28.0 20.9 30.9 20. 23.1 32.7 28.0 30.3 40 29.2 28.1 Figure 1 24.0 29.6 23.0 31.5 Send data to Excelarrow_forwardThe 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…arrow_forwardSuppose 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_forward
- find 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
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 LearningCollege AlgebraAlgebraISBN:9781305115545Author:James Stewart, Lothar Redlin, Saleem WatsonPublisher:Cengage LearningLinear Algebra: A Modern IntroductionAlgebraISBN:9781285463247Author:David PoolePublisher:Cengage Learning
- Glencoe Algebra 1, Student Edition, 9780079039897...AlgebraISBN:9780079039897Author:CarterPublisher:McGraw HillBig 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