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.6, Problem 39E
In exercise 12, the following data on x = average daily hotel room rate and y = amount spent on entertainment (The Wall street Journal, August 18, 2011) lead to the estimated regression equation ŷ = 17.49 + 1.0334x. For these data SSE = 1541.4.
| City | Room Rate ($) |
Entertainment ($) |
| Boston | 148 | 161 |
| Denver | 96 | 105 |
| Nashville | 91 | 101 |
| New Orleans | 110 | 142 |
| Phoenix | 90 | 100 |
| San Diego | 102 | 120 |
| San Francisco | 136 | 167 |
| San Jose | 90 | 140 |
| Tampa | 82 | 98 |
- a. Predict the amount spent on entertainment for a particular city that has a daily room rate of $89.
- b. Develop a 95% confidence interval for the
mean amount spent on entertainment for all cities that have a daily room rate of $89. - c. The average room rate in Chicago is $128. Develop a 95% prediction interval for the amount spent on entertainment in Chicago.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Listed below are foot lengths (mm) and heights (mm) of males. Find the regression equation, letting foot length be the
predictor (x) variable. Find the best predicted height of a male with a foot length of 272.8 mm. How does the result
compare to the actual height of 1776 mm?
Foot Length 281.9 278.3 252.9 258.7 279.2 258.0 274.2 262.3
Height
1785.0 1771.0 1675.9 1646.2 1858.8 1709.6 1788.7 1736.6
The regression equation is ŷ= + (x
y=
(Round the y-intercept to the nearest integer as needed. Round the slope to two decimal places as needed.)
YouTube no
New Helluva Boss
Recommended Z
Listed below are foot lengths (mm) and heights (mm) of males. Find the regression equation, letting foot length be the predictor (x) variable. Find the best predicted height of a male with a foot length of 273.1 mm. How does the result compare to the actual height of 1776 mm?
Foot Length 282.0 278.0 252.7 259.0 278.9 257.8 274.1 262.3
Height
1785.0 1770.9 1676.3 1646.0 1859.3 1710.1 1789.3 1737.2
The regression equation is ŷ = + (x.
(Round the y-intercept to the nearest integer as needed. Round the slope to two decimal places as needed.)
←
The U.S. Postal Service is attempting to reduce the number of complaints made by the public against its workers. To facilitate this task, a staff analyst for the service regresses the number of complaints lodged against an employee last year on the hourly wage of the employee for the year. The analyst ran a simple linear regression in SPSS. The results are shown below.
What proportion of variation in the number of complaints can be explained by hourly wages?
From the results shown above, write the regression equation
If wages were increased by $1.00, what is the expected effect on the number of complaints received per employee?
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
- Does Table 1 represent a linear function? If so, finda linear equation that models the data.arrow_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_forwardFind the mean hourly cost when the cell phone described above is used for 240 minutes.arrow_forward
- Listed below are foot lengths (mm) and heights (mm) of males. Find the regression equation, letting foot length be the predictor (x) variable. Find the best predicted height of a male with a foot length of 273.3 mm. How does the result compare to the actual height of 1776 mm? Foot Length 281.9 278.1 253.3 259.4 279.1 257.8 273.6 262.2 Height 1785.0 1771.2 1676.2 1646.2 1858.9 1710.2 1788.7 1736.6 The regression equation is y=+x. X. (Round the y-intercept to the nearest integer as needed. Round the slope to two decimal places as needed.) The best predicted height of a male with a foot length of 273.3 mm is mm. (Round to the nearest integer as needed.) How does the result compare to the actual height of 1776 mm? OA. The result is very different from the actual height of 1776 mm. OB. The result is exactly the same as the actual height of 1776 mm. OC. The result is close to the actual height of 1776 mm. OD. The result does not make sense given the context of the data.arrow_forwardThe U.S. Postal Service is attempting to reduce the number of complaints made by the public against its workers. To facilitate this task, a staff analyst for the service regresses the number of complaints lodged against an employee last year on the hourly wage of the employee for the year. The analyst ran a simple linear regression in SPSS. The results are shown below. The current minimum wage is $5.15. If an employee earns the minimum wage, how many complaints can that employee expect to receive? Is the regression coefficient statistically significant? How can you tell?arrow_forwardA FIFA World Cup football is dropped from 35 different heights (in cm) and the height of the bounce is recorded (in cm.) The regression analysis gives the model bounce = -0.1 +0.70 drop. Predict the height of the bounce if dropped from 64 cm. 44.7 cm 44.8 cm 64.6 cm 91.57 cm 44.9 cmarrow_forward
- Listed below are foot lengths (mm) and heights (mm) of males. Find the regression equation, letting foot length be the predictor (x) variable. Find the best predicted height of a male with a foot length of 272.7 mm. How does the result compare to the actual height of 1776 mm? Foot Length 282.3 277.8 252.8 258.7 279.0 258.4 274.1 261.7 Height 1785.0 1771.0 1675.7 1645.7 1859.3 1710.2 1789.2 1737.0 The regression equation is ŷ = + (x. (Round the y-intercept to the nearest integer as needed. Round the slope to two decimal places as needed.) The best predicted height of a male with a foot length of 272.7 mm is (Round to the nearest integer as needed.) How does the result compare to the actual height of 1776 mm? O A. The result is close to the actual height of 1776 mm. O B. The result is exactly the same as the actual height of 1776 mm. O C. The result is very different from the actual height of 1776 mm. O D. The result does not make sense given the context of the data. C mm.arrow_forwardListed below are foot lengths (mm) and heights (mm) of males. Find the regression equation, letting foot length be the predictor (x) variable. Find the best predicted height of a male with a foot length of 272.8 mm. How does the result compare to the actual height of 1776 mm? Foot Length 281.8 277.9 253.3 259.2 279.0 258.0 274.0 262.4 Height 1784.7 1771.2 1676.0 1645.9 1858.9 1710.1 1788.9 1737.0 The regression equation is y=enter your response here+enter your response herex. (Round the y-intercept to the nearest integer as needed. Round the slope to two decimal places as needed.) The best predicted height of a male with a foot length of 272.8 mm is enter your response heremm. (Round to the nearest integer as needed.)arrow_forwardAnswer the following question based on this scenario: A clinical psychologist identifies the relationship between the number of weeks spent in therapy at a hospital (X = hospital) and the number of strokes per week (Y = stroke), i.e. Y = 14.09 - 91(X). This is based on a sample of 50 patients and is associated with r = -.93. Using this information, answer the following question: How many strokes per week can you predict for a person who has been in hospital for 10 weeks?a) 4,49b) 4,99c) 14,09d) 91e) 13,18arrow_forward
- Listed below are foot lengths (mm) and heights (mm) of males. Find the regression equation, letting foot length be the predictor (x) variable. Find the best predicted height of a male with a foot length of 273.1 mm. How does the result compare to the actual height of 1776 mm? Foot Length 282.0 278.0 253.1 258.8 279.0 258.0 274.4 262.2 Height 1785.3 1771.2 1675.9 1646.3 1859.2 1710.4 1789.2 1737.2 The regression equation is y=+x. (Round the y-intercept to the nearest integer as needed. Round the slope to two decimal places as needed.) The best predicted height of a male with a foot length of 273.1 mm is mm. (Round to the nearest integer as needed.) How does the result compare to the actual height of 1776 mm? OA. The result is exactly the same as the actual height of 1776 mm. OB. The result is very different from the actual height of 1776 mm. OC. The result is close to the actual height of 1776 mm. OD. The result does not make sense given the context of the data.arrow_forwardListed below are systolic blood pressure measurements (in mm Hg) obtained from the same woman. Find the regression equation, letting the right arm blood pressure be the predictor (x) variable. Find the best predicted systolic blood pressure in the left arm given that the systolic blood pressure in the right arm is 100 mm Hg. Use a significance level of 0.05. Right Arm Left Arm 103 102 96 78 176 170 148 148 Click the icon to view the critical values of the Pearson correlation coefficient r 77 Q The regression equation is y=+x. (Round to one decimal place as needed.) 146 Given that the systolic blood pressure in the right arm is 100 mm Hg, the best predicted systolic blood pressure in the left arm is (Round to one decimal place as needed.) mm Hg.arrow_forwardListed below are foot lengths (mm) and heights (mm) of males. Find the regression equation, letting foot length be the predictor (x) variable. Find the best predicted height of a male with a foot length of 272.7 mm. How does the result compare to the actual height of 1776 mm? Foot Length Height 281.8 278.1 252.7 258.9 278.9 258,4 274.0 261.7 O 1785.3 1770.9 1676.3 1646.3 1859.3 1710.3 1789.2 1736.7 The regression equation is y=+ ( x. (Round the y-intercept to the nearest integer as needed. Round the slope to two decimal places as needed.) The best predicted height of a male with a foot length of 272.7 mm is mm. (Round to the nearest integer as needed.) How does the result compare to the actual height of 1776 mm? O A. The result is close to the actual height of 1776 mm. O B. The result is exactly the same as the actual height of 1776 mm. OC. The result is very different from the actual height of 1776 mm. O D. The result does not make sense given the context of the data.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
College AlgebraAlgebraISBN:9781305115545Author:James Stewart, Lothar Redlin, Saleem WatsonPublisher:Cengage Learning
Linear Algebra: A Modern IntroductionAlgebraISBN:9781285463247Author:David PoolePublisher:Cengage Learning
Glencoe Algebra 1, Student Edition, 9780079039897...AlgebraISBN:9780079039897Author:CarterPublisher:McGraw Hill
Algebra and Trigonometry (MindTap Course List)AlgebraISBN:9781305071742Author:James Stewart, Lothar Redlin, Saleem WatsonPublisher:Cengage Learning
Big Ideas Math A Bridge To Success Algebra 1: Stu...AlgebraISBN:9781680331141Author:HOUGHTON MIFFLIN HARCOURTPublisher:Houghton Mifflin Harcourt
College Algebra
Algebra
ISBN:9781305115545
Author:James Stewart, Lothar Redlin, Saleem Watson
Publisher:Cengage Learning
Linear Algebra: A Modern Introduction
Algebra
ISBN:9781285463247
Author:David Poole
Publisher:Cengage Learning
Glencoe Algebra 1, Student Edition, 9780079039897...
Algebra
ISBN:9780079039897
Author:Carter
Publisher:McGraw Hill
Algebra and Trigonometry (MindTap Course List)
Algebra
ISBN:9781305071742
Author:James Stewart, Lothar Redlin, Saleem Watson
Publisher:Cengage Learning
Big Ideas Math A Bridge To Success Algebra 1: Stu...
Algebra
ISBN:9781680331141
Author:HOUGHTON MIFFLIN HARCOURT
Publisher:Houghton Mifflin Harcourt
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