finweek2dq2 - ID Salary Compa Midpoint Age 1 2 3 4 5 6 7 8...

This preview shows page 1 - 4 out of 6 pages.

IDSalaryCompaMidpoint AgeService GenderRaiseDegreeGr165.51.149573485805.70METhe ongoing question that the weekly assignments w227.80.897315280703.90MBNote: to simplfy the analysis, we will assume that job336.41.173313075513.61FB456.30.98857421001605.51METhe column labels in the table mean:547.90.9984836901605.71MDID – Employee sample number Salary – S674.81.1176736701204.51MFAge – Age in yearsPerforman741.51.0374032100815.71FCService – Years of service (rounded)Gender – 08241.044233290915.81FAMidpoint – salary grade midpoint Raise – pe977.11.151674910010041MFGrade – job/pay gradeDegree (0=1023.41.016233080714.71FAGender1 (Male or Female)Compa - s11231.00023411001914.81FA1262.21.0915752952204.50ME1341.41.0344030100214.70FC1423.71.02923329012161FA1522.70.985233280814.91FA16370.926404490405.70MC1769.31.2165727553131FE1834.81.1223131801115.60FB19241.045233285104.61MA2033.31.0753144701614.80FB2175.31.1246743951306.31MF2243.70.910484865613.81FD2322.50.977233665613.30FA2452.81.100483075913.80FD2523.71.0322341704040MA2622.90.994232295216.20FA2740.51.012403580703.91MC2876.41.141674495914.40FF2978.61.173675295505.40MF3047.60.9924845901804.30MD3121.80.947232960413.91FA32280.904312595405.60MB3363.81.120573590905.51ME34280.903312680204.91MB3523.91.039232390415.30FA3622.20.966232775314.30FA3722.10.962232295216.20FA3858.61.0285745951104.50ME3935.71.152312790615.50FB4023.91.041232490206.30MA4145.91.148402580504.30MC4223.61.0282332100815.71FA4376.81.1476742952015.50FF4468.31.1995745901605.21ME4560.11.253483695815.21FD4659.61.0455739752003.91ME4767.11.178573795505.51ME4863.81.1195734901115.31FE4960.11.0545741952106.60ME5059.21.0395738801204.60MEPerformance RatingGender1
will focus on is: Are males and females paid the same for equal work (under the Equal Pay Act)? bs within each grade comprise equal work.Salary in thousands nce Rating - Appraisal rating (employee evaluation score)0 = male, 1 = female ercent of last raise= BS\BA 1 = MS)salary divided by midpoint
Score:Week 2

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture