Utilize this spreadsheet ✓. a) Use the COUNTIFS function to get the percentage of values in "Category" (column C) that say "Rush". Give answer to 4 decimal points. The answer is b) Use the percentage from part a to get the probability that from a random sample of 100 Category values, that between 30 and 35 would be Rush. Give answer to 4 decimal points.
Utilize this spreadsheet ✓. a) Use the COUNTIFS function to get the percentage of values in "Category" (column C) that say "Rush". Give answer to 4 decimal points. The answer is b) Use the percentage from part a to get the probability that from a random sample of 100 Category values, that between 30 and 35 would be Rush. Give answer to 4 decimal points.
Glencoe Algebra 1, Student Edition, 9780079039897, 0079039898, 2018
18th Edition
ISBN:9780079039897
Author:Carter
Publisher:Carter
Chapter10: Statistics
Section10.5: Comparing Sets Of Data
Problem 26PFA
Related questions
Question
![Utilize this spreadsheet ✓.
a) Use the COUNTIFS function to get
the percentage of values in
"Category" (column C) that say
"Rush". Give answer to 4 decimal
points.
The answer is
b) Use the percentage from part a to
get the probability that from a
random sample of 100 Category
values, that between 30 and
35 would be Rush. Give answer to 4
decimal points.](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2Fc7c0815d-317d-4ca7-8f31-69a5c803f3b1%2Ff053ac96-2964-4747-ac70-3a4d0d747151%2F4d3cnpe_processed.png&w=3840&q=75)
Transcribed Image Text:Utilize this spreadsheet ✓.
a) Use the COUNTIFS function to get
the percentage of values in
"Category" (column C) that say
"Rush". Give answer to 4 decimal
points.
The answer is
b) Use the percentage from part a to
get the probability that from a
random sample of 100 Category
values, that between 30 and
35 would be Rush. Give answer to 4
decimal points.
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
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
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Recommended textbooks for you
![Glencoe Algebra 1, Student Edition, 9780079039897…](https://www.bartleby.com/isbn_cover_images/9780079039897/9780079039897_smallCoverImage.jpg)
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill
![PREALGEBRA](https://www.bartleby.com/isbn_cover_images/9781938168994/9781938168994_smallCoverImage.gif)
![Big Ideas Math A Bridge To Success Algebra 1: Stu…](https://www.bartleby.com/isbn_cover_images/9781680331141/9781680331141_smallCoverImage.jpg)
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…](https://www.bartleby.com/isbn_cover_images/9780079039897/9780079039897_smallCoverImage.jpg)
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill
![PREALGEBRA](https://www.bartleby.com/isbn_cover_images/9781938168994/9781938168994_smallCoverImage.gif)
![Big Ideas Math A Bridge To Success Algebra 1: Stu…](https://www.bartleby.com/isbn_cover_images/9781680331141/9781680331141_smallCoverImage.jpg)
Big Ideas Math A Bridge To Success Algebra 1: Stu…
Algebra
ISBN:
9781680331141
Author:
HOUGHTON MIFFLIN HARCOURT
Publisher:
Houghton Mifflin Harcourt
![Holt Mcdougal Larson Pre-algebra: Student Edition…](https://www.bartleby.com/isbn_cover_images/9780547587776/9780547587776_smallCoverImage.jpg)
Holt Mcdougal Larson Pre-algebra: Student Edition…
Algebra
ISBN:
9780547587776
Author:
HOLT MCDOUGAL
Publisher:
HOLT MCDOUGAL