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
Chapter10: Statistics
Section: Chapter Questions
Problem 1MCQ
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
Big Ideas Math A Bridge To Success Algebra 1: Stu…
Algebra
ISBN:
9781680331141
Author:
HOUGHTON MIFFLIN HARCOURT
Publisher:
Houghton Mifflin Harcourt
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill
Big Ideas Math A Bridge To Success Algebra 1: Stu…
Algebra
ISBN:
9781680331141
Author:
HOUGHTON MIFFLIN HARCOURT
Publisher:
Houghton Mifflin Harcourt