Modern Business Statistics with Microsoft Office Excel (with XLSTAT Education Edition Printed Access Card) (MindTap Course List)
6th Edition
ISBN: 9781337115186
Author: David R. Anderson, Dennis J. Sweeney, Thomas A. Williams, Jeffrey D. Camm, James J. Cochran
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Question
Chapter 15.3, Problem 16E
a.
To determine
Explain whether the estimated regression equation that uses only the average number of passing yards per attempt as the independent variable to predict the percentage of games won provide a good fit.
b.
To determine
Explain the benefit of using both the average number of passing yards per attempt and the number of interceptions thrown per attempt to predict the percentage of games won.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Which of the multivariate regression parameters listed below would be best interpreted as: the predicted value on the dependent variable when all of the independent variables in the model are equal to zero.
a
b1
X1
R2
A sample of 20 automobiles was taken, and the miles per gallon (MPG), horsepower, and total weight were recorded. Develop a linear regression model to predict MPG, using horsepower as the only independent variable. Develop another model with weight as the independent variable. Which of these two models is better? Explain.
MPG
HORSEPOWER
WEIGHT
44
67
1,844
44
50
1,998
40
62
1,752
37
69
1,980
37
66
1,797
34
63
2,199
35
90
2,404
32
99
2,611
30
63
3,236
28
91
2,606
26
94
2,580
26
88
2,507
25
124
2,922
22
97
2,434
20
114
3,248
21
102
2,812
18
114
3,382
18
142
3,197
16
153
4,380
16
139
4,036
Life insurance companies are keenly interested in predicting how long their customers are likely to live, because this will determine their premiums and ultimately their profitability. An Australian life insurance company is interested in the relationship, if any, between the age at death of their male customers and that of the customer’s father. Data are collected on a random sample of 100 of their male customers who have recently died. The customer’s age at death was plotted against that of their father and a linear regression model applied. Relevant output is shown below.
Say how you know from the output that there actually is a significant linear relationship between a male customer’s age at death and his father’s age at death.
State the value of the coefficient of Father’s Age (Death) and interpret this value in the context of the problem at hand.State the value of the coefficient of determination in the model and interpret this value in the context of the situation.
Chapter 15 Solutions
Modern Business Statistics with Microsoft Office Excel (with XLSTAT Education Edition Printed Access Card) (MindTap Course List)
Ch. 15.2 - 1. The estimated regression equation for a model...Ch. 15.2 - Consider the following data for a dependent...Ch. 15.2 - Prob. 3ECh. 15.2 - 4. A shoe store developed the following estimated...Ch. 15.2 - The owner of Showtime Movie Theaters, Inc. would...Ch. 15.2 - NFL Winning Percentage. The National Football...Ch. 15.2 - Prob. 7ECh. 15.2 - Scoring Cruise Ships. The Condé Nast Traveler Gold...Ch. 15.2 - The Professional Golfers Association (PGA)...Ch. 15.2 - Baseball Pitcher Performance. Major League...
Ch. 15.3 - 11. In exercise 1, the following estimated...Ch. 15.3 - 12. In exercise 2, 10 observations were provided...Ch. 15.3 - Prob. 13ECh. 15.3 - Prob. 14ECh. 15.3 - 15. In exercise 5, the owner of Showtime Movie...Ch. 15.3 - Prob. 16ECh. 15.3 - In part (d) of exercise 9, data contained in the...Ch. 15.3 - Prob. 18ECh. 15.5 - In exercise 1, the following estimated regression...Ch. 15.5 - Prob. 20ECh. 15.5 - Prob. 21ECh. 15.5 - Prob. 22ECh. 15.5 - Testing Significance in Theater Revenue. Refer to...Ch. 15.5 - Testing Significance in Predicting NFL Wins. The...Ch. 15.5 - The Condé Nast Traveler Gold List provides ratings...Ch. 15.5 - Prob. 26ECh. 15.6 - Prob. 27ECh. 15.7 - 32. Consider a regression study involving a...Ch. 15.7 - Prob. 33ECh. 15.7 - 34. Management proposed the following regression...Ch. 15.7 - Repair Time. Refer to the Johnson Filtration...Ch. 15.7 - Prob. 36ECh. 15.7 - Prob. 37ECh. 15.8 - Prob. 40ECh. 15.8 - Exercise 5 gave the following data on weekly gross...Ch. 15.8 - The following table reports the price, horsepower,...Ch. 15 - 49. The admissions officer for Clearwater College...Ch. 15 - The personnel director for Electronics Associates...Ch. 15 - Prob. 46SECh. 15 - Recall that in exercise 44, the admissions officer...Ch. 15 - Recall that in exercise 45 the personnel director...Ch. 15 - Fortune magazine publishes an annual list of the...Ch. 15 - The Department of Energy and the U.S....Ch. 15 - The Tire Rack, an online distributor of tires and...Ch. 15 - The National Basketball Association (NBA) records...Ch. 15 - Consumer Research, Inc., is an independent agency...Ch. 15 - Matt Kenseth won the 2012 Daytona 500, the most...Ch. 15 - When trying to decide what car to buy, real value...
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
- Life insurance companies are keenly interested in predicting how long their customers are likely to live, because this will determine their premiums and ultimately their profitability. An Australian life insurance company is interested in the relationship, if any, between the age at death of their male customers and that of the customer’s father. Data are collected on a random sample of 100 of their male customers who have recently died. The customer’s age at death was plotted against that of their father and a linear regression model applied. Relevant output is shown below Examine both the scatterplot and the correlation matrix provided above. Comment on the apparent relationship between the customer’s age at death and their father’s age at death in the plot. Explain how the information in the correlation matrix supports your conclusionarrow_forwardA sales manager collected the following data on annual sales for new customer accounts and the number of years of experience for a sample of 10 salespersons. Salesperson Years of Experience Annual Sales ($1000s) 1 1 80 2 3 97 3 4 92 4 4 102 5 6 103 6 8 111 7 10 119 8 10 123 9 11 117 10 13 136 Develop a scatter diagram for these data with years of experience as the independent variable. Develop an estimated regression equation that can be used to predict annual sales given the years of experience. Use the estimated regression equation to predict annual sales for a salesperson with 9 years of experience.arrow_forwardThe Update to the Task Force Report on Blood Pressure Control in Children [12] reported the observed 90th per-centile of SBP in single years of age from age 1 to 17 based on prior studies. The data for boys of average height are given in Table 11.18. Suppose we seek a more efficient way to display the data and choose linear regression to accomplish this task. age sbp 1 99 2 102 3 105 4 107 5 108 6 110 7 111 8 112 9 114 10 115 11 117 12 120 13 122 14 125 15 127 16 130 17 132 Do you think the linear regression provides a good fit to the data? Why or why not? Use residual analysis to justify your answer. Am I supposed to run a residual plot and QQ-plot for this question?arrow_forward
- The monthly premium quoted by an insurance company for a critical illness policy was collected from a sample of 6 adult male smokers at different age. The data for the sample are shown: Age 28 25 50 39 47 31 Premium ($) 75 40 175 125 250 105 Using Age to predict premium, the Linear Regression equation is given by: ŷ =6.556X−112 and r2=0.813y^=6.556X−112 and r2=0.813 a. Identify the independent and Dependent variables. Dependent: Age Premium Independent: Age Premium b. Determine the slope. Slope = Slope = Round to 3 decimal places c. Determine |r||r| . |r|=|r|= Round to 3 decimal places d. Interpret rr : and e. Determine critical r value at 5% significance level and determine if there is a significant linear correlation exists. |r| critical=|r| critical= Round to 3 decimal places Linear Correlation:Linear Correlation: Significant Not Significant f. Predict the monthly premium for a 40 years old adult male smoker.…arrow_forwardThe owner of Showtime Movie Theaters, Inc., would like to predict weekly gross revenueas a function of advertising expenditures. Historical data for a sample of eight weeks follow. Weekly GrossRevenue($1000s) Television Advertising($1000s) Newspaper Advertising($1000s) 96 5.0 1.5 90 2.0 2.0 95 4.0 1.5 92 2.5 2.5 95 3.0 3.3 94 3.5 2.3 94 2.5 4.2 94 3.0 2.5 a. Develop an estimated regression equation with the amount of televisionadvertising as the independent variable.b. Develop an estimated regression equation with both television advertising and newspaper advertising as the independent variables. c. Is the estimated regression equation coefficient for television advertisingexpenditures the same in part (a) and in part (b)? Interpret the coefficient in each case. d. Predict weekly gross revenue for a week when $3500 is spent on television advertising and $1800 is spent on newspaper advertising.arrow_forwardA researcher recorded the number of e-mails received in a month and the number of online purchases made during that month for 50 people with an online presence. The resulting data were used to conduct a hypothesis test to investigate whether the slope of the population regression line relating number of e-mails received to number of online purchases is positive. What are the correct hypotheses for the test? H0:β1=0Ha:β1≠0H0:β1=0Ha:β1≠0 A H0:β1=0Ha:β1>0H0:β1=0Ha:β1>0 B H0:β1=0Ha:β1<0H0:β1=0Ha:β1<0 C H0:β1>0Ha:β1=0H0:β1>0Ha:β1=0 D H0:b1=0Ha:b1≠0 Earrow_forward
- A specialist in hospital administration stated that no. of employees in a hospital can be estimated by counting the no. of beds in the hospital .A health care researcher decided to develop a regression model in an attempt to predict the number of employees of a hospital by the no. of beds . 12 hospitals were surveyed and obtained following data. No of Beds. Employees 23 69 29 95 29 102 35 118 42 126 46 125 50 138 54 178 64 156 66 184 76 176 78 225 After obtaining the regression model and interpret it accordingly based on your understanding. Explain the…arrow_forwardA mail-order business selling personal computer supplies, software and hardware maintains a centralized warehouse. Management is currently examining the process of distribution from the warehouse and wants to study the factors that affect the warehouse distribution costs. Data collected over 24 random months contain the warehouse’s distribution cost (in thousands of Rands), the sales (in thousands of Rands) and the number of orders received. A multiple linear regression model was fitted to the data by using Stat1.2. Use the output to answer the questions that follow by typing only the letter of the correct option in the answer boxes. Variablesy: Warehouse Distribution Costx1: Salesx2: Number of Orders Model Fitting StatisticsR2 = 0.8504Adj R2: ? Regression Coefficients Beta Parameter Standard b Parameter Standard Estimates…arrow_forwarda) Calculate the least square regression line for X on Y of the given data?b) Calculate the coefficient of correlation of the given date? Interpret the value of the coefficient?arrow_forward
- The article “Models for Assessing Hoisting Times of Tower Cranes” (A. Leung and C. Tam, Journal of Construction Engineering and Management, 1999: 385–391) presents a model constructed by a stepwise regression procedure to predict the time needed for a tower crane hoisting operation. Twenty variables were considered, and the stepwise procedure chose a nine-variable model. The adjusted R2 for the selected model was 0.73. True or false: a) The value 0.73 is a reliable measure of the goodness of fit of the selected model. b) The value 0.73 may exaggerate the goodness of fit of the model. c) A stepwise regression procedure selects only variables that are of some use in predicting the value of the dependent variable. d) It is possible for a variable that is of no use in predicting the value of a dependent variable to be part of a model selected by a stepwise regression procedure.arrow_forwardGiven the partial results from a linear regression model below, a sample size of 504, and ɑ=0.05, What is the F-Statistic for the overall model? Is it statistically significant? What is the R2 for the regression model above?arrow_forwardThe table contains data on vehicle speed (h) and fuel consumption (lt / 100km) of 5 randomly selected vehicles. Estimate the average fuel consumption of a vehicle traveling at 45 km / h using the simple linear regression equation between vehicle speed and fuel consumption. Speed 55 60 65 70 75 Consumption 13 12 11 10 9 a. 15 b. 8 c. 7 d. 20arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Linear Algebra: A Modern IntroductionAlgebraISBN:9781285463247Author:David PoolePublisher:Cengage Learning
Glencoe Algebra 1, Student Edition, 9780079039897...AlgebraISBN:9780079039897Author:CarterPublisher:McGraw Hill
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
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