7. Senior Data Scientist Position Applicants. The Human Resources Manager for Optilytics LLC is evaluating applications for the position of Senior Data Scientist. The file OptilyticsLLC presents summary data of the applicants for the position.

Use a PivotTable in Excel to create a joint probability table showing the probabilities associated with a randomly selected applicant’s sex and highest degree achieved. Use this joint probability table to answer the questions below.

b. What are the marginal probabilities? What do they tell you about the probabilities associated with the sex of applicants and highest degree completed by applicants?

c. If the applicant is female, what is the probability that the highest degree completed by the applicant is a PhD?

d. If the highest degree completed by the applicant is a bachelor’s degree, what is the probability that the applicant is male?

e. What is the probability that a randomly selected applicant will be a male whose highest completed degree is a PhD?