ID 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 Sal 34 41 23 22 23 42 24 24 69 36 34 57 23 50 24 75 24 24 23 22 35 24 77 55 65 58 27 66 47 76 77 60 47 24 76 24 40 72 49 28 64 Compa 1,096 1,025 1,000 0,956 1,000 1,050 1,043 1,043 1,210 1,161 1,096 1,187 1,000 1,041 1,043 1,119 1,043 1,043 1,000 0,956 1,129 1,043 1,149 1,145 1,140 1,017 0,870 1,157 0,979 1,134 1,149 1,052 1,175 1,043 1,134 1,043 1,000 1,074 1,020 0,903 1,122 Mid 31 40 23 23 23 40 23 23 57 31 31 48 23 48 23 67 23 23 23 23 31 23 67 48 57 57 31 57 48 67 67 57 40 23 67 23 40 67 48 31 57 Age 30 32 32 30 41 30 32 32 27 31 44 48 36 30 22 44 29 23 27 22 27 32 42 36 34 34 52 42 36 36 49 52 44 32 43 41 35 52 45 25 35 EES 75 100 90 80 100 100 90 80 55 80 70 65 65 75 95 95 60 90 75 95 90 100 95 95 90 85 80 100 90 70 100 95 90 85 95 70 80 95 90 95 90 SR 5 8 9 7 19 2 12 8 3 11 16 6 6 9 2 9 4 4 3 2 6 8 20 8 11 8 7 16 16 12 10 22 4 1 13 4 7 5 18 4 9 G 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Raise 3,6 5,7 5,8 4,7 4,8 4,7 6 4,9 3 5,6 4,8 3,8 3,3 3,8 6,2 4,4 3,9 5,3 4,3 6,2 5,5 5,7 5,5 5,2 5,3 5,7 3,9 5,5 5,7 4,5 4 4,5 5,7 4,6 6,3 4 3,9 5,4 4,3 5,6 5,5 Deg 1 1 1 1 1 0 1 1 1 0 0 1 0 0 0 0 1 0 0 0 0 1 0 1 1 0 0 1 1 1 1 0 0 1 1 0 1 0 0 0 1 Gen1 F F F F F F F F F F F F F F F F F F F F F F F F F M M M M M M M M M M M M M M M M Gr B C A A A C A A E B B D A D A F A A A A B A F D E E B E D F F E C A F A C F D B E 42 43 44 45 46 47 48 49 50 28 56 25 43 60 65 62 60 66 0,903 0,982 1,086 1,075 1,052 1,140 1,087 1,052 1,157 31 57 23 40 57 57 57 57 57 26 45 24 25 45 39 37 41 38 80 95 90 80 90 75 95 95 80 2 11 2 5 16 20 5 21 12 0 0 0 0 0 0 0 0 0 4,9 4,5 6,3 4,3 5,2 3,9 5,5 6,6 4,6 1 0 0 0 1 1 1 0 0 M M M M M M M M M B E A C E E E E E The ongoing question that the weekly assignments will focus on is: Are males and females paid the same for equa Note: to simplfy the analysis, we will assume that jobs within each grade comprise equal work. The column labels in the table mean: ID – Employee sample number Sal – Salary in thousands Age – Age in years EES – Appraisal rating (Employee evaluation score) SER – Years of service G – Gender (0 = male, 1 = female) Mid – salary grade midpoint Raise – percent of last raise Grade – job/pay grade Deg (0= BS\BA 1 = MS) Gen1 (Male or Female) Compa - salary divided by midpoint, a measure of salary that removes th This data should be treated as a sample of employees taken from a company that has about 1,000 employees using a random sampling approach. Mac Users: The homework in this course assumes students have Windows Excel, and can load the Analysis ToolPak into their version of Excel. The analysis tool pak has been removed from Excel for Windows, but a free third-party tool that can be used (found on an answers Microsoft site) is: http://www.analystsoft.com/en/products/statplusmacle Like the Microsoft site, I make cannot guarantee the program, but do know that Statplus is a respected statistical package. You may use other approaches or tools as desired to complete the assignments. nd females paid the same for equal work (under the Equal Pay Act)? Week 1. Describing the data. rate and show the descriptive statistics for each appropriate variable in the sample data set. ectly for? Why? SR G 8,96 0,809 8 8 5,718 32,692 -0,399 0,728 21 1 22 448 50 Raise 0,5 0,071 0,5 0 0,505 0,255 -2,085 0,000 1 0 1 25 50 4,938 0,123 4,9 5,7 0,867 0,752 -0,794 -0,164 3,6 3 6,6 246,9 50 Deg 0,5 0,071 0,5 0 0,505 0,255 -2,085 0,000 1 0 1 25 50 ill not work on non numerical numbers, so the Gen 1 and grade columns will not work. ndard deviation unctions (average and stdev). cond one only counts males. es: .337,-1.406,.788, -0.281,1.350,1.406,.450,-0.281,-1.575,1.350,-1.575,-0.675,1.125,-0.169,-1.350,0.675, -1.350,0.225,-1.519,-0.5 Week 2 Testing means with the t-test
Purchase answer to see full attachment