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 Salary Service Age Gender- Job 1 $1,769 93 42 1 8 2 1, 746 184 33 1 8 3 1,941 184 42 1 1 4 2,367 126 57 1 1 5 2,467 98 36 1 1 5 1, 646 99 49 1 1 7 1,755 94 35 1 8 8 1, 786 96 46 8 1 9 1,767 124 56 8 8 18 1, 286 73 23 8 1 11 1,785 110 57 8 1 12 1, 985 98 36 8 1 13 1, 555 184 53 B 8 14 1, 749 81 29 8 8 15 2,855 185 45 1 8 16 1, 729 113 55 8 1 17 2,185 129 46 1 1 18 1, 858 97 39 8 1 19 1,819 181 43 1 1 28 1, 356 91 35 1 1 21 2 .836 180 46 1 8 22 2, 556 123 59 1 6 23 1, 54-4 83 38 6 6 24 1, 766 117 66 1 1 25 1, 937 167 45 1 1 26 1, 691 165 32 8 1 27 1, 623 86 33 8 8 28 1, 791 131 56 8 1 29 2, 861 95 39 1 1 36 1, 874 98 47 1 6 Epicture Click here for the Excel Data File Complete the following table. (Negative values should be indicated by a minus sign. Round your answers 3 decimal places.) Constant Complete the Analysis of Variance table. (Round SS, MS to nearest whole number and Fand Pto 3 decimal places.) Regression 3. Determine the regression equation, using salary as the dependent variable and the other four variables as independent variables. (Negative values should be indicated by a minus sign. Round your answers to 1 decimal place.) l-:II:-:l-:l-:- b. What is the value of R2? (Round your answer to 3 decimal places.) _; c-1. State the decision rule He: [31 = [32 = [33 = [34 = 0 versus Hi: Not all Bi'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 values 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. Q e-1. Complete the following table. (Round "t-ratio" to 2 decimal places, "p" to 3 decimal places and "Coefficient", "Standard deviation" to 1 decimal place.) Predictor Coefficient Standard deviation t p-value Constant Service Gender e-2. Complete an ANOVA table. (Round SS, MS to nearest whole number and Fand Pto 3 decimal places.) Source DF SS MS F p-value Regression Error Totale-3. How much more does a man earn per month than a woman? (Round your answer to the nearest dollar amount.)