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.
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. Sampled Monthly Length of Employee SalaryY Service Page Gender Job 1 $_,']'69 93 42 1 0 2 _,1'40 104 33 1 0 3 _,941 104 42 1 1 4 2,36\"! 126 5? 1 1 5 2,46? 98 30 1 1 6 3,640 99 49 1 1 '1' 3,756 94 35 1 0 8 _ ,706 96 46 0 1 9 _,?6T 124 56 0 0 10 _,200 T3 23 0 1 11 _,1'06 110 6? 0 1 12 1,985 90 36 0 1 13 3,555 104 53 0 0 14 3,749 81 29 0 0 15 2,056 106 45 1 0 16 _ ,729 113 55 0 1 1'? 2,186 129 46 1 1 18 _,858 9? 39 0 1 19 _,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 3,544 88 30 0 0 24 _ ,766 117 60 1 1 25 _ ,93? 107 45 1 1 26 _,691 105 32 0 1 2'? _,623 86 33 0 0 28 _,']'91 131 56 0 1 29 2,001 95 30 1 1 30 3,81'4 98 47 1 0 Complete the following table. {Negative amounts should be indicated by a minus sign. Round your answers 3 decimal places.) Complete the Analysis of Variance table. [Round 55, M5 to nearest whole number and Fand p-ualue to 3 decimal places.) Regression Error 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.) -:I:-:-:-:- b. What is the value of 92? {Round your answer to 3 decimal places.) l c-1- State the decision rule H0131 = B; = [33 = [34 = 0 versus Hi: Not all Bi's = 0 at 0.05 signicance level. [Round your answer to 2 decimal places} _:I c-Z 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.) Reject Ho ift ort > d-2. Determine whether any of the independent variables can be dropped. should be dropped.Compute the regression analysis using the independent variables service and gender. e-1. Complete the following table. (Round "?" to 2 decimal places, "p-value" to 3 decimal places and "Coefficient", "Standard deviation" to 1 decimal place.) Predictor Coefficient Standard deviation p-value Constant Service Gender e-2. Complete an ANOVA table. (Round SS, MS to nearest whole number and F and p-value to 3 decimal places.) Source DF SS MS F p-value Regression Error Total e-3. How much more does a man earn per month than a woman? (Round your answer to the nearest dollar amount.) A man earns more per month than a woman