Please answer all following questions

2) Create Pivot Tables to answer the following questions: a. What is the probability that the respondent is Female? (2 points) b. What is the probability that the respondent is Female and uses Verizon? (2 points) c. Given a respondent using AT&T, what is the probability that the respondent is Female? (2 points) d. Given a respondent is Male, what is the probability that the respondent either uses Other Carrier or uses Smart Type? (3 points) e. Which carrier will you choose base on the probability of the Signal Strength= 5? Explain the reason. (3 points)

+