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
Question
Chapter 14.8, Problem 45E
a.
To determine
Obtain an estimated regression equation for these data.
b.
To determine
Find the residuals.
c.
To determine
Draw a residual plot against the independent variables x and explain whether the assumptions about the error terms seem to be satisfied.
d.
To determine
Find the standardized residuals.
e.
To determine
Draw a plot of the standardized residuals against
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Given are five observations for two variables, x and y.
xi
1
2
3
4
5
yi
4
6
6
11
13
Develop the estimated regression equation by computing the values of
b0
and
b1
using
b1 =
Σ(xi − x)(yi − y)
Σ(xi − x)2
and
b0 = y − b1x.
ŷ =
(e)
Use the estimated regression equation to predict the value of y when
x = 2.
Given are five observations for two variables, x and y.
xi
3
12
6
20
14
yi
55
45
50
15
20
#1) Develop the estimated regression equation by computing the values of b0 and b1 using
b1 =
Σ(xi − x)(yi − y)
Σ(xi − x)2
and
b0 = y − b1x.
y=
#2) Use the estimated regression equation to predict the value of y when x = 13.
Given are five observations for two variables, x and y.xi -3 12 6 20 14yi -55 40 55 10 15 Develop the estimated regression equation by computing the values of
b0 and b1 using b1 =
Σ(xi − x)(yi − y)
Σ(xi − x)2
and
b0 = y − b1x.
y= ____________________
Use the estimated regression equation to predict the value of y when x = 7.
_____________________________
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
- Olympic 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_forwardGiven are data for two variables, x and y. xi 6 11 15 18 20 yi 5 9 13 19 30 An estimated regression equation for these data is yhat=-7.24+1.6x a) Compute the residuals. (Round your answers to two decimal places.) b) Compute the standardized residuals. (Round your answers to two decimal places.) Ans both..otherwise don't answerarrow_forwardGiven are five observations for two variables, x and y. xi 1 2 3 4 5 yi 4 6 5 9 14 Develop the estimated regression equation by computing the the slope and the y intercept of the estimated regression line (to 1 decimal). y^= + x Use the estimated regression equation to predict the value of y when x = 5 (to 1 decimal).y^ =arrow_forward
- Given are five observations collected in a regression study on two variables. xi 2 6 9 13 20 yi 9 18 8 25 21 (b) Develop the estimated regression equation for these data. ŷ = (c) Use the estimated regression equation to predict the value of y when x = 13.arrow_forwardThe personnel director of a large hospital is interested in determining the relationship (if any) between an employee’s age and the number of sick days the employee takes per year. The director randomly selects ten employees and records their age and the number of sick days which they took in the previous year. Employee 1 2 3 4 5 6 7 8 9 10Age 30 50 40 55 30 28 60 25 30 45Sick Days 7 4 3 2 9 10 0 8 5 2 The estimated regression equation and the standard error are given. Sick Days=14.310162−0.236900(Age) Se=1.682207 Find the 95% prediction interval for the average number of sick days an employee will take per year, given the employee is 34 . Round your answer to two decimal places.arrow_forwardConsider the following data for two variables, x and y. x 9 32 18 15 26 y 9 19 20 15 22 Develop an estimated regression equation for the data of the form ŷ = b0 + b1x + b2x2. (Round b0 to two decimal places and b1 to three decimal places and b2 to four decimal places.) ŷ = (c) Use the model from part (b) to predict the value of y when x = 20. (Round your answer to two decimal places.)arrow_forward
- Given below are results from the regression analysis where the dependent variable is the number of weeks a worker is unemployed due to a layoff (Unemploy) and the independent variables are the age of the worker (Age), the number of years of education received (Edu), the number of years at the previous job (Job Yr), a dummy variable for marital status (Married: 1=married, 0=otherwise), a dummy variable for head of household (Head: 1=yes, 0=no) and a dummy variable for management position (Manager: 1=yes, 0=no). We shall call this Model 1. The coefficient of partial determination (R2Yj.(All variables except j)) of each of the six predictors are, respectively, 0.2807, 0.0386, 0.0317, 0.0141, 0.0958, and 0.1201. Model 2 is the regression analysis where the dependent variable is Unemploy and the independent variables are Age and Manager. The results of the regression analysis are given. Refer to model 1. Which of the following is the correct null hypothesis to test…arrow_forwardThe director of marketing at Vanguard Corporation believes that sales of the company's Bright Side laundry detergent (S) are related to Vanguard's own advertising expenditure (A), as well as the combined advertising expenditures of its three biggest rival detergent (R). The marketing director collects 36 weekly observations on S, A and R to estimate the following multiple regression equation: S = a + bA + cR .where, S, A, and R are measured in dollars per week. Vanguard's marketing director is comfortable using parameter estimates that are statistically significant at the 10% level or better.DEPENDENT VARIABLE: S R-SQUARE F-RATIO P-VALUE ON FOBSERVATIONS: 36 0.2247 4.781 0.0150VARIABLE PARAMETER STANDARD T-RATIO P-VALUE ESTIMATE ERRORINTERCEPT 175086.0 63821.0 2.74 0.0098A 0.8550 0.3250…arrow_forward
arrow_back_ios
arrow_forward_ios
Recommended textbooks for you
Functions and Change: A Modeling Approach to Coll...AlgebraISBN:9781337111348Author:Bruce Crauder, Benny Evans, Alan NoellPublisher:Cengage Learning
College AlgebraAlgebraISBN:9781305115545Author:James Stewart, Lothar Redlin, Saleem WatsonPublisher:Cengage Learning
Functions and Change: A Modeling Approach to Coll...
Algebra
ISBN:9781337111348
Author:Bruce Crauder, Benny Evans, Alan Noell
Publisher:Cengage Learning
College Algebra
Algebra
ISBN:9781305115545
Author:James Stewart, Lothar Redlin, Saleem Watson
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