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
Videos
Textbook Question
Chapter 14.2, Problem 14E
Using a global-positioning-system (GPS)-based navigator for your car, you enter a destination and the system will plot a route, give spoken turn-by-turn directions, and show your progress along the route. Today, even budget units include features previously available only on more expensive models. Consumer Reports conducted extensive tests of GPS-based navigators and developed an overall rating based on factors such as ease of use, driver information, display, and battery life. The following data show the price and rating for a sample of 20 GPS units with a 4.3-inch screen that Consumer Reports tested (Consumer Reports website, April 17, 2012).
- a. Develop a
scatter diagram with price as the independent variable. - b. What does the scatter diagram developed in part (a) indicate about the relationship between the two variables?
- c. Use the least squares method to develop the estimated regression equation.
- d. Predict the rating for a GPS system with a 4.3-inch screen that has a price of $200.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
A national park conducts a study on the behaviour of their leopards. A few of the park's leopards are registered and receive a GPS device which allows measuring the position of the leopard. Use this example to describe the following concepts: population, sample, observation, value, and variable.
An business reviews data on the daily amount of calls it receives. Are the data discrete or continous?
Name the forecasting methods
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
- Review the data in the Table 1, entitled, "Average Annual Salaries for Bachelor of Science Graduates, Summer 2016-Spring 2017". Using this data, create a chart (with a title, labeled axes, and a legend) comparing the average salaries that you could use to guide high school students who want salary influence the type of engineering major that they will choose. Consider, which fields tend to make the most money? Write a recommendation letter addressed to a high school student who wants to select an engineering field based on the salary; using a comparison of the data, recommend which majors they should most closely consider. Engineering - Average Annual Salaries & Hourly Wages for Undergraduates by Program, Summer 2016-Spring 2017 Average Annual Salaries for Bachelor of Science Graduates, Summer 2016-Spring 2017 | Offers/Acceptances with Salary Information 31 Average Annual Salaries $66,356 All Program Aeronautical & Astronautical Engineering Aviation Biomedical Engineering Chemical…arrow_forwardMost analysts focus on the cost of tuition as the way to measure the cost of a college education. But incidentals, such as textbook costs, are rarely considered. A researcher at Drummand University wishes to estimate the textbook costs of first-year students at Drummand. To do so, she monitored the textbook cost of 250 first-year students and found that their average textbook cost was $300 per semester. Identify the variable of interest to the researcher. Select one: a. The age of Drummand University students. b. The textbook cost of first-year Drummand University students. c. The year in school of Drummand University students. d. The cost of incidental expenses of Drummand University students.arrow_forwardBicycling World, a magazine devoted to cycling, reviews hundreds of bicycles throughout the year. Its "Road-Race" category contains reviews of bicycles used by riders primarily interested in racing. One of the most important factors in selecting a bicycle for racing is the weight of the bicycle. The following data show the weight (pounds) and price ($) for ten racing bicycles reviewed by the magazine. Model Weight Price Fierro 7B 17.9 2200 HX 5000 16.2 6350 Durbin Ultralight 16 8490 Schmidt 16.2 6300 WSilton Advanced 17.5 4100 bicyclette vélo 15.2 8500 Supremo Team 16.5 6200 XTC Racer 17.6 2680 D’Onofrio Pro 17.5 4500 Americana #6 13.6 8200 Use the data to develop an estimated regression equation that could be used to estimate the price for a bicycle given its weight. What is the estimated regression model? Group of answer choices y = -1512x + 30578 y = 1351x + 26327 y = -1161x + 24489 y = -1457x + 27903 y = 1341x + 25176arrow_forward
- Recently, management at Oak Tree Golf Course received a few complaints about the condition of the greens. Several players complained that the greens are too fast. Rather than react to the comments of just a few, the Golf Association conducted a survey of 100 male and 100 female golfers. The survey results are summarized here. Excel File: data02-31.xlsx Male Golfers Male Green Condition Handicap Under 15 15 or more 25 25 a. Complete the crosstabulation shown below. Green Condition Gender Too Fast Fine Female 35 40 Too Fast 10 65 60 Fine 40 Total 100 100 Female Golfers 200 Green Condition Handicap Under 15 15 or more Too Fast 1 Note: This exercise is an example of Simpson's Paradox. 39 Fine 9 Total 75 125 Which group shows the highest percentage saying that the greens are too fast? Females, at 40% b. Refer to the initial crosstabulations. For those players with low handicaps (better players), which group (male or female) shows the highest percentage saying the greens are too fast? For…arrow_forwardWhile the mail-order DVD rental market has slowed with the advent of streaming, mail-order is still the only way to find rare movies. Raredvds.biz is considering moving into the rental business after considerable success selling DVDs. To gauge their customer service, they are considering the case of the 1980 film The Monster Club featuring Vincent Price. Raredvds.biz expects to have one copy of the DVD. Based on data collected from customers, Raredvds.biz believes that the average time between orders for the film will be about 10 days with a coefficient of variation of one. Using customer data, the company also believes that including shipping time, both ways, the DVD will on average spend seven days in service, with a coefficient of variation of one. How long does a customer wait on average before being shipped the DVD?arrow_forwardThe r code for side by side boxplot of vitamind v newage and vitamin d v country. Scatterplot code for relationship between vitamin d level and age.arrow_forward
- Lovely Lawns, Inc., intends to use sales of lawn fertilizer to predict lawn mower sales. The store manager estimates a probable six- week lag between fertilizer sales and mower sales. The pertinent data are: Fertilizer Number of Fertilizer Number of Sales Mowers Sold Sales Mowers Sold Period (tons) (six-week lag) Period (tons) (six-week lag) 1 1.6 10 8. 1.3 7 1.3 8 1.7 10 3 1.8 11 10 1.2 6. 4 2.0 12 1.9 11 2.2 12 12 1.4 1.6 9. 13 1.7 10 7 1.5 14 1.6 a. Determine the correlation between the two variables. Does it appear that a relationship exists between these variables will yield good predictions? (Do not round intermediate calculations and round your answer to 3 decimal places.) it appears that a positive v relationship exists between these variables. b. Obtain a linear regression line for the data. (Negative values should be indicated by a minus sign. Do not round intermediate calculations and round your answers to 3 decimal places.) Y = O Xi + c. Predict expected lawn mower sales…arrow_forwardResearchers initiated a long-term study of the population of American black bears. One aspect of the study was to develop a model that could be used to predict a bear's weight (since it is not practical to weigh bears in the field). One variable thought to be related to weight is the length of the bear. The accompanying data represent the lengths and weights of 12 American black bears. Complete parts (a) through (d) below. Click the icon to view the data table. Click the icon to view the critical values table. ..... (a) Which variable is the explanatory variable based on the goals of the research? O A. The number of bears B. The weight of the bear O C. The length of the bear (b) Draw a scatter diagram of the data. Choose the correct graph below. O A. O B. O C. D. A Weight (kg) 180- AWeight (kg) 180- ALength (cm) 180- A Weight (kg) 180- 40- 100 40- 100 Length (cm) 40- 100 40- 100 200 200 200 200 Length (cm) Weight (kg) Length (cm) (c) Determine the linear correlation coefficient between…arrow_forwardThe Environmental Protection Agency records data on the fuel economy of many different makes of cars. It is interested in determining if one could predict the mileage of the car (in miles per gallon) from the weight of the car (in Ibs). The response variable in this study is mileage of the car. car. O fuel economy. weight of the cararrow_forward
- 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 racing bikes reviewed by the magazine (Bicycling website). The datafile logo. Brand Weight Price ($) FELT F5 17.8 2100 PINARELLO Paris 16.1 6250 ORBEA Orca GDR 14.9 8370 EDDY MERCKX EMX-7 15.9 6200 BH RC1 Ultegra 17.2 4000 BH Ultralight 386 13.1 8600 CERVELO S5 Team 16.2 6000 GIANT TCR Advanced 2 17.1 2580 WILIER TRIESTINA Gran Turismo 17.6 3400 SPECIALIZED S-Works Amira SL4 14.1 8000 a. Use the data to develop an estimated regression equation that could be used to estimate the price for a bike given the weight. If required, enter negative values as negative numbers. price + weight (to whole…arrow_forwardRange of ankle motion is a contributing factor to falls among the elderly. Suppose a team of researchers is studying how compression hosiery, typical shoes, and medical shoes affect range of ankle motion. In particular, note the variables Barefoot and Footwear2. Barefoot represents a subject's range of ankle motion (in degrees) while barefoot, and Footwear2 represents their range of ankle motion (in degrees) while wearing medical shoes. Use this data and your preferred software to calculate the equation of the least-squares linear regression line to predict a subject's range of ankle motion while wearing medical shoes, ?̂ , based on their range of ankle motion while barefoot, ? . Round your coefficients to two decimal places of precision. ?̂ = A physical therapist determines that her patient Jan has a range of ankle motion of 7.26°7.26° while barefoot. Predict Jan's range of ankle motion while wearing medical shoes, ?̂ . Round your answer to two decimal places. ?̂ = Suppose Jan's…arrow_forwardThe accompanying histogram is for pulse rates for 125 people. Convert the vertical axis to relative frequency and shows the values that would replace each of the values on the vertical axis.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Glencoe Algebra 1, Student Edition, 9780079039897...AlgebraISBN:9780079039897Author:CarterPublisher:McGraw Hill
Holt 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...AlgebraISBN:9781337111348Author:Bruce Crauder, Benny Evans, Alan NoellPublisher: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
Functions and Change: A Modeling Approach to Coll...
Algebra
ISBN:9781337111348
Author:Bruce Crauder, Benny Evans, Alan Noell
Publisher:Cengage Learning
What Are Research Ethics?; Author: HighSchoolScience101;https://www.youtube.com/watch?v=nX4c3V23DZI;License: Standard YouTube License, CC-BY
What is Ethics in Research - ethics in research (research ethics); Author: Chee-Onn Leong;https://www.youtube.com/watch?v=W8Vk0sXtMGU;License: Standard YouTube License, CC-BY