Compatibility =HYPGEOMDIST(sample_s,number_sample,population_s,number_pop)

Quiz =HYPGEOMDIST — 15 Questions

15 quiz questions about =HYPGEOMDIST — test syntax, arguments, examples & errors!

Questions: 10 questions 15 questions Random 10 or 15 questions from the pool + shuffled options each time

← HYPGEOMDIST ▦ Practice in Playground

Progress — 15 questions 1 of 15

Question 1 of 15 1/15

What is the fix for #NUM! in =HYPGEOMDIST?

Question 2 of 15 2/15

How many arguments does =HYPGEOMDIST have in total?

Question 3 of 15 3/15

What is the type of argument “population_s” in =HYPGEOMDIST?

Question 4 of 15 4/15

Which is the correct syntax of =HYPGEOMDIST?

Question 5 of 15 5/15

In =HYPGEOMDIST, which is argument #2?

Question 6 of 15 6/15

Which statement about =HYPGEOMDIST is correct?

Question 7 of 15 7/15

Is =HYPGEOMDIST volatile?

Question 8 of 15 8/15

Which formula is a valid example of =HYPGEOMDIST?

Question 9 of 15 9/15

In =HYPGEOMDIST, which is argument #3?

Question 10 of 15 10/15

What usually causes #NUM! in =HYPGEOMDIST?

Question 11 of 15 11/15

Does =HYPGEOMDIST return a dynamic array?

Question 12 of 15 12/15

What is the type of argument “number_sample” in =HYPGEOMDIST?

Question 13 of 15 13/15

What is the output type of =HYPGEOMDIST?

Question 14 of 15 14/15

Since which Excel version is =HYPGEOMDIST available?

Question 15 of 15 15/15

In =HYPGEOMDIST, which is argument #1?

Click a question to see the answer.

1. What is the fix for #NUM! in =HYPGEOMDIST?

A. Only works in old versions
B. Select entire column for best performance
C. Output is always a dynamic array
D. Valid values ✓

Explanation: If sample_s < 0 or sample_s is greater than the lesser of number_sample or population_s, HYPGEOMDIST returns the #NUM! error value. If sample_s is less than the larger of 0 or (number_sample - number_population + population_s), HYPGEOMDIST returns the #NUM! error value. If number_sample ≤ 0 or number_sample > number_population, HYPGEOMDIST returns the #NUM! error value. If population_s ≤ 0 or population_s > number_population, HYPGEOMDIST returns the #NUM! error value. If number_population ≤ 0, HYPGEOMDIST returns the #NUM! error value. — Fix: Valid values

2. How many arguments does =HYPGEOMDIST have in total?

A. 3
B. 5
C. 6
D. 4 ✓

Explanation: =HYPGEOMDIST has 4 required, 0 optional (4 total).

3. What is the type of argument “population_s” in =HYPGEOMDIST?

A. Date
B. Logical
C. Reference
D. Number ✓

Explanation: Type of “population_s” is “Number”.

4. Which is the correct syntax of =HYPGEOMDIST?

A. =HYPGEOMDIST(sample_s,number_sample,population_s,number_pop) ✓
B. HYPGEOMDIST(sample_s,number_sample,population_s,number_pop)
C. =FORECAST(sample_s,number_sample,population_s,number_pop)
D. =HYPGEOMDIST(sample_s,number_sample,population_s,number_pop, 0)

Explanation: Correct syntax: =HYPGEOMDIST(sample_s,number_sample,population_s,number_pop)

5. In =HYPGEOMDIST, which is argument #2?

A. population_s
B. number_sample ✓
C. criteria
D. number_pop

Explanation: Argument #2 is “number_sample”.

6. Which statement about =HYPGEOMDIST is correct?

A. The equation for the hypergeometric distribution is: where: x = sample_s n = number_sample M = population_s N = number_population HYPGEOMDIST is used in sampling without replacement from a finite population.
B. Select entire column for best performance
C. Output is always a dynamic array
D. This function has been replaced with one or more new functions that may provide improved accuracy and whose names better reflect their usage. Although this function is still available for backward compatibility, you should consider using the new functions from now on, because this function may not be available in future versions of Excel. ✓

Explanation: Correct: This function has been replaced with one or more new functions that may provide improved accuracy and whose names better reflect their usage. Although this function is still available for backward compatibility, you should consider using the new functions from now on, because this function may not be available in future versions of Excel.

7. Is =HYPGEOMDIST volatile?

A. No
B. —
C. No ✓
D. Yes

Explanation: HYPGEOMDIST is not volatile.

8. Which formula is a valid example of =HYPGEOMDIST?

A. =HYPGEOMDIST(A2,A3,A4,A5, 0)
B. =FORECAST(A2,A3,A4,A5)
C. =HYPGEOMDIST(A2,A3,A4,A5) ✓
D. HYPGEOMDIST(A2,A3,A4,A5)

Explanation: Correct example: =HYPGEOMDIST(A2,A3,A4,A5)

9. In =HYPGEOMDIST, which is argument #3?

A. population_s ✓
B. range
C. criteria
D. lookup_value

Explanation: Argument #3 is “population_s”.

10. What usually causes #NUM! in =HYPGEOMDIST?

A. Text is always ignored
B. یکی از آرگومان‌ها غیرعددی است.
C. Select entire column for best performance
D. If sample_s < 0 or sample_s is greater than the lesser of number_sample or population_s, HYPGEOMDIST returns the #NUM! error value. If sample_s is less than the larger of 0 or (number_sample - number_population + population_s), HYPGEOMDIST returns the #NUM! error value. If number_sample ≤ 0 or number_sample > number_population, HYPGEOMDIST returns the #NUM! error value. If population_s ≤ 0 or population_s > number_population, HYPGEOMDIST returns the #NUM! error value. If number_population ≤ 0, HYPGEOMDIST returns the #NUM! error value. ✓

11. Does =HYPGEOMDIST return a dynamic array?

A. No
B. —
C. Yes
D. No ✓

Explanation: HYPGEOMDIST does not spill.

12. What is the type of argument “number_sample” in =HYPGEOMDIST?

A. Array
B. Text
C. Logical
D. Number ✓

Explanation: Type of “number_sample” is “Number”.

13. What is the output type of =HYPGEOMDIST?

A. Reference
B. Value
C. Logical
D. Number ✓

Explanation: Output is “Number”.

14. Since which Excel version is =HYPGEOMDIST available?

A. Excel 2007 (Compatibility) ✓
B. Excel 365
C. All versions
D. Excel 2019

Explanation: Version: “Excel 2007 (Compatibility)”.

15. In =HYPGEOMDIST, which is argument #1?

A. sample_s ✓
B. lookup_value
C. number_sample
D. population_s

Explanation: Argument #1 is “sample_s”.