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 15.7, Problem 35E
Repair Time. Refer to the Johnson Filtration problem introduced in this section. Suppose that in addition to information on the number of months since the machine was serviced and whether a mechanical or an electrical repair was necessary, the managers obtained a list showing which repairperson performed the service. The revised data follow.
- a. Ignore for now the months since the last maintenance service (x1) and the repair-person who performed the service. Develop the estimated simple linear regression equation to predict the repair time (y) given the type of repair (x2). Recall that x2 = 0 if the type of repair is mechanical and 1 if the type of repair is electrical.
- b. Does the equation that you developed in part (a) provide a good fit for the observed data? Explain.
- c. Ignore for now the months since the last maintenance service and the type of repair associated with the machine. Develop the estimated simple linear regression equation to predict the repair time given the repairperson who performed the service. Let x3 = 0 if Bob Jones performed the service and x3 = 1 if Dave Newton performed the service.
- d. Does the equation that you developed in part (c) provide a good fit for the observed data? Explain.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
1. Develop a simple linear regression equation for starting salaries using an independent
variable that has the closest relationship with the salaries. Explain how you chose this
variable.
Part I. Run two regressions in Excel using the provided Excel file “Layoffs”.The Excel file Layoffs provides data on 50 manufacturing workers who lost their jobs due to layoffs. The
data includes the following list of variables:Weeks – the number of weeks a manufacturing worker has been without a jobAge – the age of the workerEducation – the number of years of education of the workerMarried – a dummy variable, equal to 1 if the worker is married, 0 otherwiseHead – a dummy variable, equal to 1 if the worker is a head of household, 0 otherwiseTenure – the number of years on the previous jobManager – a dummy variable, equal to 1 if the worker had a management occupation, 0 otherwise Sales – a dummy variable, equal to 1 if the worker had an occupation in sales, 0 otherwise
1. Run a simple regression with a dependent variable Weeks and an independent variable Age. Create the regular and standardized residual plots for the simple regression.
2. Run a multiple regression with a dependent…
STER.
1. Wine Consumption. The table below gives the U.S. adult wine consumption, in gallons per
person per year, for selected years from 1980 to 2005.
a) Create a scatterplot for the data. Graph the scatterplot
Year
Wine
below.
Consumption
2.6
b) Determine what type of model is appropriate for the
1980
data.
1985
2.3
c) Use the appropriate regression on your calculator to find a
Graph the regression equation in the same coordinate
plane below.
d) According to your model, in what year was wine
consumption at a minimum? A
e) Use your model to predict the wine consumption in
2008.
1990
2.0
1995
2.1
2000
2.5
2005
2.8
Chapter 15 Solutions
Modern Business Statistics with Microsoft Office Excel (with XLSTAT Education Edition Printed Access Card) (MindTap Course List)
Ch. 15.2 - 1. The estimated regression equation for a model...Ch. 15.2 - Consider the following data for a dependent...Ch. 15.2 - Prob. 3ECh. 15.2 - 4. A shoe store developed the following estimated...Ch. 15.2 - The owner of Showtime Movie Theaters, Inc. would...Ch. 15.2 - NFL Winning Percentage. The National Football...Ch. 15.2 - Prob. 7ECh. 15.2 - Scoring Cruise Ships. The Condé Nast Traveler Gold...Ch. 15.2 - The Professional Golfers Association (PGA)...Ch. 15.2 - Baseball Pitcher Performance. Major League...
Ch. 15.3 - 11. In exercise 1, the following estimated...Ch. 15.3 - 12. In exercise 2, 10 observations were provided...Ch. 15.3 - Prob. 13ECh. 15.3 - Prob. 14ECh. 15.3 - 15. In exercise 5, the owner of Showtime Movie...Ch. 15.3 - Prob. 16ECh. 15.3 - In part (d) of exercise 9, data contained in the...Ch. 15.3 - Prob. 18ECh. 15.5 - In exercise 1, the following estimated regression...Ch. 15.5 - Prob. 20ECh. 15.5 - Prob. 21ECh. 15.5 - Prob. 22ECh. 15.5 - Testing Significance in Theater Revenue. Refer to...Ch. 15.5 - Testing Significance in Predicting NFL Wins. The...Ch. 15.5 - The Condé Nast Traveler Gold List provides ratings...Ch. 15.5 - Prob. 26ECh. 15.6 - Prob. 27ECh. 15.7 - 32. Consider a regression study involving a...Ch. 15.7 - Prob. 33ECh. 15.7 - 34. Management proposed the following regression...Ch. 15.7 - Repair Time. Refer to the Johnson Filtration...Ch. 15.7 - Prob. 36ECh. 15.7 - Prob. 37ECh. 15.8 - Prob. 40ECh. 15.8 - Exercise 5 gave the following data on weekly gross...Ch. 15.8 - The following table reports the price, horsepower,...Ch. 15 - 49. The admissions officer for Clearwater College...Ch. 15 - The personnel director for Electronics Associates...Ch. 15 - Prob. 46SECh. 15 - Recall that in exercise 44, the admissions officer...Ch. 15 - Recall that in exercise 45 the personnel director...Ch. 15 - Fortune magazine publishes an annual list of the...Ch. 15 - The Department of Energy and the U.S....Ch. 15 - The Tire Rack, an online distributor of tires and...Ch. 15 - The National Basketball Association (NBA) records...Ch. 15 - Consumer Research, Inc., is an independent agency...Ch. 15 - Matt Kenseth won the 2012 Daytona 500, the most...Ch. 15 - When trying to decide what car to buy, real value...
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_forwardDoes Table 1 represent a linear function? If so, finda linear equation that models the data.arrow_forwardWhat does the y -intercept on the graph of a logistic equation correspond to for a population modeled by that equation?arrow_forward
- Table 6 shows the population, in thousands, of harbor seals in the Wadden Sea over the years 1997 to 2012. a. Let x represent time in years starting with x=0 for the year 1997. Let y represent the number of seals in thousands. Use logistic regression to fit a model to these data. b. Use the model to predict the seal population for the year 2020. c. To the nearest whole number, what is the limiting value of this model?arrow_forwardA vending machine company operates coffee vending machines in office buildings. The company wants to study the relationship between the number of cups of coffee sold per day and the number of persons working in each building. Data were collected were collected by the company and presented below. Number of Number of Cups of f. Make a copy of the scatter diagram in this item. Draw the line that best fits in the scatter diagram using the regression equation. persons Coffee Sold working at Location g. Locate the (X,). Describe its location in relation to the other plotted data. 15 20 10 15 h. Give a practical interpretation of the values of a and b. 16 20 i. Show that the regression equation can be expressed in the form: (y - y) = b(x - x) 18 25 22 30arrow_forwardThe managing director of a consulting group has the accompanying monthly data on total overhead costs and professional labor hours to bill to clients. Complete parts a through c Click the icon to view the monthly data. a. Develop a simple linear regression model between billable hours and overhead costs. Overhead Costs = 247733.3 +(43.2000) x Billable Hours (Round the constant to one decimal place as needed. Round the coefficient to four decimal places as needed. Do not include the $ symbol in your answers.) b. Interpret the coefficients of your regression model. Specifically, what does the fixed component of the model mean to the consulting firm? Interpret the fixed term, bo. if appropriate. Choose the correct answer below. OA. The value of by is the predicted overhead costs for 0 billable hours. OB. For each increase of 1 unit in overhead costs, the predicted billable hours are estimated to increase by bo OC. It is not appropriate to interpret by. because its value is the predicted…arrow_forward
- b. Use a multiple linear regression model with dummy variables as follows to develop an equation to account for seasonal effects in the data: Qtr1 = 1 if quarter 1, 0 otherwise; Qtr2 = 1 if quarter 2, 0 otherwise; Qtr3 = 1 if quarter 3, 0 otherwise. For subtractive or negative numbers use a minus sign even if there is a + sign before the blank. c. Compute the quarterly forecasts for next year.arrow_forwardThe table below shows the amounts of crude oil (in thousands of barrels per day) produced by a country and the amounts of crude oil (in thousands of barrels per day) imported by a country, for the last seven years. Construct and interpret a 90% prediction interval for the amount of crude oil imported by the this country when the amount of crude oil produced by the country is 5,604 thousand barrels per day. The equation of the regression line is y = - 1.183x + 16,191.143. Oil produced, x Oil imported, y 5,792 5,711 5,614 5,490 5,185 5,073 5,034 9,331 9,111 9,611 10,086 10,165 10,138 10,066 Construct and interpret a 90% prediction interval for the amount of crude oil imported when the amount of crude oil produced by the country is 5,604 thousand barrels per day. Select the correct choice below and fill in the answer boxes to complete your choice. (Round to the nearest cent as needed.) O A. We can be 90% confident that when the amount of oil produced is 5,604 thousand barrels, the amount…arrow_forwardWhich of the following is true of a linear regression line? a. Located as close as possible to all the points of a scatter chart. B. Is defined by an equation having 2 parameters: the slope and the intercept c. Provides an approximate relationship between the values of two parameters d. All of the abovearrow_forward
- The table below shows the amounts of crude oil (in thousands of barrels per day) produced by a country and the amounts of crude oil (in thousands of barrels per day) imported by a country, for the last seven years. Construct and interpret a 99% prediction interval for the amount of crude oil imported by the this country when the amount of crude oil produced by the country is 5,634 thousand barrels per day. The equation of the regression line is y=- 1.190x+16,230.863. Oil produced, x 5,811 5,659 5,450 5,168 5,094 Oil imported, y 9,320 9,621 10,030 10,126 10,157 5,739 9,118 LL OA. There is a 99% chance that the predicted amount of oil imported is between per day produced. 5,049 10,066 Construct and interpret a 99% prediction interval for the amount of crude oil imported when the amount of crude oil produced by the country is 5,634 thousand barrels per day. Select the correct choice below and fill in the answer boxes to complete your choice. (Round to two decimal places as needed.) and…arrow_forwardA sociologist was hired by a large city hospital to investigate the relationship between thenumber of unauthorized days that employees are absent per year and the distance (miles)between home and work for the employees. A sample of 10 employees was chosen, andthe following data were collected. a. Develop a scatter chart for these data. Does a linear relationship appear reasonable?Explain.b. Use the data to develop an estimated regression equation that could be used to predict thenumber of days absent given the distance to work. What is the estimated regression model?c. What is the 99 percent confidence interval for the regression parameter b1? Based onthis interval, what conclusion can you make about the hypotheses that the regressionparameter b1 is equal to zero?d. What is the 99 percent confidence interval for the regression parameter b0? Based onthis interval, what conclusion can you make about the hypotheses that the regressionparameter b0 is equal to zero?e. How much of the…arrow_forward
arrow_back_ios
arrow_forward_ios
Recommended textbooks for you
College AlgebraAlgebraISBN:9781305115545Author:James Stewart, Lothar Redlin, Saleem WatsonPublisher:Cengage Learning
Algebra & Trigonometry with Analytic GeometryAlgebraISBN:9781133382119Author:SwokowskiPublisher:Cengage
Algebra and Trigonometry (MindTap Course List)AlgebraISBN:9781305071742Author:James Stewart, Lothar Redlin, Saleem WatsonPublisher:Cengage Learning
Linear Algebra: A Modern IntroductionAlgebraISBN:9781285463247Author:David PoolePublisher:Cengage Learning
College Algebra
Algebra
ISBN:9781305115545
Author:James Stewart, Lothar Redlin, Saleem Watson
Publisher:Cengage Learning
Algebra & Trigonometry with Analytic Geometry
Algebra
ISBN:9781133382119
Author:Swokowski
Publisher:Cengage
Algebra and Trigonometry (MindTap Course List)
Algebra
ISBN:9781305071742
Author:James Stewart, Lothar Redlin, Saleem Watson
Publisher:Cengage Learning
Linear Algebra: A Modern Introduction
Algebra
ISBN:9781285463247
Author:David Poole
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