(Answered): (a) Use a PivotTable in Excel to create a joint probability table showing the probabilities associa ...

(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 Bachelor's 32.33 51.88 Grand Total % % % 19.55 Master's % % % 15.79 25.56 41.35 PhD % % % 2.26 4.51 6.77 Grand Total O % % 37.59 62.41 100 % (b) What are the marginal probabilities? If required, round your answers to four decimal places. P(Female) P(Male) 11 P(Bachelor's) P(Master's) P(PhD) Il 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 ? A blank (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. 2 (d) If the highest degree completed by the applicant is a bachelor's degree, what is the apter 5.1 -5.3 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 blank (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. 2 (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. Hide Feedback Partially Correct Check My Work 0 Icon Key I.P. G F T YE. F K L H G J Grand Total COUNTA of Highest Degree Achieved Gender Bachelor's Master's PhD Female 26 21 Male 43 34 Grand Tota 69 55 3 6 50 83 133 9