Compatibility =NEGBINOMDIST(number_f,number_s,probability_s)

Quiz =NEGBINOMDIST — 10 Questions

10 quiz questions about =NEGBINOMDIST — test syntax, arguments, examples & errors!

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

← NEGBINOMDIST ▦ Practice in Playground

Progress — 10 questions 1 of 10

Question 1 of 10 1/10

What is the type of argument “probability_s” in =NEGBINOMDIST?

Question 2 of 10 2/10

What is the type of argument “number_s” in =NEGBINOMDIST?

Question 3 of 10 3/10

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

Question 4 of 10 4/10

Is argument “probability_s” required in =NEGBINOMDIST?

Question 5 of 10 5/10

Which category does =NEGBINOMDIST belong to?

Question 6 of 10 6/10

In =NEGBINOMDIST, which is argument #2?

Question 7 of 10 7/10

Which statement about =NEGBINOMDIST is correct?

Question 8 of 10 8/10

Which function is NOT related to =NEGBINOMDIST?

Question 9 of 10 9/10

How many required arguments does =NEGBINOMDIST have?

Question 10 of 10 10/10

What usually causes #NUM! in =NEGBINOMDIST?

Click a question to see the answer.

1. What is the type of argument “probability_s” in =NEGBINOMDIST?

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

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

2. What is the type of argument “number_s” in =NEGBINOMDIST?

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

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

3. What is the fix for #NUM! in =NEGBINOMDIST?

A. Select entire column for best performance
B. یک یا چند آرگومان غیرعددی است.
C. Output is always a dynamic array
D. Enter a value between 0 and 1 ✓

Explanation: If probability_s < 0 or if probability > 1, NEGBINOMDIST returns the #NUM! error value. If number_f < 0 or number_s < 1, NEGBINOMDIST returns the #NUM! error value. — Fix: Enter a value between 0 and 1

4. Is argument “probability_s” required in =NEGBINOMDIST?

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

Explanation: “probability_s” is required.

5. Which category does =NEGBINOMDIST belong to?

A. Database
B. Compatibility ✓
C. Date & Time
D. Web

Explanation: Category is “Compatibility”.

6. In =NEGBINOMDIST, which is argument #2?

A. value
B. number_s ✓
C. number_f
D. criteria

Explanation: Argument #2 is “number_s”.

7. Which statement about =NEGBINOMDIST is correct?

A. 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. ✓
B. Text is always ignored
C. The equation for the negative binomial distribution is: where: x is number_f, r is number_s, and p is probability_s.
D. Only works in old versions

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.

8. Which function is NOT related to =NEGBINOMDIST?

A. PERCENTILE
B. COUPDAYBS ✓
C. FORECAST
D. MODE

Explanation: “COUPDAYBS” is not related to NEGBINOMDIST.

9. How many required arguments does =NEGBINOMDIST have?

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

Explanation: =NEGBINOMDIST has 3 required, 0 optional (3 total).

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

A. Text is always ignored
B. Only works in old versions
C. Output is always a dynamic array
D. If probability_s < 0 or if probability > 1, NEGBINOMDIST returns the #NUM! error value. If number_f < 0 or number_s < 1, NEGBINOMDIST returns the #NUM! error value. ✓