need it asap

ID Salary Compa Midpoint Age Performance Rating

Service Gender Raise Degree Gender1 Gr

1 65.5 1.149 57 34 85 8 0 5.7 0 M E The ongoing question that the weekly assignments will focus on is: Are males and females paid the same for equal work (under the Equal Pay Act)? 2 27.8 0.897 31 52 80 7 0 3.9 0 M B Note: to simplfy the analysis, we will assume that jobs within each grade comprise equal work. 3 36.4 1.173 31 30 75 5 1 3.6 1 F B 4 56.3 0.988 57 42 100 16 0 5.5 1 M E The column labels in the table mean: 5 47.9 0.998 48 36 90 16 0 5.7 1 M D ID – Employee sample number Salary – Salary in thousands 6 74.8 1.117 67 36 70 12 0 4.5 1 M F Age – Age in years Performance Rating - Appraisal rating (employee evaluation score) 7 41.5 1.037 40 32 100 8 1 5.7 1 F C Service – Years of service (rounded) Gender – 0 = male, 1 = female 8 24 1.044 23 32 90 9 1 5.8 1 F A Midpoint – salary grade midpoint Raise – percent of last raise 9 77.1 1.151 67 49 100 10 0 4 1 M F Grade – job/pay grade Degree (0= BS\BA 1 = MS)

10 23.4 1.016 23 30 80 7 1 4.7 1 F A Gender1 (Male or Female) Compa - salary divided by midpoint 11 23 1.000 23 41 100 19 1 4.8 1 F A 12 62.2 1.091 57 52 95 22 0 4.5 0 M E 13 41.4 1.034 40 30 100 2 1 4.7 0 F C 14 23.7 1.029 23 32 90 12 1 6 1 F A 15 22.7 0.985 23 32 80 8 1 4.9 1 F A 16 37 0.926 40 44 90 4 0 5.7 0 M C 17 69.3 1.216 57 27 55 3 1 3 1 F E 18 34.8 1.122 31 31 80 11 1 5.6 0 F B 19 24 1.045 23 32 85 1 0 4.6 1 M A 20 33.3 1.075 31 44 70 16 1 4.8 0 F B 21 75.3 1.124 67 43 95 13 0 6.3 1 M F 22 43.7 0.910 48 48 65 6 1 3.8 1 F D 23 22.5 0.977 23 36 65 6 1 3.3 0 F A 24 52.8 1.100 48 30 75 9 1 3.8 0 F D 25 23.7 1.032 23 41 70 4 0 4 0 M A 26 22.9 0.994 23 22 95 2 1 6.2 0 F A 27 40.5 1.012 40 35 80 7 0 3.9 1 M C 28 76.4 1.141 67 44 95 9 1 4.4 0 F F 29 78.6 1.173 67 52 95 5 0 5.4 0 M F 30 47.6 0.992 48 45 90 18 0 4.3 0 M D 31 21.8 0.947 23 29 60 4 1 3.9 1 F A 32 28 0.904 31 25 95 4 0 5.6 0 M B 33 63.8 1.120 57 35 90 9 0 5.5 1 M E 34 28 0.903 31 26 80 2 0 4.9 1 M B 35 23.9 1.039 23 23 90 4 1 5.3 0 F A 36 22.2 0.966 23 27 75 3 1 4.3 0 F A

Sheet1Data