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

Quiz =HYPGEOMDIST — 10 Questions

10 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 — 10 questions 1 of 10

Question 1 of 10 1/10

Which category does =HYPGEOMDIST belong to?

Question 2 of 10 2/10

How many optional arguments does =HYPGEOMDIST have?

Question 3 of 10 3/10

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

Question 4 of 10 4/10

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

Question 5 of 10 5/10

Is =HYPGEOMDIST volatile?

Question 6 of 10 6/10

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

Question 7 of 10 7/10

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

Question 8 of 10 8/10

Since which Excel version is =HYPGEOMDIST available?

Question 9 of 10 9/10

Which statement about =HYPGEOMDIST is correct?

Question 10 of 10 10/10

Which is the correct syntax of =HYPGEOMDIST?

Click a question to see the answer.

1. Which category does =HYPGEOMDIST belong to?

A. Logical
B. Web
C. Engineering
D. Compatibility ✓

Explanation: Category is “Compatibility”.

2. How many optional arguments does =HYPGEOMDIST have?

A. 1
B. 4
C. 2
D. 0 ✓

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

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

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

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

4. What is the type of argument “sample_s” in =HYPGEOMDIST?

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

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

5. Is =HYPGEOMDIST volatile?

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

Explanation: HYPGEOMDIST is not volatile.

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

A. Select entire column for best performance
B. Volatile and recalculates every time
C. Text is always ignored
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

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

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

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

8. Since which Excel version is =HYPGEOMDIST available?

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

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

9. Which statement about =HYPGEOMDIST is correct?

A. Requires add-in
B. 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. ✓
C. 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.
D. All arguments are truncated to integers.

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.

10. 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, 0)
C. =FORECAST(sample_s,number_sample,population_s,number_pop)
D. HYPGEOMDIST(sample_s,number_sample,population_s,number_pop)

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