Modern Business Statistics with Microsoft Office Excel (with XLSTAT Education Edition Printed Access Card)
Modern Business Statistics with Microsoft Office Excel (with XLSTAT Education Edition Printed Access Card)
6th Edition
ISBN: 9780357228708
Author: David R. Anderson; Dennis J. Sweeney; Thomas A. Williams
Publisher: Cengage Learning US
bartleby

Concept explainers

bartleby

Videos

Textbook Question
Book Icon
Chapter 15, Problem 48SE

Recall that in exercise 45 the personnel director for Electronics Associates developed the following estimated regression equation relating an employee’s score on a job satisfaction test to length of service and wage rate.

y ^ = 14.4 8.69 x 1 + 13.5 x 2

where

x1 = length of service (years)

x2 = wage rate (dollars)

y = job satisfaction test score (higher scores indicate greater job satisfaction)

A portion of the Excel Regression tool output follows.

Chapter 15, Problem 48SE, Recall that in exercise 45 the personnel director for Electronics Associates developed the following

  1. a. Complete the missing entries in this output.
  2. b. Using α = .05, test for overall significance.
  3. c. Did the estimated regression equation provide a good fit to the data? Explain.
  4. d. Use the t test and α = .05 to test H0: β1 = 0 and H0: β2 = 0.

45. The personnel director for Electronics Associates developed the following estimated regression equation relating an employee’s score on a job satisfaction test to his or her length of service and wage rate.

y ^ = 14.4 8.69 x 1 + 13.5 x 2

where

x1 = length of service (years)

x2 = wage rate (dollars)

y = job satisfaction test score (higher scores indicate greater job satisfaction)

  1. a. Interpret the coefficients in this estimated regression equation.
  2. b. Predict the job satisfaction test score for an employee who has four years of service and makes $6.50 per hour.
Blurred answer
Students have asked these similar questions
Suppose that for a typical FedEx package delivery, the cost of the shipment is a function of the weight of the package measured in ounces. You want to try to predict the cost of a typical shipment given package dimensions. If 10 packages in a city are sampled and the regression output is given below, report the regression equation. 1)  (cost of delivery) = 1.468*(weight) - 23.015   2)  (weight) = -23.015*(cost of delivery) + 1.468   3)  (cost of delivery) = -23.015*(weight) + 1.468   4)  (cost of delivery) = 1.468*(weight)   5)  (weight) = 1.468*(cost of delivery) - 23.015
A 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…
please only answer the last part "Suppose that real income per capita in New Jersey increases by​ 1% in the next year. Use the results in column​ (4) to predict the change in the number of traffic fatalities in the next year. "

Chapter 15 Solutions

Modern Business Statistics with Microsoft Office Excel (with XLSTAT Education Edition Printed Access Card)

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
Background pattern image
Statistics
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
SEE MORE QUESTIONS
Recommended textbooks for you
Text book image
College Algebra
Algebra
ISBN:9781305115545
Author:James Stewart, Lothar Redlin, Saleem Watson
Publisher:Cengage Learning
Text book image
Algebra & Trigonometry with Analytic Geometry
Algebra
ISBN:9781133382119
Author:Swokowski
Publisher:Cengage
Text book image
Algebra and Trigonometry (MindTap Course List)
Algebra
ISBN:9781305071742
Author:James Stewart, Lothar Redlin, Saleem Watson
Publisher:Cengage Learning
Text book image
College Algebra
Algebra
ISBN:9781938168383
Author:Jay Abramson
Publisher:OpenStax
Text book image
Glencoe Algebra 1, Student Edition, 9780079039897...
Algebra
ISBN:9780079039897
Author:Carter
Publisher:McGraw Hill
Text book image
College Algebra (MindTap Course List)
Algebra
ISBN:9781305652231
Author:R. David Gustafson, Jeff Hughes
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