What is the probability that a female picked at random makes between 30K and 40K

What is the probability that a female picked at random makes between 30K and 40K

Refer to the Excel file Salary (attached) to address all the questions below:

1. What is the probability for:

a.) Randomly selecting a person being a male in Grade E?

b.) Given that we picked a random person and he was a male, what is the probability of being in grade E?

c.) Why the results different?

2. Consider each group (Male and Female separately) and assume the salaries follow a Normal Probability distribution:

a.) What is the top 75th percentile of salary for Males?

b.) What is the top 75th percentile of salary for Females?

c.) What is the probability that a male picked at random makes more than 50K?

d.) What is the probability that a female picked at random makes between 30K and 40K?

……………..Answer preview……………………….

The results are different because the for the first case, the selection is being done on the whole group of employees hence the probability of selecting a male in grade E is low but in the second case, the selection is being done on a specific group………………………..