Statistical
=HYPGEOM.DIST(sample_s,number_sample,population_s,number_pop,cumulative)
Quiz =HYPGEOM.DIST — 10 Questions
10 quiz questions about =HYPGEOM.DIST — test syntax, arguments, examples & errors!
Questions:
10 questions
15 questions
Random 10 or 15 questions from the pool + shuffled options each time
Progress — 10 questions
1 of 10
Question 1 of 10
1/10
Which is the correct syntax of =HYPGEOM.DIST?
Explanation: Correct syntax: =HYPGEOM.DIST(sample_s,number_sample,population_s,number_pop,cumulative)
Question 2 of 10
2/10
In =HYPGEOM.DIST, which is argument #3?
Explanation: Argument #3 is “population_s”.
Question 3 of 10
3/10
Is argument “cumulative” required in =HYPGEOM.DIST?
Explanation: “cumulative” is required.
Question 4 of 10
4/10
Does =HYPGEOM.DIST return a dynamic array?
Explanation: HYPGEOM.DIST does not spill.
Question 5 of 10
5/10
Is argument “population_s” required in =HYPGEOM.DIST?
Explanation: “population_s” is required.
Question 6 of 10
6/10
Is argument “number_sample” required in =HYPGEOM.DIST?
Explanation: “number_sample” is required.
Question 7 of 10
7/10
Which formula is a valid example of =HYPGEOM.DIST?
Explanation: Correct example: =HYPGEOM.DIST(A2,A3,A4,A5,TRUE)
Question 8 of 10
8/10
Is argument “sample_s” required in =HYPGEOM.DIST?
Explanation: “sample_s” is required.
Question 9 of 10
9/10
What is the type of argument “cumulative” in =HYPGEOM.DIST?
Explanation: Type of “cumulative” is “Logical”.
Question 10 of 10
10/10
Which function is NOT related to =HYPGEOM.DIST?
Explanation: “VARP” is not related to HYPGEOM.DIST.