2) Create Pivot Tables in EXCEL to answer the following questions: a. What is the probability that the respondent is Female?b. What is the probability that the respondent is Female and uses Verizon?c. Given a respondent using AT&T, what is the probability that the respondent is Female?d. Given a respondent is Male, what is the probability that the respondent either uses Other Carrier or uses Smart Type?e. Which carrier will you choose base on the probability of the Signal Strength= 5? Explain the reason Cell Phone Survey Gender Carrier Type Usage Signal strength Value for the Dollar Customer Service M AT&T Smart High 5 4 4 M AT&T Smart High 5 4 2 M AT&T Smart Average 4 4 4 M AT&T Smart Very high 2 3 3 M AT&T Smart Very high 5 5 2 M AT&T Smart Very high 4 3 5 M AT&T Smart Very high 3 4 4 F AT&T Smart Very high 3 2 3 F AT&T Smart Very high 4 3 4 M AT&T Smart Very high 3 3 1 M Other Smart Average 1 2 4 M Sprint Smart Very high 3 5 4 M Sprint Smart Very high 3 5 3 F Sprint Smart Average 2 5 4 F Sprint Smart Average 3 5 4 M Verizon Smart Average 4 3 3 F Verizon Smart Very high 4 3 2 M Verizon Smart Very high 5 5 5 F Verizon Smart Average 3 3 3 M Verizon Smart Very high 4 4 2 F Verizon Smart Very high 4 5 3 M AT&T Camera Average 5 4 5 M AT&T Camera Very high 2 1 3 M AT&T Camera Average 2 4 3 F AT&T Camera Very high 3 3 3 M AT&T Camera Average 5 5 3 F AT&T Camera Average 4 3 3 M AT&T Camera Average 4 2 4 F AT&T Camera Very high 2 4 1 F AT&T Camera Average 2 4 3 M AT&T Camera Average 3 3 4 F AT&T Camera Very high 3 2 3 M AT&T Camera Very high 4 3 3 F AT&T Camera Low 4 2 3 M Other Camera Average 3 3 3 F Other Camera Average 2 3 3 M Other Camera Average 4 3 4 M Sprint Camera Average 3 4 4 F Verizon Camera Very high 3 4 3 F Verizon Camera Very high 4 3 1 M AT&T Basic Average 3 3 3 M AT&T Basic Average 3 3 2 M AT&T Basic Low 3 3 3 M Other Basic Average 3 3 5 M Other Basic Very high 4 3 3 M Other Basic Very high 1 3 4 M Other Basic Low 4 4 2 F Other Basic Average 2 3 3 F T-mobile Basic Low 3 4 4 M T-mobile Basic Average 3 4 3 M Verizon Basic Low 3 3 4 M Verizon Basic Average 4 2 4

2) Create Pivot Tables in EXCEL to answer the following questions: a. What is the probability that the respondent is Female? b. What is the probability that the respondent is Female and uses Verizon?...

2) Create Pivot Tables in EXCEL to answer the following questions:

a. What is the probability that the respondent is Female?
b. What is the probability that the respondent is Female and uses Verizon?
c. Given a respondent using AT&T, what is the probability that the respondent is Female?
d. Given a respondent is Male, what is the probability that the respondent either uses Other Carrier or uses Smart Type?
e. Which carrier will you choose base on the probability of the Signal Strength= 5? Explain the reason

Cell Phone Survey

Gender	Carrier	Type	Usage	Signal strength	Value for the Dollar	Customer Service
M	AT&T	Smart	High	5	4	4
M	AT&T	Smart	High	5	4	2
M	AT&T	Smart	Average	4	4	4
M	AT&T	Smart	Very high	2	3	3
M	AT&T	Smart	Very high	5	5	2
M	AT&T	Smart	Very high	4	3	5
M	AT&T	Smart	Very high	3	4	4
F	AT&T	Smart	Very high	3	2	3
F	AT&T	Smart	Very high	4	3	4
M	AT&T	Smart	Very high	3	3	1
M	Other	Smart	Average	1	2	4
M	Sprint	Smart	Very high	3	5	4
M	Sprint	Smart	Very high	3	5	3
F	Sprint	Smart	Average	2	5	4
F	Sprint	Smart	Average	3	5	4
M	Verizon	Smart	Average	4	3	3
F	Verizon	Smart	Very high	4	3	2
M	Verizon	Smart	Very high	5	5	5
F	Verizon	Smart	Average	3	3	3
M	Verizon	Smart	Very high	4	4	2
F	Verizon	Smart	Very high	4	5	3
M	AT&T	Camera	Average	5	4	5
M	AT&T	Camera	Very high	2	1	3
M	AT&T	Camera	Average	2	4	3
F	AT&T	Camera	Very high	3	3	3
M	AT&T	Camera	Average	5	5	3
F	AT&T	Camera	Average	4	3	3
M	AT&T	Camera	Average	4	2	4
F	AT&T	Camera	Very high	2	4	1
F	AT&T	Camera	Average	2	4	3
M	AT&T	Camera	Average	3	3	4
F	AT&T	Camera	Very high	3	2	3
M	AT&T	Camera	Very high	4	3	3
F	AT&T	Camera	Low	4	2	3
M	Other	Camera	Average	3	3	3
F	Other	Camera	Average	2	3	3
M	Other	Camera	Average	4	3	4
M	Sprint	Camera	Average	3	4	4
F	Verizon	Camera	Very high	3	4	3
F	Verizon	Camera	Very high	4	3	1
M	AT&T	Basic	Average	3	3	3
M	AT&T	Basic	Average	3	3	2
M	AT&T	Basic	Low	3	3	3
M	Other	Basic	Average	3	3	5
M	Other	Basic	Very high	4	3	3
M	Other	Basic	Very high	1	3	4
M	Other	Basic	Low	4	4	2
F	Other	Basic	Average	2	3	3
F	T-mobile	Basic	Low	3	4	4
M	T-mobile	Basic	Average	3	4	3
M	Verizon	Basic	Low	3	3	4
M	Verizon	Basic	Average	4	2	4

Answered 63 days AfterJun 02, 2022

Answer To: 2) Create Pivot Tables in EXCEL to answer the following questions: a. What is the probability that...

Bikash answered on Aug 05 2022

86 Votes

Pivot 1
                                    a. What is the probability that the respondent is Female?     34.62%
    Count of Gender    Column Labels                            b. What is the probability that the respondent is Female and uses Verizon?     9.62%
    Row Labels    AT&T    Other    Sprint    T-mobile    Verizon    Grand Total        c. Given a respondent using AT&T, what is the probability that the respondent is Female?     30.8%
    F    8    2    2    1    5    18        d. Given a respondent is Male, what is the probability that the respondent either uses Other Carrier or uses Smart Type?     61.76%
    M    18    7    3    1    5    34
    Grand Total    26    9    5    2    10    52
    Count of Gender    Column Labels
    Row Labels    Basic    Camera    Smart    Grand Total
    F    2    9    7    18
    M    10    10    14    34
    Grand Total    12    19    21    52
Pivot 2
    Row Labels    Sum of Signal strength    Count of Gender        Average...

SOLUTION.PDF

2) Create Pivot Tables in EXCEL to answer the following questions: a. What is the probability that the respondent is Female? b. What is the probability that the respondent is Female and uses Verizon?...

Answer To: 2) Create Pivot Tables in EXCEL to answer the following questions: a. What is the probability that...

Answer To This Question Is Available To Download

Related Questions & Answers

Submit New Assignment