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
Textbook Question
Chapter 16, Problem 27SE
Consumer Reports tested 19 different brands and models of road, fitness, and comfort bikes. Road bikes are designed for long road trips; fitness bikes are designed for regular workouts or daily commutes; and comfort bikes are designed for leisure rides on typically flat roads. The following data show the type, weight (lb.), and price ($) for the 19 bicycles tested (Consumer Reports website, February 2009).
- a. Develop a
scatter diagram with weight as the independent variable and price as the dependent variable. Does a simple linear regression model appear to be appropriate? - b. Develop an estimated multiple regression equation with x = weight and x2 as the two independent variables.
- c. Use the following dummy variables to develop an estimated regression equation that can be used to predict the price given the type of bike: Type_Fitness = 1 if the bike is a fitness bike, 0 otherwise; and Type_Comfort = 1 if the bike is a comfort bike; 0 otherwise. Compare the results obtained to the results obtained in part (b).
- d. To account for possible interaction between the type of bike and the weight of the bike, develop a new estimated regression equation that can be used to predict the price of the bike given the type, the weight of the bike, and any interaction between weight and each of the dummy variables defined in part (c). What estimated regression equation appears to be the best predictor of price? Explain.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionChapter 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.Recommended textbooks for you
- Functions and Change: A Modeling Approach to Coll...AlgebraISBN:9781337111348Author:Bruce Crauder, Benny Evans, Alan NoellPublisher:Cengage LearningGlencoe Algebra 1, Student Edition, 9780079039897...AlgebraISBN:9780079039897Author:CarterPublisher:McGraw HillHolt Mcdougal Larson Pre-algebra: Student Edition...AlgebraISBN:9780547587776Author:HOLT MCDOUGALPublisher:HOLT MCDOUGAL
- Big Ideas Math A Bridge To Success Algebra 1: Stu...AlgebraISBN:9781680331141Author:HOUGHTON MIFFLIN HARCOURTPublisher:Houghton Mifflin Harcourt
Functions and Change: A Modeling Approach to Coll...
Algebra
ISBN:9781337111348
Author:Bruce Crauder, Benny Evans, Alan Noell
Publisher:Cengage Learning
Glencoe Algebra 1, Student Edition, 9780079039897...
Algebra
ISBN:9780079039897
Author:Carter
Publisher:McGraw Hill
Holt Mcdougal Larson Pre-algebra: Student Edition...
Algebra
ISBN:9780547587776
Author:HOLT MCDOUGAL
Publisher:HOLT MCDOUGAL
Big Ideas Math A Bridge To Success Algebra 1: Stu...
Algebra
ISBN:9781680331141
Author:HOUGHTON MIFFLIN HARCOURT
Publisher:Houghton Mifflin Harcourt
Bayes' Theorem 1: Introduction and conditional probability; Author: Dr Nic's Maths and Stats;https://www.youtube.com/watch?v=lQVkXfJ-rpU;License: Standard YouTube License, CC-BY
What is Conditional Probability | Bayes Theorem | Conditional Probability Examples & Problems; Author: ACADGILD;https://www.youtube.com/watch?v=MxOny_1y2Q4;License: Standard YouTube License, CC-BY
Bayes' Theorem of Probability With Tree Diagrams & Venn Diagrams; Author: The Organic Chemistry Tutor;https://www.youtube.com/watch?v=OByl4RJxnKA;License: Standard YouTube License, CC-BY
Bayes' Theorem - The Simplest Case; Author: Dr. Trefor Bazett;https://www.youtube.com/watch?v=XQoLVl31ZfQ;License: Standard Youtube License