The Human Resources Manager for Optilytics LLC is evaluating applications for the position of Senior Data Scientist. The file Optilyticstle presents summary data of the applicants for the position. Click on the datafile logo to reference the data. DATA (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 achleved. Use this joint probability table to answer the questions below. If required, round your answers to two decimal places. (b) What are the marginal probablities? If required, round your answers to four decimal places. What do they tel you about the probabilties 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. \begin{tabular}{llll} Grand Total & (3) & %(%) \\ \hline \end{tabular} What are the marginal probabilities? If required, round your answers to four decimal places. 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 probablity that the highest degree completed by the applicant is a PhD? If required, round your answer to four decimal places. (3) (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. (3) The Human Resources Manager for Optilytics LLC is evaluating applications for the position of Senior Data Scientist. The file Optilyticstle presents summary data of the applicants for the position. Click on the datafile logo to reference the data. DATA (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 achleved. Use this joint probability table to answer the questions below. If required, round your answers to two decimal places. (b) What are the marginal probablities? If required, round your answers to four decimal places. What do they tel you about the probabilties 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. \begin{tabular}{llll} Grand Total & (3) & %(%) \\ \hline \end{tabular} What are the marginal probabilities? If required, round your answers to four decimal places. 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 probablity that the highest degree completed by the applicant is a PhD? If required, round your answer to four decimal places. (3) (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. (3)