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
Textbook Question
Chapter 16.2, Problem 13E
Refer to exercise 12.
- a. Develop an estimated regression equation that can be used to predict the average number of birdies per round based upon the percentage of time the player is able to hit a green in regulation.
- b. Develop an estimated regression equation that can be used to predict the average number of birdies per round based upon the percentage of time a player is able to hit a green in regulation, the average driving distance, and the average number of putts per round.
- c. At the .05 level of significance, test whether the two independent variables added in part (b), the average driving distance and the average number of putts per round, contribute significantly to the estimated regression equation developed in part (a). Explain.
The Professional Golfers’ Association of America (PGA) collects a wide variety of performance data for members of the PGA Tour. A portion of the 2012 year-end data for 191 PGA Tour players are contained in the DATAfile named PGATour (CBS Sports website, 2013). For each player the variable named Scoring Avg is the average number of strokes per completed round; GIR is the percentage of time the player is able to hit a green in regulation; DriveDist is the average number of yards per measured drive; PPR is the average number of putts the player takes per round; and BPR is the average number of birdies per round.
- a. Develop an estimated regression equation that can be used to predict Scoring Average given the percentage of time a player is able to hit a green in regulation.
- b. Develop an estimated regression equation that can be used to predict Scoring Average based upon the percentage of time a player is able to hit a green in regulation, the average driving distance, and the average number of putts per round.
- c. At the .05 level of significance, test whether the two independent variables added in part (b), the average driving distance and the average number of putts per round, contribute to the estimated regression equation developed in part (a). Explain.
Expert Solution & Answer
Trending nowThis is a popular solution!
Students have asked these similar questions
(a) For United States, provide data for the variables below over the years 1993 –2007:(i) Net migration rate (per 1,000 population)(ii) Total fertility rate (live births per woman)(iii)Unemployment, general level (Thousands)(iv) Wages(v) Life expectancy at birth for both sexes combined (years)Data can be obtained from the UN database http://data.un.org/Explorer.aspxUsing R-Studio, estimate a regression equation to determine the effect of unemployment,general level, wages and life expectancy at birth for both sexes on the net migration rate.(All codes and regression output should be provided).(i) Write down the regression equation. (ii) Interpret the coefficients and determine which of the individual coefficients in theregression model are statistically significant. In responding, construct and test anyappropriate hypothesis. (iii) Interpret the coefficient of determination.
a) For United States, provide data for the variables below over the years 1993 – 2007:
(i) Net migration rate (per 1,000 population)
(ii) Total fertility rate (live births per woman)
(iii)Unemployment, general level (Thousands)
(iv) Wages
(v) Life expectancy at birth for both sexes combined (years)
Data can be obtained from the UN database http://data.un.org/Explorer.aspx
Using R-Studio, estimate a regression equation to determine the effect of unemployment, general level, wages and life expectancy at birth for both sexes on the net migration rate. (All codes and regression output should be provided).(i) Write down the regression equation. (ii) Interpret the coefficients and determine which of the individual coefficients in theregression model are statistically significant. In responding, construct and test anyappropriate hypothesis. (iii) Interpret the coefficient of determination. (iv) Using the 10% level of significance, determine and discuss whether the overallregression equation…
(a) For United States, provide data for the variables below over the years 1993 – 2007:
(i) Net migration rate (per 1,000 population)
(ii) Total fertility rate (live births per woman)
(iii)Unemployment, general level (Thousands)
(iv) Wages
(v) Life expectancy at birth for both sexes combined (years)
Data can be obtained from the UN database http://data.un.org/Explorer.aspx
Using R-Studio, estimate a regression equation to determine the effect of unemployment, general level, wages and life expectancy at birth for both sexes on the net migration rate. (All codes and regression output should be provided).(b) Using R-Studio redo the regression analysis with the total fertility rate as an additionalindependent variable. (All codes and regression output should be provided).(i) Write down the regression equation. (ii) Use the 5% level of significance, determine and discuss whether the total fertilityrate has a significant impact on the net migration rate in your assigned country.…
Chapter 16 Solutions
Modern Business Statistics with Microsoft Office Excel (with XLSTAT Education Edition Printed Access Card) (MindTap Course List)
Ch. 16.1 - Consider the following data for two variables, x...Ch. 16.1 - Consider the following data for two variables, x...Ch. 16.1 - Prob. 3ECh. 16.1 - A highway department is studying the relationship...Ch. 16.1 - In working further with the problem of exercise 4,...Ch. 16.1 - A study of emergency service facilities...Ch. 16.1 - Home Depot, a nationwide home improvement...Ch. 16.1 - Corvette, Ferrari, and Jaguar produced a variety...Ch. 16.1 - The film Suicide Squad has an average rating of...Ch. 16.2 - In a regression analysis involving 27...
Ch. 16.2 - Prob. 11ECh. 16.2 - The Professional Golfers’ Association of America...Ch. 16.2 - Refer to exercise 12.
Develop an estimated...Ch. 16.2 - A 10-year study conducted by the American Heart...Ch. 16.2 - The average monthly residential gas bill for Black...Ch. 16.5 - Prob. 16ECh. 16.5 - Prob. 17ECh. 16.5 - Prob. 18ECh. 16.5 - Prob. 19ECh. 16.5 - Prob. 20ECh. 16.5 - Prob. 21ECh. 16.5 - Prob. 22ECh. 16.5 - Prob. 23ECh. 16.6 - The following data show the daily closing prices...Ch. 16.6 - Refer to the Cravens data set in Table 16.5. In...Ch. 16 - A sample containing years to maturity and yield...Ch. 16 - Consumer Reports tested 19 different brands and...Ch. 16 - A study investigated the relationship between...Ch. 16 - Refer to the data in exercise 28. Consider a model...Ch. 16 - Refer to the data in exercise 28.
Develop an...Ch. 16 - Prob. 31SECh. 16 - The Ladies Professional Golf Association (LPGA)...Ch. 16 - Wine Spectator magazine contains articles and...
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 Expectancy The following table shows the average life expectancy, in years, of a child born in the given year42 Life expectancy 2005 77.6 2007 78.1 2009 78.5 2011 78.7 2013 78.8 a. Find the equation of the regression line, and explain the meaning of its slope. b. Plot the data points and the regression line. c. Explain in practical terms the meaning of the slope of the regression line. d. Based on the trend of the regression line, what do you predict as the life expectancy of a child born in 2019? e. Based on the trend of the regression line, what do you predict as the life expectancy of a child born in 1580?2300arrow_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_forward(a) For United States, provide data for the variables below over the years 1993 – 2007: (i) Net migration rate (per 1,000 population) (ii) Total fertility rate (live births per woman) (iii)Unemployment, general level (Thousands) (iv) Wages (v) Life expectancy at birth for both sexes combined (years) Data can be obtained from the UN database http://data.un.org/Explorer.aspx Using R-Studio, estimate a regression equation to determine the effect of unemployment, general level, wages and life expectancy at birth for both sexes on the net migration rate. (All codes and regression output should be provided). (iv) Using the 10% level of significance, determine and discuss whether the overall regression equation is statistically significant. In responding, construct and test any appropriate hypothesis. (v) Determine and interpret the confidence interval for the independent variable(s).arrow_forward
- In the simple linear regression equation,the term b1 represents the A)estimated intercept B)explanatory variable C)estimated slope D)estimated or predicted responsearrow_forwardJensen Tire & Auto is deciding whether to purchase a maintenance contract for its newcomputer wheel alignment and balancing machine. Managers feel that maintenance expenseshould be related to usage, and they collected the following information on weeklyusage (hours) and annual maintenance expense (in hundreds of dollars). a. Develop a scatter chart with weekly usage hours as the independent variable. Whatdoes the scatter chart indicate about the relationship between weekly usage and annualmaintenance expense?b. Use the data to develop an estimated regression equation that could be used to predictthe annual maintenance expense for a given number of hours of weekly usage. Whatis the estimated regression model? 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…arrow_forwardCreate the regression equations based on the research model below!arrow_forward
- It is considered that the number of employees in the enterprise affects the number of production. Data are given below. Which of the following is the simple linear regression equation?arrow_forwardA shoe store developed the following estimated regression equation relating sales to inventory investment and advertising expenditures. ŷ = 25 + 10x1 + 8x2 where x1 = inventory investment ($1,000s) x2 = advertising expenditures ($1,000s) y = sales ($1,000s). (a) Predict the sales (in dollars) resulting from a $15,000 investment in inventory and an advertising budget of $11,000. $ ----------------- (b) Interpret b1 and b2 in this estimated regression equation. Sales can be expected to increase by $ ---------------for every dollar increase in inventory investment when advertising expenditure is held constant. Sales can be expected to increase by $-----------------for every dollar increase in advertising expenditure when inventory investment is held constant.arrow_forwardA well-known university is interested in how salary (in thousands of dollars) is predicted from years of service for faculty and administrative staff. Below are the estimated regression equations. Faculty (n = 193): ŷ = 50 + 2.1xAdmin. (n = 179): ŷ = 47 + 2.3x a) How much would a faculty member be earning after 10 years of service? b) In how many years will an administrator earn the same amount as in a)?arrow_forward
- a. find the equation of the regression line? b. the best-predicted crash fatality rate for a year in which there are 500 metric tons of lemon imports is _?_ facilitates per 100,000 population,arrow_forwardA well-known university is interested in how salary (in thousands of dollars) is predicted from years of service for faculty and administrative staff. Below are the estimated regression equations.Faculty (n = 170): ŷ = 60 + 1.1xAdmin. (n = 155): ŷ = 57 + 1.5x a) How much would a faculty member be earning after 5 years of service? b) In how many years will an administrator earn the same amount as in a)?arrow_forward1. The following data give the percentage of women working in five companies in the retail and trade industry. The percentage of management jobs held by women in each company is also shown. % Working 69 48 73 54 61 % Management 51 21 61 51 43 Develop the estimated regression equation by computing the values of b0 (y-intercept) and b1 (slope).Predict the percentage of management jobs held by women in a company that has 65% women employees.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Functions and Change: A Modeling Approach to Coll...AlgebraISBN:9781337111348Author:Bruce Crauder, Benny Evans, Alan NoellPublisher:Cengage Learning
College AlgebraAlgebraISBN:9781305115545Author:James Stewart, Lothar Redlin, Saleem WatsonPublisher:Cengage Learning
Functions and Change: A Modeling Approach to Coll...
Algebra
ISBN:9781337111348
Author:Bruce Crauder, Benny Evans, Alan Noell
Publisher:Cengage Learning
College Algebra
Algebra
ISBN:9781305115545
Author:James Stewart, Lothar Redlin, Saleem Watson
Publisher:Cengage Learning
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