The Human Resources Manager for Optilytics LLC is evaluating applications for the position of Senior Data Scientist. The file OptiyticsicC presents summary data of the applicants for the position. Click on the datafile logo to reference the data. DATA (a) Use a Pivotiable 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 piaces. (b) What are the marginal probabilites? If required, round your answers to four decimal places- What do they teil you about the probabilies associated with the sex of applicants and highest degree completed by appicants? There is a higher probability that a randomiy selected applicant is The most likely highest degree compoted br a mond bpplicant is a There is a relatively low probability of a randemer pelected opplcant Raving completed a decimal places. What do they tell you about the probabilities associated with the sex of applicants and highest degree completed by applicants? There is a higher probability that a randomly selected applicant is The most likely highest deyree completed by a random applicant is a There is a relatively low probability of a randomly selected applicant having completed a (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 probabuty 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 rour answer to four. decimal places