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 35E
The following data are the monthly salaries y and the grade point averages x for students who obtained a bachelor’s degree in business administration.
| GPA | Monthly Salary ($) |
| 2.6 | 3600 |
| 3.4 | 3900 |
| 3.6 | 4300 |
| 3.2 | 3800 |
| 3.5 | 4200 |
| 2.9 | 3900 |
The estimated regression equation for these data is ŷ = 2090.5 + 581.1x and MSE = 21,284.
- a. Develop a point estimate of the starting salary for a student with a GPA of 3.0.
- b. Develop a 95% confidence interval for the
mean starting salary for all students with a 3.0 GPA. - c. Develop a 95% prediction interval for Ryan Dailey, a student with a GPA of 3.0.
- d. Discuss the differences in your answers to parts (b) and (c).
Expert Solution & Answer
Trending nowThis is a popular solution!
Students have asked these similar questions
Type the regression equation for “Area” and “Biomass” in context into your document.
Interpret the slope of the regression line (in context of this data set) for “Area” and “Biomass”.
is it meaningful to interpret the y-intercept for “Area” and “Biomass”? Why or why not?
The data show the number of viewers for television stars with certain salaries. Find the regression equation, letting salary be the independent (x) variable. Find the best
predicted number of viewers for a television star with a salary of $6 million. Is the result close to the actual number of viewers, 2.9 million? Use a significance level of
0.05
The following data show the brand, price ($), and the overall score for 6 stereo headphones that were tested by Consumer Reports.
The overall score is based on sound quality and effectiveness of ambient noise reduction. Scores range from 0 (lowest) to 100
(highest). The estimated regression equation for these data is y = 19.653 + 0.353 x, where x =
price ($) and y
= overall score.
Brand
Price ($)
Score
Bose
170
76
Scullcandy
150
71
Koss
95
62
Phillips/O'Neill
70
57
Denon
70
40
JVC
45
24
Round your answers to three decimal places.
a. Compute SST, SSR, and SSE.
SST
SSR
SSE
b. Compute the coefficient of determination r 2. Comment on the goodness of fit.
r2 =
Select
c. What is the value of the sample correlation coefficient?
r =
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
- Life Expectancy The following table shows the average life expectancy, in years, of a child born in the given year42 Life expectancy 2005 77.6 2007 78.1 2009 78.5 2011 78.7 2013 78.8 a. Find the equation of the regression line, and explain the meaning of its slope. b. Plot the data points and the regression line. c. Explain in practical terms the meaning of the slope of the regression line. d. Based on the trend of the regression line, what do you predict as the life expectancy of a child born in 2019? e. Based on the trend of the regression line, what do you predict as the life expectancy of a child born in 1580?2300arrow_forwardDemand for Candy Bars In this problem you will determine a linear demand equation that describes the demand for candy bars in your class. Survey your classmates to determine what price they would be willing to pay for a candy bar. Your survey form might look like the sample to the left. a Make a table of the number of respondents who answered yes at each price level. b Make a scatter plot of your data. c Find and graph the regression line y=mp+b, which gives the number of respondents y who would buy a candy bar if the price were p cents. This is the demand equation. Why is the slope m negative? d What is the p-intercept of the demand equation? What does this intercept tell you about pricing candy bars? Would you buy a candy bar from the vending machine in the hallway if the price is as indicated. Price Yes or No 50 75 1.00 1.25 1.50 1.75 2.00arrow_forwardXYZ Corporation Stock Prices The following table shows the average stock price, in dollars, of XYZ Corporation in the given month. Month Stock price January 2011 43.71 February 2011 44.22 March 2011 44.44 April 2011 45.17 May 2011 45.97 a. Find the equation of the regression line. Round the regression coefficients to three decimal places. b. Plot the data points and the regression line. c. Explain in practical terms the meaning of the slope of the regression line. d. Based on the trend of the regression line, what do you predict the stock price to be in January 2012? January 2013?arrow_forward
- DVD Player sales The table shows the number of DVD play-ers sold in a small electronics store in the years 2003-2013. What was the average rate of change of sales between 2003 and 2013? Whatwas the average rate of change of sales between 2003 and 2004? What was the average rate of change of sales between 2004 and 2005? Between which two successive years did DVD player sales increase most quickly?arrow_forwardWhat is regression analysis? Describe the process of performing regression analysis on a graphing utility.arrow_forwardFor the data given below: a. Determine if there is any relationship between the two variables. b. If there is any relationship, measure the strength of the linear relationship between the variables. c. Determine the regression line equation and plot it. Verbal x 526 504 594 585 503 589 Math y 530 522 606 588 517 589arrow_forward
- Spring is a peak time for selling houses. The file SpringHouses contains the selling price, number of bathrooms, square footage, and number of bedrooms of 26 homes sold in Ft. Thomas, Kentucky, in spring 2018 (realtor.com website) Click on the datafile logo to reference the data. DATA file a. The Excel output for the estimated regression equation that can be used to predict the selling price given the number of bathrooms, square footage, and number of bedrooms in the house: SUMMARY OUTPUT Multiple R R Square Adjusted R Square Standard Error Observations ANOVA Regression statistics Regression Residual Total Multiple R R Square ANOVA Adjusted R Square Standard Error Observations 0.7429 0.5519 0.4907 61948.6931 Regression statistics Regression Residual Total df Intercept Sq Ft Beds Lower 95% 0.9353 -145129.5298 Intercept Baths 0.9528 -49383.5243 0.0180 Sq Ft Beds 0.0326 Does the estimated regression equation provide a good fit to the data? Explain. Hint: If R is greater than 45%, the…arrow_forwardProcess the data in excel and present the results. A researcher is interested in knowing how well he can predict blood pressure from sodium intake. Formulate the regression equation for the data. What would be a likely blood pressure reading for a patient with a sodium intake of 6.0? Of 8.5? Patients Sodium BP 1 6.5 151 2 7.3 170 3 6.6 165 4 7.5 172 5 7.6 187 6 6.7 161 7 6.7 169 8 7.8 192 9 7 185 10 7.4 190 11 6.2 145 12 6.7 143arrow_forwardFor the advertised price and number of miles data, the equation of the regression line is price = 18,773-86.18(thousands of miles) Predict the asking price for a car with 50,000 miles. $ type your answer...arrow_forward
- Lillian conducted a small survey of her friends and family. She asked them how many hours per week they spend reading digital documents (newspapers, blogs, books, etc.), and their age. She created the scatter plot below with the results she obtained. Draw the regression line that best represents this scatter plot and determine its equation.arrow_forwardThe following data show the brand, price ($), and the overall score for six stereo headphones that were tested by a certain magazine. The overall score is based on sound quality and effectiveness of ambient noise reduction. Scores range from 0 (lowest) to 100 (highest). The estimated regression equation for these data is ŷ = 23.659 + 0.323x where x = price ($) and y = overall score. Brand Price ($) Score A 180 78 B 150 73 C 95 59 D 70 56 E 70 42 F 35 28 (a) Compute SST, SSR, and SSE. (Round your answers to three decimal places.) SST=_____ SSR=_____ SSE=_____ (b) Compute the coefficient of determination r2. (Round your answer to three decimal places.) r2 =____ Comment on the goodness of fit. (For purposes of this exercise, consider a proportion large if it is at least 0.55.) (A) The least squares line provided a good fit as a large proportion of the variability in y has been explained by the least squares line. (B) The least squares line provided a good…arrow_forwardThe following data show the brand, price ($), and the overall score for six stereo headphones that were tested by a certain magazine. The overall score is based on sound quality and effectiveness of ambient noise reduction. Scores range from 0 (lowest) to 100 (highest). The estimated regression equation for these data is ŷ = 25.870 + 0.291x, where x = price ($) and y = overall score. Brand Price ($) Score A 180 74 B 150 69 C 95 63 D 70 54 E 70 42 F 35 28 (a) Compute SST, SSR, and SSE. (Round your answers to three decimal places.) SST=SSR=SSE= (b) Compute the coefficient of determination r2. (Round your answer to three decimal places.) r2 = Comment on the goodness of fit. (For purposes of this exercise, consider a proportion large if it is at least 0.55.) The least squares line did not provide a good fit as a small proportion of the variability in y has been explained by the least squares line.The least squares line did not provide a good fit as a large…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
Big Ideas Math A Bridge To Success Algebra 1: Stu...AlgebraISBN:9781680331141Author:HOUGHTON MIFFLIN HARCOURTPublisher:Houghton Mifflin Harcourt
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
Algebra & Trigonometry with Analytic GeometryAlgebraISBN:9781133382119Author:SwokowskiPublisher:Cengage
College Algebra
Algebra
ISBN:9781305115545
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
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
Algebra & Trigonometry with Analytic Geometry
Algebra
ISBN:9781133382119
Author:Swokowski
Publisher:Cengage
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