Assignment
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?
Attachment:- Spreadsheet.rar