1) Answer the following questions by using COUNTIF and AVERAGEIF:

a. How many Males participated in this survey? (2 points)

b. How many AT&T users in this survey? (2 points)

c. What is the mean of Signal Strength for Sprint users? (2 points)

d. What is the mean of Signal Strength for Female users? (2 points)

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)

- 4 2 4 Gender M M M M M M M 3 2 5 4 3 F F 4 M 1 4 M M M 4 3 4 F 4 F M F 3 2 5 3 M F M F M M M F M Carrie Type Usage Signal streng Value for the Doll Customer Servi AT&T Smart High 5 4 AT&T Smart High 5 4 AT&T Smart Average 4 4 AT&T Smart Very high 2 3 AT&T Smart Very high 5 5 AT&T Smart Very high 4 3 AT&T Smart Very high 3 4 AT&T Smart Very high 3 2 AT&T Smart Very high 4 3 AT&T Smart Very high 3 3 Other Smart Average 1 2 Sprint Smart Very high 3 5 Sprint Smart Very high 3 5 Sprint Smart Average 2 5 Sprint Smart Average 3 5 Verizon Smart Average 4 3 Verizon Smart Very high 4 3 Verizon Smart Very high 5 5 Verizon Smart Average 3 3 Verizon Smart Very high 4 4 Verizon Smart Very high 4 5 AT&T Camera Average 5 4 AT&T Camera Very high 2 1 AT&T Camera Average 2 4 AT&T Camera Very high 3 3 AT&T Camera Average 5 5 AT&T Camera Average 4 3 AT&T Camera Average 4 2 AT&T Camera Very high 2 4 AT&T Camera Average 2 4 AT&T Camera Averago 3 3 AT&T Camera Very high 3 2 AT&T Camera Very high 4 3 AT&T Camera Low 4 2 Other Camera Average 3 3 Other Camera Averago 2 3 Other Camera Average 4 3 Sprint Camera Average 3 4 Verizon Camera Very high 3 4 Verizon Camera Very high 4 3 AT&T Basic Average 3 3 AT&T Basic Average 3 3 AT&T Basic Low 3 3 Other Basic Average 3 3 Other Basic Very high 4 3 Other Basic Very high 1 3 Other Basic Low 4 4 Other Basic Average 2 3 T-mobile Basic Low 3 4 T-mobile Basic Average 3 4 Verizon Basic Low 3 3 Verizon Basic Average 4 2 2 3 5 3 3 3 3 3 F M 4 : : : > > > : : : 4 5 5 : " " 5 5 5 5 5 5 5 " " 5 5 5 F M F M F M 1 3 4 3 3 3 3 3 4 F M M F 4 F M M M M M M M 3 1 3 2 3 5 3 4 F M M M 2 3 4 3 4 4