The department chair has the candidate data set shown on the left hand side for the position advertised. a. Make a pivot table and make joint probability table showing the probabilities associated with a randomly selected applicant's sex and highest degree achieved. Plz give me step by step answer of how your made the pivot and the joint probability table . Use this joint probability table to answer the questions below.

b. 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.

c. What are the marginal probabilities? What do they tell you about the probabilities associated with the sex of applicants and highest degree completed by applicants?

d. If the highest degree completed by the applicant is a bachelor's degree, what is the probability that the applicant is male?

e. If the applicant is female, what is the probability that the highest degree completed by the applicant is a PhD?

f. What is the probability that a randomly selected applicant will be a male whose highest completed degree is a PhD?

Applicant Number	Highest Degree Achieved	Gender	Work Experience (Years)
1001	Bachelor's	Male	8
1002	Bachelor's	Male	1
1003	Master's	Female	3
1004	Master's	Male	6
1005	Bachelor's	Male	7
1006	Master's	Male	7
1007	Master's	Male	9
1008	Master's	Male	1
1009	Bachelor's	Male	8
1010	Bachelor's	Female	8
1011	Bachelor's	Female	9
1012	Bachelor's	Male	7
1013	Master's	Male	4
1014	Bachelor's	Male	6
1015	Bachelor's	Male	9
1016	Master's	Male	9
1017	Master's	Male	6
1018	Master's	Female	5
1019	Bachelor's	Male	7
1020	Master's	Female	0
1021	Bachelor's	Male	4
1022	Master's	Male	8
1023	Bachelor's	Male	4
1024	Bachelor's	Male	4
1025	Master's	Female	3
1026	Master's	Male	0
1027	Bachelor's	Male	8
1028	Bachelor's	Female	0
1029	Bachelor's	Female	4
1030	Bachelor's	Male	1
1031	Bachelor's	Male	5
1032	Master's	Female	3
1033	Master's	Female	0
1034	Master's	Male	8
1035	Bachelor's	Female	4
1036	Bachelor's	Female	6
1037	Bachelor's	Male	3
1038	Bachelor's	Male	4
1039	Bachelor's	Female	4
1040	Bachelor's	Female	0
1041	Bachelor's	Female	3
1042	Master's	Male	2
1043	Bachelor's	Female	8
1044	Master's	Female	5
1045	Bachelor's	Female	2
1046	Master's	Female	2
1047	Bachelor's	Male	5
1048	Master's	Female	1
1049	Master's	Female	5
1050	Master's	Male	7
1051	Bachelor's	Male	2
1052	Bachelor's	Male	5
1053	Bachelor's	Male	1
1054	Bachelor's	Female	5
1055	Bachelor's	Female	7
1056	Master's	Male	5
1057	Bachelor's	Male	5
1058	Bachelor's	Female	6
1059	PhD	Male	4
1060	Master's	Female	4
1061	PhD	Male	5
1062	Bachelor's	Male	5
1063	Bachelor's	Male	1
1064	Master's	Female	2
1065	Bachelor's	Female	6
1066	Master's	Male	9
1067	Master's	Male	7
1068	Master's	Male	6
1069	Bachelor's	Male	3
1070	Bachelor's	Male	9
1071	Bachelor's	Female	3
1072	Master's	Male	5
1073	Bachelor's	Female	5
1074	Bachelor's	Male	8
1075	Bachelor's	Male	6
1076	Bachelor's	Male	7
1077	Master's	Male	5
1078	Master's	Female	5
1079	Master's	Female	7
1080	Bachelor's	Male	2
1081	Master's	Male	0
1082	Master's	Male	6
1083	PhD	Male	5
1084	PhD	Male	6
1085	Master's	Male	9
1086	Master's	Female	2
1087	PhD	Male	8
1088	Bachelor's	Male	1
1089	Bachelor's	Male	2
1090	Bachelor's	Female	6
1091	Bachelor's	Male	0
1092	Master's	Female	6
1093	Bachelor's	Female	7
1094	Bachelor's	Male	7
1095	Bachelor's	Female	0
1096	Bachelor's	Female	8
1097	Master's	Female	6
1098	Bachelor's	Male	5
1099	Master's	Male	9
1100	Master's	Male	4
1101	Master's	Male	0
1102	Bachelor's	Female	2
1103	Bachelor's	Female	5
1104	Master's	Female	2
1105	Bachelor's	Male	6
1106	Bachelor's	Female	8
1107	Bachelor's	Male	8
1108	Bachelor's	Male	7
1109	Master's	Male	4
1110	Master's	Male	0
1111	Master's	Male	1
1112	Master's	Male	9
1113	Master's	Male	0
1114	PhD	Female	7
1115	Bachelor's	Male	4
1116	PhD	Female	6
1117	Bachelor's	Female	6
1118	PhD	Male	4
1119	Bachelor's	Male	0
1120	Bachelor's	Female	7
1121	Master's	Female	7
1122	Master's	Male	4
1123	Bachelor's	Male	6
1124	Bachelor's	Male	3
1125	Bachelor's	Male	7
1126	Master's	Male	8
1127	Master's	Male	5
1128	Master's	Male	6
1129	Master's	Female	6
1130	Bachelor's	Male	6
1131	PhD	Female	2
1132	Master's	Male	3
1133	Master's	Female	7