With the attachment, need help with week 1, problem 4. 4 A key issue in comparing data sets is to see if they are distributed/shaped the same. We can do this by looking at some measures of where some selected values are within each data set – that is how many values are above and below a comparable value. For each group (overall, females, and males) find: Overall Female Male A The value that cuts off the top 1/3 salary value in each group “=large” function i The z score for this value within each group? Excel’s standize function ii The normal curve probability of exceeding this score: 1-normsdist function iii What is the empirical probability of being at or exceeding this salary value? B The value that cuts off the top 1/3 compa value in each group. i The z score for this value within each group? ii The normal curve probability of exceeding this score: iii What is the empirical probability of being at or exceeding this compa value? C How do you interpret the relationship between the data sets? What do they mean about our equal pay for equal work question?