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
If a sample of 25 pairs of data yields a correlation coefficient, r, of 0.390 and the scatterplot displays a linear trend, can you use the regression equation to make predictions, assuming your x-values are within the domain of the data set? Choose your answer from the multiple choice answers below
A.) Yes, because rcrit = 0.396 and the regression coefficient, r, is less than this value.
B.) Yes, because rcrit = 0.381 and the regression coefficient, r, is greater than this value.
C.) No, because rcrit = 0.381 and the regression coefficient, r, is greater than this value.
D.) No, because rcrit = 0.396 and the regression coefficient, r, is less than this value.
Given the equation of a regression line is y = -5.5x - 9.4, what is the best predicted value for y given x = -3.1? Assume that the variables x and y have a significant correlation.
Ch 13. 7: Refer to the Lincolnville School District bus data. First, add a variable to change the type of engine (diesel or gasoline) to a qualitative variable. If the engine type is diesel, then set the qualitative variable to 0. If the engine type is gasoline, then set the qualitative variable to 1. Develop a regression equation using statistical software with maintenance cost as the dependent variable and age, odometer miles, miles since last maintenance, and engine type as the independent variables.
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
- The following fictitious table shows kryptonite price, in dollar per gram, t years after 2006. t= Years since 2006 0 1 2 3 4 5 6 7 8 9 10 K= Price 56 51 50 55 58 52 45 43 44 48 51 Make a quartic model of these data. Round the regression parameters to two decimal places.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_forwardIt is considered that the number of employees in the enterprise affects the number of production. Data are given below. Which of the following is the simple linear regression equation?arrow_forward
- A study of the amount of rainfall and the quantity of air pollution removed produced the following data shown in table below: Daily Rainfall x (0.01 cm) Particulate Removed y (μg/m3) 7 126 7.9 129.3 7.5 125.3 9.2 120.2 10.8 116.7 5.8 119.2 5.6 138.7 2.7 147.5 9.2 110.3 Compute and interpret the coefficient of determination, and coefficient of correlation for the given data. What will be the regression equation, when swapped depended and independent variablearrow_forwardThe Wall Street Journal asked Concur Technologies, Inc., an expense management company, to examine data from 8.3 million expense reports to provide insights regarding business travel expenses. Their analysis of the data showed that New York was the most expensive city. The following table shows the average daily hotel room rate (X) and the average amount spent on entertainment (Y) for a random sample of 9 of the 25 most-visited U.S. cities. These data lead to the estimated regression equation y = 17.49 + 1.0334x. For these data SSE = 1541.4. Use Table 1 of Appendix B. a. Predict the amount spent on entertainment for a particular city that has a daily room rate of $89 (to 2 decimals). b. Develop a 95% confidence interval for the mean amount spent on entertainment for all cities that have a daily room rate of $89 (to 2 decimals). c. The average room rate in Chicago is $128. Develop a 95% prediction interval for the amount spent on entertainment in Chicago (to 2 decimals).arrow_forwardThe Wall Street Journal asked Concur Technologies, Inc., an expense management company, to examine data from 8.3 million expense reports to provide insights regarding business travel expenses. Their analysis of the data showed that New York was the most expensive city. The following table shows the average daily hotel room rate (X) and the average amount spent on entertainment (Y) for a random sample of 9 of the 25 most-visited U.S. cities. These data lead to the estimated regression equation y = 17.49 + 1.0334x. For these data SSE = 1541.4. Use Table 1 of Appendix B. (NEED ANSWER FOR A) a. Predict the amount spent on entertainment for a particular city that has a daily room rate of $89 (to 2 decimals).arrow_forward
- In the packaging department of a large aircraft parts distributor, a fairly reliable estimate of packaging and processing costs can be determined by knowing the weight of an order. Thus, the weight is a cost driver that accounts for a sizable fraction of the packaging and processing costs at this company. Data for the past 10 orders are given as follows. Solve, a. Estimate the b0 and b1 coefficients, and determine the linear regression equation to fit these data. b. What is the correlation coefficient (R)? c. If an order weighs 250 lb, how much should it cost to package and process it?arrow_forwardTwenty members of an athletic club are studying the relationship between the time it takes an individual athlete to reach a given level of fatigue during exercise (time to fatigue, measured in minutes) and athletic performance. For each member, time to fatigue and a performance score were recorded. The computer output of the regression analysis is shown in the table. Term CoefCoef SE CoefSE Coef TT Constant 39.88 4.24 9.41 Time to fatigue 3.92 0.71 5.52 Which of the following is a 90 percent confidence interval for the slope of the regression line relating performance score and time to fatigue? Assume that the conditions for inference are met.arrow_forwardWorking as a professor, I may want to try and predict success on a final exam by student success on exam 1 and see whether or not there is a relationship between those. I gather data from a set of students and obtain their first exam score and their final exam score. Using the following data, find the Pearson’s r correlation coefficient, produce a linear regression equation, and describe the associated R2 value. First exam score (X) Final exam score (Y) 95 100 90 92 95 90 85 90 85 85 80 75 65 75 60 50 70 82 90 95 80 100 90 90 75 60 75 80 Pearson’s r = ______________ Is the r significant? _______________ Linear regression equation: ____________________arrow_forward
- Working as a professor, I may want to try and predict success on a final exam by student success on exam 1 and see whether or not there is a relationship between those. I gather data from a set of students and obtain their first exam score and their final exam score. Using the following data, find the Pearson’s r correlation coefficient, produce a linear regression equation, and describe the associated R2 value. First exam score (X) Final exam score (Y) 95 100 90 92 95 90 85 90 85 85 80 75 65 75 60 50 70 82 90 95 80 100 90 90 75 60 75 80 R2 = ____________________ What does R2 in this example mean? ____________________________________________ What would the final exam score be for someone who scored a 75 on the first exam? _______________ What would the final exam score be for someone who scored a 90 on the first exam? _______________arrow_forwardA company has a set of data with employee age (X) and the corresponding number of annual on-the-job-accidents (Y). Analysis on the set finds that the regression equation is Y=60-0.5*X. What can be said of the correspondence (relation) between age and accidents? Are younger workers safer or more prone to accident? What is the likely number of accidents for someone aged 25?arrow_forwardIn exercise 4, the following estimated regression equation relating sales to inventory investment and advertising expenditures was given.The data used to develop the model came from a survey of 10 stores; for these dataSST = 16,000 and SSR =12,000. yˆ = 25 + 10x1 + 8x2 a. Compute SSE, MSE, and MSR.b. Use an F test and a .05 level of significance to determine whether there is a relationship among the variables.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
Functions and Change: A Modeling Approach to Coll...AlgebraISBN:9781337111348Author:Bruce Crauder, Benny Evans, Alan NoellPublisher:Cengage Learning
Glencoe Algebra 1, Student Edition, 9780079039897...AlgebraISBN:9780079039897Author:CarterPublisher:McGraw Hill
College Algebra
Algebra
ISBN:9781305115545
Author:James Stewart, Lothar Redlin, Saleem Watson
Publisher:Cengage Learning
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
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