Copy of Equal_Pay___Student_Rev_3 for BUS308.xls - Count of Gr Gr Total A 15 B 7 C 5 D 5 E 12 F 6 Grand Total 50 ID 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15

Copy of Equal_Pay___Student_Rev_3 for BUS308.xls - Count of...

This preview shows page 1 - 8 out of 23 pages.

Count of Gr Gr Total A 15 B 7 C 5 D 5 E 12 F 6 Grand Total 50
Image of page 1

Subscribe to view the full document.

ID Sal Compa Mid Age EES SR G Raise Deg Gen1 1 58 1.017 57 34 85 8 0 5.7 0 M 2 27 0.870 31 52 80 7 0 3.9 0 M 3 34 1.096 31 30 75 5 1 3.6 1 F 4 66 1.157 57 42 100 16 0 5.5 1 M 5 47 0.979 48 36 90 16 0 5.7 1 M 6 76 1.134 67 36 70 12 0 4.5 1 M 7 41 1.025 40 32 100 8 1 5.7 1 F 8 23 1.000 23 32 90 9 1 5.8 1 F 9 77 1.149 67 49 100 10 0 4 1 M 10 22 0.956 23 30 80 7 1 4.7 1 F 11 23 1.000 23 41 100 19 1 4.8 1 F 12 60 1.052 57 52 95 22 0 4.5 0 M 13 42 1.050 40 30 100 2 1 4.7 0 F 14 24 1.043 23 32 90 12 1 6 1 F 15 24 1.043 23 32 80 8 1 4.9 1 F 16 47 1.175 40 44 90 4 0 5.7 0 M 17 69 1.210 57 27 55 3 1 3 1 F 18 36 1.161 31 31 80 11 1 5.6 0 F 19 24 1.043 23 32 85 1 0 4.6 1 M 20 34 1.096 31 44 70 16 1 4.8 0 F 21 76 1.134 67 43 95 13 0 6.3 1 M 22 57 1.187 48 48 65 6 1 3.8 1 F 23 23 1.000 23 36 65 6 1 3.3 0 F 24 50 1.041 48 30 75 9 1 3.8 0 F 25 24 1.043 23 41 70 4 0 4 0 M 26 24 1.043 23 22 95 2 1 6.2 0 F 27 40 1.000 40 35 80 7 0 3.9 1 M 28 75 1.119 67 44 95 9 1 4.4 0 F 29 72 1.074 67 52 95 5 0 5.4 0 M 30 49 1.020 48 45 90 18 0 4.3 0 M 31 24 1.043 23 29 60 4 1 3.9 1 F 32 28 0.903 31 25 95 4 0 5.6 0 M 33 64 1.122 57 35 90 9 0 5.5 1 M 34 28 0.903 31 26 80 2 0 4.9 1 M 35 24 1.043 23 23 90 4 1 5.3 0 F 36 23 1.000 23 27 75 3 1 4.3 0 F 37 22 0.956 23 22 95 2 1 6.2 0 F 38 56 0.982 57 45 95 11 0 4.5 0 M 39 35 1.129 31 27 90 6 1 5.5 0 F 40 25 1.086 23 24 90 2 0 6.3 0 M 41 43 1.075 40 25 80 5 0 4.3 0 M 42 24 1.043 23 32 100 8 1 5.7 1 F 43 77 1.149 67 42 95 20 1 5.5 0 F 44 60 1.052 57 45 90 16 0 5.2 1 M 45 55 1.145 48 36 95 8 1 5.2 1 F
Image of page 2
46 65 1.140 57 39 75 20 0 3.9 1 M 47 62 1.087 57 37 95 5 0 5.5 1 M 48 65 1.140 57 34 90 11 1 5.3 1 F 49 60 1.052 57 41 95 21 0 6.6 0 M 50 66 1.157 57 38 80 12 0 4.6 0 M
Image of page 3

Subscribe to view the full document.

Gr E The ongoing question that the weekly assignments will focus on is: Are males a B Note: to simplfy the analysis, we will assume that jobs within each grade compri B E The column labels in the table mean: D ID – Employee sample number Sal – Salary in thousands F Age – Age in years EES – Appraisal rating (Employee evalu C SER – Years of service G – Gender (0 = male, 1 = female) A Mid – salary grade midpoint Raise – percent of last raise F Grade – job/pay grade Deg (0= BS\BA 1 = MS) A Gen1 (Male or Female) Compa - salary divided by midpoint A E C A A C E B A B F D A D A A C F F D A B E B A A A E B A C A F E D
Image of page 4
E E E E E
Image of page 5

Subscribe to view the full document.

and females paid the same for equal work (under the Equal Pay Act)? ise equal work. uation score)
Image of page 6
Week 1. Describing the data. 1. Using the Excel Analysis ToolPak function descriptive statistics, generate descriptive statistics for the Which variables does this function not work properly for, even though we have some excel generated re Descriptives Sal Compa Mid Age Mean 45 1.06248 41.76 35.72 Standard Error 2.715 0.011 2.295 1.167 Median 42.5 1.051 40 35 Mode 24 1.043 23 32 Standard Deviation 19.201 0.077 16.231 8.251 Sample Variance 368.694 0.006 263.451 68.083 Kurtosis (1.445) (0.175) (1.517) (0.775) Skewness 0.238 (0.317) 0.161 0.262 Range 55 0.34
Image of page 7

Subscribe to view the full document.

Image of page 8
  • Fall '19

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern

Ask Expert Tutors You can ask 0 bonus questions You can ask 0 questions (0 expire soon) You can ask 0 questions (will expire )
Answers in as fast as 15 minutes