Question

In: Statistics and Probability

The personnel director for a small manufacturing company has collected the data found in the table...

The personnel director for a small manufacturing company has collected the data found in the table 1 describing the salary (Y) earned by each machinist in the factory along with the average performance rating (X1) over the past 3 years, the years of service (X2), and the number of different machines each employee is certified to operate (X3).

The personnel director wants to build a regression model to estimate the average salary an employee should expect to receive based on his or her performance, years of service, and certifications.

a. Prepare three scatter plots showing the relationship between the salaries and each of the independent variables. What sort of relationship does each plot suggest?

b. If the personnel director wanted to build a regression model using only one independent variable to predict the salaries, what variable should be used?

c. If the personnel director wanted to build a regression model using only two independent variables to predict the salaries, what two variables should be used?

d. Compare the adjusted-R2 statistics obtained in parts b and c with that of a regression model using all three independent variables. Which model would you recommend that the personnel director use?

e. Suppose the personnel director chooses to use the regression function with all three independent variables. What is the estimated regression function?

f. Suppose the company considers an employee’s salary to be “fair” if it is within 1.5 standard errors of the value estimated by the regression function in part e. What salary range would be appropriate for an employee with 12 years of service, who has received average reviews of 4.5, and is certified to operate 4 pieces of machinery?

Obs

Salary

Avg Perf.

Years

Certifications

1

48.20

3.50

9

6

2

55.30

5.30

20

6

3

53.70

5.10

18

7

4

61.80

5.80

33

7

5

56.40

4.20

31

8

6

52.50

6.00

13

6

7

54.00

6.80

25

6

8

55.70

5.50

30

4

9

45.10

3.10

5

6

10

67.90

7.20

47

8

11

53.20

4.50

25

5

12

46.80

4.90

11

6

13

58.30

8.00

23

8

14

59.10

6.50

35

7

15

57.80

6.60

39

5

16

48.60

3.70

21

4

17

49.20

6.20

7

6

18

63.00

7.00

40

7

19

53.00

4.00

35

6

20

50.90

4.50

23

4

21

55.40

5.90

33

5

22

51.80

5.60

27

4

23

60.20

4.80

34

8

24

50.10

3.90

15

5

Solutions

Expert Solution

a. Prepare three scatter plots showing the relationship between the salaries and each of the independent variables. What sort of relationship does each plot suggest?

b. If the personnel director wanted to build a regression model using only one independent variable to predict the salaries, what variable should be used?

--->

Regression Analysis: Salary versus Avg Perf.

Analysis of Variance

Source DF Adj SS Adj MS F-Value P-Value
Regression 1 306.732 306.732 17.64 0.000
Avg Perf. 1 306.732 306.732 17.64 0.000
Error 22 382.528 17.388
Lack-of-Fit 21 379.883 18.090 6.84 0.294
Pure Error 1 2.645 2.645
Total 23 689.260


Model Summary

S R-sq R-sq(adj) R-sq(pred)
4.16985 44.50% 41.98% 33.65%


Coefficients

Term Coef SE Coef T-Value P-Value VIF
Constant 39.35 3.71 10.62 0.000
Avg Perf. 2.828 0.673 4.20 0.000 1.00


Regression Equation

Salary = 39.35 + 2.828 Avg Perf.

c. If the personnel director wanted to build a regression model using only two independent variables to predict the salaries, what two variables should be used?

----->   Avg Perf , Years

Regression Analysis: Salary versus Avg Perf., Years

Analysis of Variance

Source DF Adj SS Adj MS F-Value P-Value
Regression 2 570.53 285.263 50.45 0.000
Avg Perf. 1 62.46 62.458 11.05 0.003
Years 1 263.79 263.794 46.66 0.000
Error 21 118.73 5.654
Total 23 689.26


Model Summary

S R-sq R-sq(adj) R-sq(pred)
2.37781 82.77% 81.13% 78.06%


Coefficients

Term Coef SE Coef T-Value P-Value VIF
Constant 38.25 2.12 18.04 0.000
Avg Perf. 1.443 0.434 3.32 0.003 1.28
Years 0.3412 0.0500 6.83 0.000 1.28


Regression Equation

Salary = 38.25 + 1.443 Avg Perf. + 0.3412 Years

d. Compare the adjusted-R2 statistics obtained in parts b and c with that of a regression model using all three independent variables. Which model would you recommend that the personnel director use?

