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 15.3, Problem 14E
a.
To determine
Compute
b.
To determine
Find
c.
To determine
Explain whether the model appear to explain a large amount of variability in the data.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
In 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.
The following estimated regression equation relating sales to inventory investment and advertising expenditures was given.
ŷ = 28 + 15x1 + 9x2
The data used to develop the model came from a survey of 10 stores; for those data, SST = 18,000 and SSR = 13,140.
1. Compute R2
2. Compute Ra2
3. The adjusted coefficient of determination shows that ____ % of the variability has been explained by the two independent variables.
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…
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_forwardThe 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_forwardIn 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_forward
- The following scores represent a nurse’s assessment (X) and a physician’s assessment (Y) of the condition of 10 patients at time of admission to a trauma centre: X: 18 13 18 15 10 12 8 4 7 3 Y: 23 20 18 16 14 11 10 7 6 4 a) Obtain the regression equation. b) What is the predicted physician’s assessment for a nurse’s assessment of; 16 scores? 21 scores? c) Distinguish between extrapolation and interpolationarrow_forwardIn 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: 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 205 lb, how much should it cost to package and process it? Packaging and Processing Cost ($), y Weight (Pounds), x 99 240 111 275 86 210 85 185 121 315 114 300 111 285 100 270 109 275 85 200arrow_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_forward
- Consider the following sample of production volumes and total cost data for a manufacturing operation. Production Volume(units) Total Cost($) 400 4,000 450 4,900 550 5,300 600 5,900 700 6,400 750 7,000 This data was used to develop an estimated regression equation, ŷ = 1,121.33 + 7.76x, relating production volume and cost for a particular manufacturing operation. Use ? = 0.05 to test whether the production volume is significantly related to the total cost. (Use the F test.) State the null and alternative hypotheses. -H0: ?1 ≠ 0Ha: ?1 = 0 -H0: ?1 ≥ 0Ha: ?1 < 0 -H0: ?0 ≠ 0Ha: ?0 = 0 -H0: ?1 = 0Ha: ?1 ≠ 0 -H0: ?0 = 0Ha: ?0 ≠ 0 Set up the ANOVA table. (Round your p-value to three decimal places and all other values to two decimal places.) Sourceof Variation Sumof Squares Degreesof Freedom MeanSquare F p-value Regression ? ? ? ? ? Error ? ? ? Total ? ? Find the value of the test statistic. (Round your answer to two decimal places.) Test…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_forwardThe following table displays the EPA fuel efficiency estimates (in miles per gallon) and the curbweight (in pounds) for a random sample of current year model vehicles.MPG 23 18 28 19 25 17 18 14Weight 3184 3598 2734 4082 2623 4685 4178 5488(a) Determine the linear regression model that will best predict the EPA fuel efficiency estimates(MPG) of a vehicle based on its curb weight.(b) How well does the linear regression model fit this sample data?(c) For a vehicle that weighs 4000 pounds, predict its EPA fuel efficiency estimate.arrow_forward
- 1. The following data give the percentage of women working in five companies in the retail and trade industry. The percentage of management jobs held by women in each company is also shown. % Working 69 48 73 54 61 % Management 51 21 61 51 43 Develop the estimated regression equation by computing the values of b0 (y-intercept) and b1 (slope).Predict the percentage of management jobs held by women in a company that has 65% women employees.arrow_forwardAssume the following table lists campaign spending, in thousands of dollars, by candidates for statewide office and the percentage of the popular vote they received in their respective districts:Spending11.551.117.94.912.920.576.4Percentage33.412.861.250.278.114.149.9Does a strong linear correlation exist between campaign spending and percentage of votes received? How do you know?If a strong linear correlation exists, answer the following:a.) Find a regression model (ax+b) for percentage of votes received as a function of campaign spending.b.) If a politician spent $60,000 on a campaign, what percentage of the vote should she expect to receive? Also, is this interpolation or extrapolation? Why?c.) If a politician received a quarter of the votes, what would you expect the campaign to have spent?arrow_forwardA sales manager collected the following data on annual sales for new customer accounts and the number of years of experience for a sample of 10 salespersons. Salesperson Years of Experience Annual Sales ($1000s) 1 1 80 2 3 97 3 4 92 4 4 102 5 6 103 6 8 111 7 10 119 8 10 123 9 11 117 10 13 136 Develop a scatter diagram for these data with years of experience as the independent variable. Develop an estimated regression equation that can be used to predict annual sales given the years of experience. Use the estimated regression equation to predict annual sales for a salesperson with 9 years of experience.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Functions and Change: A Modeling Approach to Coll...AlgebraISBN:9781337111348Author:Bruce Crauder, Benny Evans, Alan NoellPublisher:Cengage LearningGlencoe Algebra 1, Student Edition, 9780079039897...AlgebraISBN:9780079039897Author:CarterPublisher:McGraw HillCollege 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
Glencoe Algebra 1, Student Edition, 9780079039897...
Algebra
ISBN:9780079039897
Author:Carter
Publisher:McGraw Hill
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