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
Question
Chapter 14.8, Problem 47E
a.
To determine
Obtain an estimated regression equation for these data using least square criterion.
b.
To determine
Test whether revenue and advertising expenditures are related at
c.
To determine
Draw a residual plot of
d.
To determine
Draw the conclusion from the residual analysis and explain whether the model is useful or a better model is needed.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
Compute the least-squares regression line for predicting the price of milk from the price of eggs. Round the slope and
y-intercept to at least four decimal places.
Find the equation for the least squares regression line of the data described below.
Meteorologists in a seaside town wanted to understand how their annual rainfall
is affected by the temperature of coastal waters.
For the past few years, they monitored the average temperature of coastal
waters (in Celsius), x, as well as the annual rainfall (in millimetres), y.
Rainfall statistics
• The mean of the x-values is 11.503.
• The mean of the y-values is 366.637.
• The sample standard deviation of the x-values is 4.900.
• The sample standard deviation of the y-values is 44.387.
• The correlation coefficient of the data set is 0.896.
Round your answers to the nearest thousandth.
y = L
Submit
A company believes that the variation in the cost of a shipment can be explained by the weight of
the package. A sample of 20 customer shipments was selected, and this scatter plot and
regression line were obtained:
Shipping
y = 1.101x + 4.4995
r= 0.8764
30
25
20
15
10
5
10
15
20
25
Weight (Ib)
a. Find r' and interpret the meaning of r in the context of this problem.
b. Interpret the meaning of the slope in the context of this problem.
c. Interpret the meaning of the y-intercept in the context of this problem. Explain whether or
not it makes sense.
d. Using the regression equation, calculate the expected cost of a package that weighs 11 lbs.
e. Using the regression equation, find the weight of a package that cost $20 to ship.
Cost (dollars)
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
- Find the equation of the regression line for the following data set. x 1 2 3 y 0 3 4arrow_forwardA microcomputer manufacturer has developed a regression model relating his sales (y=$10,000s) with three independent variables. The three independent variables are price per unit(Price in $100s), advertising( ADV in $1000s) and the number of product lines (Lines). Part of the regression results is shown below. Coefficient Standard Error Intercept 1.0211 22.8752 Price(X1) -0.1524 0.1411 ADV (X2) 0.8849 0.2886 Lines(X3) -0.1463 1.5340 Source d.f. S.S. Regression 3 2708.61 Error 14 2840.51 Total 17 5549.12 What has been the sample size (n) for this analysis? Use the above results to find the estimated multiple…arrow_forwardPlease help mearrow_forward
- Suppose that the line ŷ = 5+ 2x is fitted to the data points (-2,2), (1,6), and (5,14). Determine the sum of the squared residuals. %3D Sum of the Squared Residuals =arrow_forwardCompute the least-squares regression line for predicting the 2012 budget from the 2006 budget. Round the slope and y. intercept to at least four decimal places.arrow_forwardThese are the values in Irwin's data set. (1,43),(3,36),(5,22),(6,25),(8,14) Irwin determined the equation of a linear regression line, and dete (1,44),(3,35),(5,26),(6,22),(8,13) Use the point tool to graph the residual plot for the data set.arrow_forward
- Explain in brief the Utility of regression lines?arrow_forwardfor (f) the line equation is (could not include in screenshot): y=2x+(-4) How do you compute the sum of the squared residuals for the LINE in F and sum of residuals for the LEAST-SQUARES regression lind in D? Please do on a TI-84 Plus calculator (or just a calculator) instead of by hand. Thanksarrow_forwardData on advertising expenditures and revenue (in thousands of dollars) for the Four Seasons Restaurant follow. Advertising Expenditures Revenue 1 19 2 32 4 44 6 40 10 52 14 53 20 54arrow_forward
- Please helparrow_forwardhe scatter plot below shows the average cost of a patient staying one day in a hospital (with no surgery) in a sample of years between 2000 and 2015. The least squares regression line modeling this data is given by yˆ=−4815+3.765x. A scatterplot has a horizontal axis labeled Year from 2005 to 2015 in increments of 5 and a vertical axis labeled Price ($) from 2660 to 2780 in increments of 20. The following points are plotted: (2003, 2736); (2004, 2715); (2007, 2675); (2009, 2719); (2013, 270). All coordinates are approximate. Interpret the slope of the least squares regression line. Select the correct answer below: The average cost of a day in a hospital decreased by $3.765 each year between 2000 and 2015. The average cost of a day in a hospital increased by $3.765 each year between 2000 and 2015. The average cost of a day in a hospital decreased by $4815 each year between 2000 and 2015. The average cost of a day in a hospital increased by…arrow_forwardexplain into details. Thank you.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 HillAlgebra & Trigonometry with Analytic GeometryAlgebraISBN:9781133382119Author:SwokowskiPublisher:Cengage
- Big Ideas Math A Bridge To Success Algebra 1: Stu...AlgebraISBN:9781680331141Author:HOUGHTON MIFFLIN HARCOURTPublisher:Houghton Mifflin HarcourtFunctions 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
Algebra & Trigonometry with Analytic Geometry
Algebra
ISBN:9781133382119
Author:Swokowski
Publisher:Cengage
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
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