Modern Business Statistics with Microsoft Office Excel (with XLSTAT Education Edition Printed Access Card)
6th Edition
ISBN: 9780357228708
Author: David R. Anderson; Dennis J. Sweeney; Thomas A. Williams
Publisher: Cengage Learning US
expand_more
expand_more
format_list_bulleted
Concept explainers
Question
Chapter 15.5, Problem 21E
a.
To determine
Give an interpretation of the coefficients of
b.
To determine
Explain whether multicollinearity explain why the coefficients of
Expert Solution & Answer
![Check Mark](/static/check-mark.png)
Want to see the full answer?
Check out a sample textbook solution![Blurred answer](/static/blurred-answer.jpg)
Students have asked these similar questions
A study was conducted among a smaple of undergraduate students to find the relationship between the number of cups of coffee consumed (x) and
level of anxiety (y). The following least squares regression equation was obtained as a result of the study:
ý = 0.3 + 0.0342z
The obtained regression equation implies which of the following?
Each cup of coffee consumed increases anxiety level by 30.0%
Each cup of coffee consumed increases anxiety level by an average amoint of 3.42%
Each cup of coffee consumed increases anxiety level by exactly 3.42%
Anxiety level increases by 1 unit as a result of consuming 0.3 cups of coffee
The relationship between number of beers consumed (x) and blood alcohol content (y) was studied in 16 male college students by using least squares regression. The following regression equation was obtained from this study: y = -0.0127 + 0.0180x. Suppose that the legal limit to drive is a blood alcohol content of 0.08. If Ricky consumed 5 beers the model would predict that he would be:
The relationship between number of beers consumed (x) and blood alcohol content (y) was studied in 16 male college students by using least squares regression. The following regression equation was obtained from this study: y-hat = -0.0127 + 0.0180x. Wendall drinks 4 beers and has a blood alcohol level of .08. What is Wendall’s residual?
Chapter 15 Solutions
Modern Business Statistics with Microsoft Office Excel (with XLSTAT Education Edition Printed Access Card)
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
- Find the equation of the regression line for the following data set. x 1 2 3 y 0 3 4arrow_forwardIf your graphing calculator is capable of computing a least-squares sinusoidal regression model, use it to find a second model for the data. Graph this new equation along with your first model. How do they compare?arrow_forwardCellular Phone Subscribers The table shows the numbers of cellular phone subscribers y in millions in the United States from 2008 through 2013. Source: CTIA- The Wireless Association Year200820092010201120122013Number,y270286296316326336 (a) Find the least squares regression line for the data. Let x represent the year, with x=8 corresponding to 2008. (b) Use the linear regression capabilities of a graphing utility to find a linear model for the data. How does this model compare with the model obtained in part a? (c) Use the linear model to create a table of estimated values for y. Compare the estimated values with the actual data.arrow_forward
- The relationship between a number of beers consumed (x) and blood alcohol content (y) was studied in 16 male college students by using least squares regression. The following regression equation was obtained from this study: ?̂ = -0.0127 + 0.0180x The above equation implies that: each beer consumed increases blood alcohol by 1.27% on average it takes 1.8 beers to increase blood alcohol content by 1% each beer consumed increases blood alcohol by an average of the amount of 1.8% each beer consumed increases blood alcohol by exactly 0.018arrow_forwardSherry rents long boards. She records the height in cm and length of the board in cm that the customers rented. She notices a fairly linear relationship so she calculates a least squares regression equation for predicting board length from customer height: y=1/3x+1/3 What is the residual of a customer with a height of 155 cm who rents a 51 cm board?arrow_forwardThe following estimated regression equation was developed for a model involving two independent variables. ŷ = 40.7 + 8.63x, + 2.71x2 After x, was dropped from the model, the least squares method was used to obtain an estimated regression equation involving only x, as an independent variable. ŷ = 42.0 + 9.01x, (a) Give an interpretation of the coefficient of x, in both models. In the two independent variable case, the coefficient of x, represents the expected change in y corresponding to a ---Select-- v unit --Select-- v in x, when x, is held constant. In the single independent variable case, the coefficient of x, represents the expected change in y corresponding to a -Select-- v unit increase in x,. (b) Could multicollinearity explain why the coefficient of x, differs in the two models? If so, how? ---Select--- v. If x, and x, are correlated, one would expect a change in x, to be --Select-- va change in x2.arrow_forward
- The relationship between number of beers consumed (x) and blood alcohol content (y) was studied in 16 male college students by using least squares regression. The following regression equation was obtained from this study: y-hat = -0.0127 + 0.0180x The above equation implies that: each beer consumed increases blood alcohol by .0127 on average it takes 1.8 beers to increase blood alcohol content by .01 After consuming 1 beer, blood alcohol equals .0180. each beer consumed increases blood alcohol by 0.018arrow_forwardThe data in the table represent the weights of various domestic cars and their miles per gallon in the city for the 2008 model year. For these data, the least-squares regression line is y = - 0.006x+ 41.337. A twelfth car weighs 3,425 pounds and gets 12 miles per gallon. (a) Compute the coefficient of determination of the expanded data set. What effect does the addition of the twelfth car to the data set have on R? (b) Is the point corresponding to the twelfth car influential? Is it an outlier? Click the icon to view the data table. Data Table ..... Weight (pounds), x Miles per (a) The coefficient of determination of the expanded data set is R = %. Gallon, y (Round to one decimal place as needed.) Car 1 3,771 22 Car 2 ,990 19 Car 3 3,534 20 Car 4 3,172 24 Car 5 2,579 27 Car 6 3,730 20 Car 7 2,605 25 Car 8 3,777 19 Car 9 3,308 19 Car 10 2,997 26 Car 11 2,751 27arrow_forwardThe data in the table represent the weights of various domestic cars and their miles per gallon in the city for the 2008 model year. For these data, the least-squares regression line is y = - 0.006x + 43.875. A twelfth car weighs 3,425 pounds and gets 13 miles per gallon. (a) Compute the coefficient of determination of the expanded data set. What effect does the addition of the twelfth car to the data set have on R? (b) Is the point corresponding to the twelfth car influential? Is it an outlier? Data Table Click the icon to view the data table. ..... (a) The coefficient of determination of the expanded data set is R = %. Weight (pounds), x Miles per (Round to one decimal place as needed.) Gallon, y Car 1 3,770 20 Car 2 3,980 19 Car 3 3,530 19 Car 4 3,175 22 Car 5 2,580 27 Car 6 3,729 20 Car 7 2,607 26 Car 8 3,776 19 Car 9 3,311 22 Car 10 2,999 27 Car 11 2,755 27arrow_forward
- An independent mail delivery service wants to study factors that affect the daily gas usage of its delivery trucks. Using data collected from different trucks on various days, a company analyst uses software to fit a regression model of the following form. y = 13 +8x, -1.1x, + 2x3 +0.04.x, In this model are the following variables. y= volume of gasoline used (in gallons) X1 weight of truck (in tons) x, = tire pressure (in psi, pounds per square inch) weight of initial pačkage load (in hundreds of pounds) X4 total distance driven while delivering packages (in miles) Answer the questions below for the interpretation of the coefficient of x, in this model. (a) Holding the other variables fixed, what is the average change in daily fuel used for each additional ton that a truck weighs? gallon(s) (b) Is this change an increase or a decrease? O increase O decrease Activate Windoarrow_forwardThe data in the table represent the weights of various domestic cars and their miles per gallon in the city for the 2008 model year. For these data, the least-squares regression line is y = - 0.006x + 43.875. A twelfth car weighs 3,425 pounds and gets 13 miles per gallon. (a) Compute the coefficient of determination of the expanded data set. What effect does the addition of the twelfth car to the data set have on R2? (b) Is the point corresponding to the twelfth car influential? Is it an outlier? Data Table Click the icon to view the data table. Weight |(pounds), x Miles per Gallon, y Car 1 3,770 20 Car 2 3,980 19 Car 3 3,530 19 Car 4 3,175 22 Car 5 2,580 27 Car 6 3,729 20 Car 7 2,607 26 Car 8 3,776 19 Car 9 3,311 22 Car 10 2,999 27 Car 11 2,755 27arrow_forwardThe weight (in pounds) and height (in inches) for a child were measured every few months over a two-year period. The results are displayed in the scatterplot. The equation ŷ = 17.4 + 0.5x is called the least-squares regression line because it is least able to make accurate predictions for the data. A Child's Weight and Height makes the strongest association between weight and 40 height. 36 minimizes the sum of the squared distances from the actual y-value to the predicted y-value. 32 maximizes the sum of the squared distances from the actual y-value to the predicted y-value. 20 24 20 6 8 10 12 14 16 18 20 22 24 26 28 30 32 34 36 38 40 42 Weight (Pounds) Height (Inches)arrow_forward
arrow_back_ios
arrow_forward_ios
Recommended textbooks for you
- Glencoe Algebra 1, Student Edition, 9780079039897...AlgebraISBN:9780079039897Author:CarterPublisher:McGraw HillElementary Linear Algebra (MindTap Course List)AlgebraISBN:9781305658004Author:Ron LarsonPublisher:Cengage Learning
- Trigonometry (MindTap Course List)TrigonometryISBN:9781305652224Author:Charles P. McKeague, Mark D. TurnerPublisher:Cengage LearningAlgebra & Trigonometry with Analytic GeometryAlgebraISBN:9781133382119Author:SwokowskiPublisher:CengageAlgebra and Trigonometry (MindTap Course List)AlgebraISBN:9781305071742Author:James Stewart, Lothar Redlin, Saleem WatsonPublisher:Cengage Learning
![Text book image](https://www.bartleby.com/isbn_cover_images/9781337282291/9781337282291_smallCoverImage.gif)
![Text book image](https://www.bartleby.com/isbn_cover_images/9780079039897/9780079039897_smallCoverImage.jpg)
Glencoe Algebra 1, Student Edition, 9780079039897...
Algebra
ISBN:9780079039897
Author:Carter
Publisher:McGraw Hill
![Text book image](https://www.bartleby.com/isbn_cover_images/9781305658004/9781305658004_smallCoverImage.gif)
Elementary Linear Algebra (MindTap Course List)
Algebra
ISBN:9781305658004
Author:Ron Larson
Publisher:Cengage Learning
![Text book image](https://www.bartleby.com/isbn_cover_images/9781305652224/9781305652224_smallCoverImage.gif)
Trigonometry (MindTap Course List)
Trigonometry
ISBN:9781305652224
Author:Charles P. McKeague, Mark D. Turner
Publisher:Cengage Learning
Algebra & Trigonometry with Analytic Geometry
Algebra
ISBN:9781133382119
Author:Swokowski
Publisher:Cengage
![Text book image](https://www.bartleby.com/isbn_cover_images/9781305071742/9781305071742_smallCoverImage.gif)
Algebra and Trigonometry (MindTap Course List)
Algebra
ISBN:9781305071742
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