----->

model 1-41.98%  

model 2- 81.13%

model 2 is best model becuase Adjusted R-square higher that model 1


Related Solutions

For a sample of 8 employees, a personnel director has collected the following data on ownership...
For a sample of 8 employees, a personnel director has collected the following data on ownership of company stock versus years with the firm. x = 5 Years 6 12 14 6 9 13 15 9 y = 5 Shares 300 408 560 252 288 650 630 522 a. Regression eq: y=43.801+38.81X, where x=the number of years with the firm b. The standard error of estimate Sy,x=91.48. 1. The 95% confidence interval for x=10 for the average number of shares...
15.9 For a sample of 8 employees, a personnel director has collected the following data on...
15.9 For a sample of 8 employees, a personnel director has collected the following data on ownership of company stock versus years with the firm. x = 5 Years 6 12 14 6 9 13 15 9 y = 5 Shares 300 408 560 252 288 650 630 522 Determine the least-squares regression line and interpret its slope. For an employee who has been with the firm 10 years, what is the predicted number of shares of stock owned? For...
For a sample of 8 employees, a personnel director has collected the following data on ownership...
For a sample of 8 employees, a personnel director has collected the following data on ownership of company stock versus years with the firm. x = 5 Years 6 12 14 6 9 13 15 9 y = 5 Shares 300 408 560 252 288 650 630 522 Determine the least-squares regression line and interpret its slope. For an employee who has been with the firm 10 years, what is the predicted number of shares of stock owned? Please show...
A cost estimator for a construction company has collected the data found in the source file...
A cost estimator for a construction company has collected the data found in the source file Estimation.xlsx describing the total cost (Y) of 97 difference projects and the following 3 independent variables thought to exert relevant influence on the total cost: total units of work required (X1), contracted units of work per day (X2), and city/location of work (X3). The cost estimator would like to develop a regression model to predict the total cost of a project as a function...
Konza Company has collected the following cost and production data from their manufacturing operations over the...
Konza Company has collected the following cost and production data from their manufacturing operations over the past eight months. Period Units Produced Total costs (Sh) 1 2,200 10,500 2 3,100 12,750 3 5,600 18,500 4 1,700 9,250 5 6,300 20,750 6 8,100 25,250 7 5,050 17,625 8 3,000 12,500 (a) Using the high-low method ; i. Estimate the fixed production costs, ii. Estimate the variable production cost per unit, (b) Establish a cost estimating function for the total production costs....
Consider the table of data collected for the reaction A → Products.
Consider the table of data collected for the reaction A → Products. Determine the magnitude (value) of the reaction rate constant by graphing the data appropriately. 
a)The sales director has suggested using Big Data collected from market research and consumer activity on...
a)The sales director has suggested using Big Data collected from market research and consumer activity on social media. Critically evaluate the use of Big Data for sales forecasting b) Critically evaluate the usefulness of learning curve theory in the setting of selling prices. c) Critically evaluate the usefulness of management accounting techniques for decision making when future conditions are uncertain
Please Fiil out the table Woh Che Co. has four departments: materials, personnel, manufacturing, and packaging....
Please Fiil out the table Woh Che Co. has four departments: materials, personnel, manufacturing, and packaging. In a recent month, the four departments incurred three shared indirect expenses. The amounts of these indirect expenses and the bases used to allocate them follow. Indirect Expense Cost Allocation Base Supervision $ 83,300 Number of employees Utilities 58,000 Square feet occupied Insurance 26,500 Value of assets in use Total $ 167,800 Departmental data for the company’s recent reporting period follow. Department Employees Square...
A digital camera manufacturing company has the cost data given in the following table: Sales price...
A digital camera manufacturing company has the cost data given in the following table: Sales price $783 Units sold 29,669 Direct labor $1,503,075 Materials $6,348,961 Overhead $2,614,707 Total operating expense $2,740,386 % Profit Calculate the percentage profit
The Director of Sales purposefully collected data on two variables. These variables are simply identified as...
The Director of Sales purposefully collected data on two variables. These variables are simply identified as Y and X. Data on these two variables are summarized in the table presented below. Variable Y        Variable X 24 28 25 20 26 22 29 33 24 18 26 30 24 29 19 28 24 19 24 20 21 24 25 14 The Director approaches the Research Division for a validation of the speculative argument that ρ = 0, in the association...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT