Fred G. Hire is the manager of human resources at Crescent Custom Steel Products. As part of his yearly report to the CEO, he is required to present an analysis of the salaried employees. For each of the 30 salaried employees, he records monthly salary; service at Crescent, in months; age; gender (1 = male, 0 = female); and whether the employee has a management or engineering position. Those employed in management are coded 0, and those in engineering are coded 1. Using salary as the dependent variable and the other four as independent variables, perform a multiple regression analysis.

Sampled Employee Monthly Salary Length of Service Age Gender Job
1 $ 1,769 93 42 1 0
2 1,740 104 33 1 0
3 1,941 104 42 1 1
4 2,367 126 57 1 1
5 2,467 98 30 1 1
6 1,640 99 49 1 1
7 1,756 94 35 1 0
8 1,706 96 46 0 1
9 1,767 124 56 0 0
10 1,200 73 23 0 1
11 1,706 110 67 0 1
12 1,985 90 36 0 1
13 1,555 104 53 0 0
14 1,749 81 29 0 0
15 2,056 106 45 1 0
16 1,729 113 55 0 1
17 2,186 129 46 1 1
18 1,858 97 39 0 1
19 1,819 101 43 1 1
20 1,350 91 35 1 1
21 2,030 100 40 1 0
22 2,550 123 59 1 0
23 1,544 88 30 0 0
24 1,766 117 60 1 1
25 1,937 107 45 1 1
26 1,691 105 32 0 1
27 1,623 86 33 0 0
28 1,791 131 56 0 1
29 2,001 95 30 1 1
30 1,874 98 47 1 0

Click here for the Excel Data File

Complete the Analysis of Variance table. (Round SS, MS to nearest whole number and F and p-value to 3 decimal places.)



Complete the following table. (Negative amounts should be indicated by a minus sign. Round your answers 3 decimal places.)



a. Determine the regression equation, using salary as the dependent variable and the other four variables as independent variables. (Negative amounts should be indicated by a minus sign. Round your answers to 1 decimal place.)



b. What is the value of R2? (Round your answer to 3 decimal places.)



c-1. State the decision rule H0: β1 = β2 = β3 = β4 = 0 versus Hi: Not all βi's = 0 at 0.05 significance level. (Round your answer to 2 decimal places.)



c-2. Compute the value of F. (Round your answer to 2 decimal places.)



c-3. Determine whether any of the independent variables are different from 0.



d-1. Conduct an individual test and state the decision rule at 0.05 significance level. (Negative amounts should be indicated by a minus sign. Round your answers 2 decimal places.)



d-2. Determine whether any of the independent variables can be dropped.



Compute the regression analysis using the independent variables service and gender.

e-1. Complete an ANOVA table. (Round SS, MS to nearest whole number and F and p-value to 3 decimal places.)



e-2. Complete the following table. (Round "t" to 2 decimal places, "p-value" to 3 decimal places and "Coefficient", "Standard deviation" to 1 decimal place.)



e-3. How much more does a man earn per month than a woman? (Round your answer to 1 decimal place.)