Applicant Number Highest Degree Achieved Gender Work Experience (Years) 1001 Bachelor's Male 1002 Bachelor's Male - m 1003 Master's Female 1004 Master's Male 1005 Bachelor's Male 1006 Master's Male 1007 Master's Male 1008 Master's Male 1009 Bachelor's Male 1010 Bachelor's Female 1011 Bachelor's Female 1012 Bachelor's Male 1013 Master's Male 1014 Bachelor's Male 1015 Bachelor's Male 1016 Master's Male 1017 Master's Male 1018 Master's Female 1019 Bachelor's Male 1020 Master's Female 1021 Bachelor's Male 1022 Master's Male 1023 Bachelor's Male 1024 Bachelor's Male 1025 Master's Female 1026 Master's Male 1027 Bachelor's Male 1028 Bachelor's Female 1029 Bachelor's Female on 1030 Bachelor's Male 1031 Bachelor's Male 1032 Master's Female 1033 Master's Female 1034 Master's Male 1035 Bachelor's Female 103 Bachelor's Female 1037 Bachelor's Male 1038 Bachelor's Male 1039 Bachelor's Female 1040 Bachelor's Female 1041 Bachelor's Female 1042 Master's Male 1043 Bachelor's Female 1044 Master's Female NanNNin 1045 Bachelor's Female 1046 Master's Female 1047 Bachelor's Male 1048 Master's Female 1049 Master's Female 1050 Master's Male 1051 Bachelor's Male 1052 Bachelor's Male 1053 Bachelor's Male in 1054 Bachelor's FemalePaste "?" v v v G30 X 11 1 110 Master's Male 112 1111 Master's Male 11 1112 Master's Male 114 1113 Master's Male 1114 PhD Female 11 1115 Bachelor's Male 11 1116 PhD Female 11 1117 Bachelor's Female 119 1118 PhD Male 120 1119 Bachelor's Male 121 1120 Bachelor's Female 122 1121 Master's Female 123 1122 Master's Male 124 1123 Bachelor's Male 125 1124 Bachelor's Male b mr 126 1125 Bachelor's Male 127 1126 Master's Male Do In 128 1127 Master's Male 129 1128 Master's Male 130 1 129 Master's Female 131 1130 Bachelor's Male 132 1131 PhD Female 133 1132 Master's Male 134 1133 Master's Female 135(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.U A 1055 Bachelor's Female 1056 Master's Male 1057 Bachelor's Male 1058 Bachelor's Female 1059 PhD Male 1060 Master's Female 1061 PhD Male 1062 Bachelor's Male 1063 Bachelor's Male 1064 Master's Female 1065 Bachelor's Female 1066 Master's Male 1067 Master's Male 1068 Master's Male 1069 Bachelor's Male 1070 Bachelor's Male 107 Bachelor's Female 1072 Master's Male mining 1073 Bachelor's Female 1074 Bachelor's Male 1075 Bachelor's Male 1076 Bachelor's Male 1077 Master's Male 1078 Master's Female 1079 Master's Female 1080 Bachelor's Male 1081 Master's Male 1082 Master's Male 1083 PhD Male 1084 PhD Male 1085 Master's Male 1086 Master's Female 1087 PhD Male 1088 Bachelor's Male 1089 Bachelor's Male 1090 Bachelor's Female 1091 Bachelor's Male 1092 Master's Female 1093 Bachelor's Female 1094 Bachelor's Male 1095 Bachelor's Female 1096 Bachelor's Female 1097 Master's Female 1098 Bachelor's Male 1099 Master's Male 1100 Master's Male 102 1101 Master's Male 103 1 102 Bachelor's Female ONIN 104 1103 Bachelor's Female 105 1104 Master's Female 106 1105 Bachelor's Male 107 1 106 Bachelor's Female 108 1107 Bachelor's Male 109 1108 Bachelor's Male 110 1109 Master's Male Data