1) Using EXCEL and the Cell Phone Survey data answer the following questions by using COUNTIF and AVERAGEIF: a. How many Males participated in this survey? b. How many AT&T users in this survey? c. What is the mean of Signal Strength for Sprint users?
1) Using EXCEL and the Cell Phone Survey data answer the following questions by using COUNTIF and AVERAGEIF: a. How many Males participated in this survey? b. How many AT&T users in this survey? c. What is the mean of Signal Strength for Sprint users?
Glencoe Algebra 1, Student Edition, 9780079039897, 0079039898, 2018
18th Edition
ISBN:9780079039897
Author:Carter
Publisher:Carter
Chapter4: Equations Of Linear Functions
Section: Chapter Questions
Problem 8SGR
Related questions
Question
1) Using EXCEL and the Cell Phone Survey data answer the following questions by using COUNTIF and AVERAGEIF:
a. How many Males participated in this survey?
b. How many AT&T users in this survey?
c. What is the mean of Signal Strength for Sprint users?
d. What is the mean of Signal Strength for Female users?
| 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 2 steps with 1 images
Recommended textbooks for you
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill