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 14.5, Problem 31E
Significance of Racing Bike Weight on Price. In exercise 20, data on x = weight (pounds) and y = price ($) for 10 road-racing bikes provided the estimated regression equation
20. Price and Weight of Bicycles. Bicycling, the world’s leading cycling magazine, reviews hundreds of bicycles throughout the year. Their “Road-Race” category contains reviews of bikes used by riders primarily interested in racing. One of the most important factors in selecting a bike for racing is the weight of the bike. The following data show the weight (pounds) and price ($) for 10 racing bikes reviewed by the magazine (Bicycling website).
- a. Use the data to develop an estimated regression equation that could be used to estimate the price for a bike given the weight.
- b. Compute r2. Did the estimated regression equation provide a good fit?
- c. Predict the price for a bike that weighs 15 pounds.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
A researcher investigated the relationship between family income and savings. Using data from 15 families, the computed r between income and savings was found to be 0.76. The researcher wants to test if there is a significant relationship between the two variables at 5% level of significance and create a regression equation to predict the possible savings given the income of the family.
Interpret the computed r value.
Test if there is a significant relationship between the two variables at 5% level of significance
A 10-year study conducted by the American Heart Association provided data on how age, blood pressure, and smoking relate to the risk of strokes (Dataset "Stroke"). Risk is interpreted as the probability (times 100) that a person will have a stroke over the next 10-year period. For the smoker variable, 1 indicates a smoker and 0 indicates a nonsmoker.
a. Develop an estimated regression equation that can be used to predict the risk of stroke given the age and blood-pressure level.
b. Consider adding two independent variables to the model developed in part (a), one for the interaction between age and blood-pressure level and the other for whether the person is a smoker. Develop an estimated regression equation using these four independent variables.
c. At a 0.05 level of significance, test to see whether the addition of the interaction term and the smoker variable contributes significantly to the estimated regression equation developed in part (a).
d. Refer to the model developed in part…
An educational consultant collected data from 10 school districts. Measures were taken of the number of hours per week of instructional time that were allocated to reading instruction at the district level (X) and the district mean achievement in reading (Y). Summary values from the raw data are given as follows:
∑X= 58, ∑Y= 60, ∑X²= 410 ∑Y²= 398, ∑XY= 299
Set up the regression equation for the prediction of Y from X.
Determine the standard error of estimate for predicting Y.
If X = 9, what will be the predicted value of Y?
Determine 95% confidence interval for the predicted value of Y for X = 9.
Chapter 14 Solutions
Modern Business Statistics with Microsoft Office Excel (with XLSTAT Education Edition Printed Access Card) (MindTap Course List)
Ch. 14.2 - Given are five observations for two variables, x...Ch. 14.2 - Given are five observations for two variables, x...Ch. 14.2 - Given are five observations collected in a...Ch. 14.2 - Retail and Trade: Female Managers. The following...Ch. 14.2 - Production Line Speed and Quality Control. Brawdy...Ch. 14.2 - The National Football League (NFL) records a...Ch. 14.2 - Sales Experience and Performance. A sales manager...Ch. 14.2 - Broker Satisfaction. The American Association of...Ch. 14.2 - Companies in the U.S. car rental market vary...Ch. 14.2 - Age and the Price of Wine. For a particular red...
Ch. 14.2 - Laptop Ratings. To help consumers in purchasing a...Ch. 14.2 - Stock Beta. In June of 2016, Yahoo Finance...Ch. 14.2 - Distance and Absenteeism. A large city hospital...Ch. 14.2 - Using a global-positioning-system (GPS)-based...Ch. 14.3 - 15. The data from exercise 1...Ch. 14.3 - The data from exercise 2 follow.
The estimated...Ch. 14.3 - Prob. 17ECh. 14.3 - Price and Quality of Headphones. The following...Ch. 14.3 - Sales Experience and Sales Performance. In...Ch. 14.3 - Price and Weight of Bicycles. Bicycling, the...Ch. 14.3 - Cost Estimation. An important application of...Ch. 14.3 - 22. Refer to exercise 9, where the following data...Ch. 14.5 - The data from exercise 1 follow.
Compute the mean...Ch. 14.5 - The data from exercise 2 follow.
Compute the mean...Ch. 14.5 - The data from exercise 3 follow.
What is the...Ch. 14.5 - Prob. 26ECh. 14.5 - To identify high-paying jobs for people who do not...Ch. 14.5 - Broker Satisfaction Conclusion. In exercise 8,...Ch. 14.5 - Cost Estimation Conclusion. Refer to exercise 21,...Ch. 14.5 - Significance of Fleet Size on Rental Car Revenue....Ch. 14.5 - Significance of Racing Bike Weight on Price. In...Ch. 14.6 - 32. The data from exercise 1...Ch. 14.6 - 33. The data from exercise 2...Ch. 14.6 - Prob. 34ECh. 14.6 - 35. The following data are the monthly salaries y...Ch. 14.6 - 36. In exercise 7, the data on y = annual sales ($...Ch. 14.6 - In exercise 5, the following data on x = the...Ch. 14.6 - Prob. 38ECh. 14.6 - 39. In exercise 12, the following data on x =...Ch. 14.7 - The commercial division of a real estate firm...Ch. 14.7 - Following is a portion of the regression output...Ch. 14.7 - Prob. 43ECh. 14.7 - Auto Racing Helmet. Automobile racing,...Ch. 14.8 - Prob. 45ECh. 14.8 - Prob. 46ECh. 14.8 - Prob. 47ECh. 14.8 - Prob. 48ECh. 14.8 - Prob. 49ECh. 14.9 - Consider the following data for two variables, x...Ch. 14.9 - Prob. 51ECh. 14.9 - Predicting Charity Expenses. Charity Navigator is...Ch. 14.9 - Many countries, especially those in Europe, have...Ch. 14.9 - Valuation of a Major League Baseball Team. The...Ch. 14 - The Dow Jones Industrial Average (DJIA) and the...Ch. 14 - Home Sire and Price. Is the number of square feet...Ch. 14 - Online Education. One of the biggest changes in...Ch. 14 - Machine Maintenance. Jensen Tire & Auto is in the...Ch. 14 - Bus Maintenance. The regional transit authority...Ch. 14 - Studying and Grades. A marketing professor at...Ch. 14 - Used Car Mileage and Price. The Toyota Camry is...Ch. 14 - One measure of the risk or volatility of an...Ch. 14 - As part of a study on transportation safety, the...Ch. 14 - Consumer Reports tested 166 different...Ch. 14 - When trying to decide what car to buy, real value...Ch. 14 - Buckeye Creek Amusement Park is open from the...
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
- A researcher is hired to investigate the relationship between the number of unauthorized days that employees are absent per year and the distance in miles between home and work for the employees. A sample of 10 employees was chosen and the results are listed in the chart below. Use the proper Data Analysis function in Excel to computethe regression equation needed to predict the number of missed days that could be expected foremployees who live certain distances away from the workplace. Distance to Work (miles): 1, 3, 4, 6, 9, 10, 12, 14, 14, 18 Number of Days Absent: 9, 6, 7, 7, 6, 4, 5, 3, 4, 2arrow_forwardA car dealer wants to estimate the price of a used car based on the age of the car and the mileage. Based on a sample of 20 cars, she determines the sample regression equation that predicts price taxes on the basis of the age (in years) of the number of miles is Price=21,510-1230Age-0.035 Miles (a) If the age of the car was fixed and the mileage was increased by 10,000, would the price increase or decrease and by how much? (b) Predict the selling price of a five-year-old car with 65,000 miles. (Round your answers to the nearest whole number.)arrow_forwardThe table below gives the number of hours five randomly selected students spent studying and their corresponding midterm exam grades. Using this data, consider the equation of the regression line, y^=b0+b1x, for predicting the midterm exam grade that a student will earn based on the number of hours spent studying. Keep in mind, the correlation coefficient may or may not be statistically significant for the data given. Remember, in practice, it would not be appropriate to use the regression line to make a prediction if the correlation coefficient is not statistically significant. Hours Studying 1 2 4 5 6 Midterm Grades 67 68 70 79 87 Summation Table x y xy x2 y2 Student 1 1 67 67 1 4489 Student 2 2 68 136 4 4624 Student 3 4 70 280 16 4900 Student 4 5 79 395 25 6241 Student 5 6 87 522 36 7569 Sum 18 371 1400 82 27823 Step 1 of 6: Find the estimated slope. Round your answer to three decimal places. Step 2 of 6: Find the estimated y-intercept. Round your…arrow_forward
- A researcher examined the relationship between the annual tax amount paid by the construction company owners and the total expense items spent for the construction with regression analysis and calculated the regression line estimation as Y=6+2X. According to this; Write the interpretations of the cutoff and regression parameters, respectively, in your OWN SENTENCES in a statistically appropriate way over the tax amount and expenses.arrow_forwardThe table below gives the number of absences and the overall grade in the class for seven randomly selected students. Based on this data, consider the equation of the regression line, yˆ=b0+b1x�^=�0+�1�, for using the number of absences to predict a student's overall grade in the class. Keep in mind, the correlation coefficient may or may not be statistically significant for the data given. Remember, in practice, it would not be appropriate to use the regression line to make a prediction if the correlation coefficient is not statistically significant. Number of Absences Grade1 3.72 3.33 3.14 2.96 2.47 2.28 1.9arrow_forwardThe correlation between first year college GPA and high school GPA is 0.683. If a simple linear regression was conducted to predict first year college GPA from high school GPA what does the correlation tell us about the fit of the model?arrow_forward
- The following data table shows the historical data for the first semester 2020, of the amount of sales of the company "IRC", which sells sneakers. Utilizing multiple lineal regression (as shown on the image), find an equation that estimates the number of sneakers sold by the company, based on advertising and revenue. Also, determine the standard error of estimation, the coefficient of determination, and the correlation coefficient. Write down what was the quantity in thousands sold in July if the amount of ads was 8 and the income for each unit was $135arrow_forwardThe table below gives the number of hours ten randomly selected students spent studying and their corresponding midterm exam grades. Using this data, consider the equation of the regression line, yˆ=b0+b1x, for predicting the midterm exam grade that a student will earn based on the number of hours spent studying. Keep in mind, the correlation coefficient may or may not be statistically significant for the data given. Remember, in practice, it would not be appropriate to use the regression line to make a prediction if the correlation coefficient is not statistically significant. Hours Studying 0 0.5 1.5 2 2.5 3 4.5 5 5.5 6 Midterms Grades 60 63 64 69 73 76 82 90 91 95 Step 1 of 6: Find the estimated slope. Round your answer to three decimal places. Step 2 of 6: Find the estimated y-intercept. Round your answer to three decimal places. Step 3 of 6: Determine if the statement "All points predicted by the linear model fall on the same line" is true or false Step 4 of 6:…arrow_forwardThe table below gives the number of hours ten randomly selected students spent studying and their corresponding midterm exam grades. Using this data, consider the equation of the regression line, y^=b0+b1x, for predicting the midterm exam grade that a student will earn based on the number of hours spent studying. Keep in mind, the correlation coefficient may or may not be statistically significant for the data given. Remember, in practice, it would not be appropriate to use the regression line to make a prediction if the correlation coefficient is not statistically significant. Hours Studying 0 1 2 2.5 3 3.5 4 4.5 5.5 6 Midterm Grades 61 64 65 66 71 79 84 88 94 98 Summation Table x y xy x2 y2 Student 1 0.0 61 0.0 0.00 3721 Student 2 1.0 64 64.0 1.00 4096 Student 3 2.0 65 130.0 4.00 4225 Student 4 2.5 66 165.0 6.25 4356 Student 5 3.0 71 213.0 9.00 5041 Student 6 3.5 79 276.5 12.25 6241 Student 7 4.0 84 336.0 16.00 7056 Student 8 4.5 88 396.0 20.25 7744…arrow_forward
- At a .01 level of significance is there sufficient evidence to conclude that the number of books sold is related to the number of registered students in a straight-line manner, and give the regression equation.arrow_forwardThe table below gives the number of hours seven randomly selected students spent studying and their corresponding midterm exam grades. Using this data, consider the equation of the regression line, yˆ=b0+b1x�^=�0+�1�, for predicting the midterm exam grade that a student will earn based on the number of hours spent studying. Keep in mind, the correlation coefficient may or may not be statistically significant for the data given. Remember, in practice, it would not be appropriate to use the regression line to make a prediction if the correlation coefficient is not statistically significant. Hours Studying 1 2 3 3.5 4 4.5 5 Midterm Grades 60 66 73 76 78 84 90 Table Copy Data Step 1 of 6: Find the estimated slope. Round your answer to three decimal places.arrow_forwardThe table below gives the number of hours seven randomly selected students spent studying and their corresponding midterm exam grades. Using this data, consider the equation of the regression line, yˆ=b0+b1x�^=�0+�1�, for predicting the midterm exam grade that a student will earn based on the number of hours spent studying. Keep in mind, the correlation coefficient may or may not be statistically significant for the data given. Remember, in practice, it would not be appropriate to use the regression line to make a prediction if the correlation coefficient is not statistically significant. Hours Studying 11 1.51.5 2.52.5 33 44 4.54.5 55 Midterm Grades 6666 6969 7575 7979 9090 9595 9898 Find the estimated slope. Round your answer to three decimal places. Find the estimated y-intercept. Round your answer to three decimal places. Determine if the statement "Not all points predicted by the linear model fall on the same line" is true or false.…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
MATLAB: An Introduction with ApplicationsStatisticsISBN:9781119256830Author:Amos GilatPublisher:John Wiley & Sons Inc
Probability and Statistics for Engineering and th...StatisticsISBN:9781305251809Author:Jay L. DevorePublisher:Cengage Learning
Statistics for The Behavioral Sciences (MindTap C...StatisticsISBN:9781305504912Author:Frederick J Gravetter, Larry B. WallnauPublisher:Cengage Learning
Elementary Statistics: Picturing the World (7th E...StatisticsISBN:9780134683416Author:Ron Larson, Betsy FarberPublisher:PEARSON
The Basic Practice of StatisticsStatisticsISBN:9781319042578Author:David S. Moore, William I. Notz, Michael A. FlignerPublisher:W. H. Freeman
Introduction to the Practice of StatisticsStatisticsISBN:9781319013387Author:David S. Moore, George P. McCabe, Bruce A. CraigPublisher:W. H. Freeman
MATLAB: An Introduction with Applications
Statistics
ISBN:9781119256830
Author:Amos Gilat
Publisher:John Wiley & Sons Inc
Probability and Statistics for Engineering and th...
Statistics
ISBN:9781305251809
Author:Jay L. Devore
Publisher:Cengage Learning
Statistics for The Behavioral Sciences (MindTap C...
Statistics
ISBN:9781305504912
Author:Frederick J Gravetter, Larry B. Wallnau
Publisher:Cengage Learning
Elementary Statistics: Picturing the World (7th E...
Statistics
ISBN:9780134683416
Author:Ron Larson, Betsy Farber
Publisher:PEARSON
The Basic Practice of Statistics
Statistics
ISBN:9781319042578
Author:David S. Moore, William I. Notz, Michael A. Fligner
Publisher:W. H. Freeman
Introduction to the Practice of Statistics
Statistics
ISBN:9781319013387
Author:David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:W. H. Freeman
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