Calculating Deceptive Statistics, business and finance homework help

Refer to the Excel file Salary (attached to the assignment) 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?