excel spreadsheet - https://drive.google.com/file/d/1PKbK0pNTiWwIeLDikUUD1js36asleJ5o/view?usp=sharing

(a) 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. If required, round your answers to two decimal places. Count of Applicant Number Column Labels Row Labels Female Male Grand Total Bachelor's o/o Master's PhD Grand Total % o/ (b) What are the marginal probabilities? If required, round your answers to four decimal places. P(Female) P(Male) P(Bachelor's) P(Master's) P(PHD) What do they tell you about the probabilities associated with the sex of applicants and highest degree completed by applicants? The input in the box below will not be graded, but may be reviewed and considered by your instructor. (c) If the applicant is female, what is the probability that the highest degree completed by the applicant is a PhD? If required, round your answer to four decimal places. (d) If the highest degree completed by the applicant is a bachelor's degree, what is the probability that the applicant is male? If required, round your answer to four decimal places. (e) What is the probability that a randomly selected applicant will be a male whose highest completed degree is a PhD? If required, round your answer to four decimal places