I need help asap! 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
I need help asap! 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
Algebra & Trigonometry with Analytic Geometry
13th Edition
ISBN:9781133382119
Author:Swokowski
Publisher:Swokowski
Chapter10: Sequences, Series, And Probability
Section10.8: Probability
Problem 30E
Related questions
Question
100%
I need help asap!
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 |
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 5 steps with 3 images
Recommended textbooks for you
Algebra & Trigonometry with Analytic Geometry
Algebra
ISBN:
9781133382119
Author:
Swokowski
Publisher:
Cengage
Algebra & Trigonometry with Analytic Geometry
Algebra
ISBN:
9781133382119
Author:
Swokowski
Publisher:
Cengage