Answered step by step
Verified Expert Solution
Question
1 Approved Answer
1) The table below shows survey responses; the respondents could use any value for their answers. How many times do you eat breakfast in a
1) The table below shows survey responses; the respondents could use any value for their answers. | ||||||||
How many times do you eat breakfast in a week? | ||||||||
Name: | Answer | |||||||
Avery | 7 | |||||||
Ron | 5 | |||||||
Avi | 6 | |||||||
Ravi | 4 | |||||||
Ricky | Three | |||||||
Nate | I don't know | |||||||
David | David | |||||||
Solve by using COUNT and COUNTA formulas, and use only column B (Grey) to answer the questions: | ||||||||
Question | How many numerical (with numbers only) responses are in the range? | 1 M | ||||||
Answer | ||||||||
Question | How many responses in total are in the range? | 1 M | ||||||
Answer | ||||||||
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started