Statistical =NORMINV(probability,mean,standard_dev)

Quiz =NORMINV — 10 Questions

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

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

← NORMINV ▦ Practice in Playground

Progress — 10 questions 1 of 10

Question 1 of 10 1/10

Is =NORMINV volatile?

Question 2 of 10 2/10

How many arguments does =NORMINV have in total?

Question 3 of 10 3/10

Which is the correct syntax of =NORMINV?

Question 4 of 10 4/10

What usually causes #NUM! in =NORMINV?

Question 5 of 10 5/10

What is the output type of =NORMINV?

Question 6 of 10 6/10

Is argument “standard_dev” required in =NORMINV?

Question 7 of 10 7/10

Which statement about =NORMINV is correct?

Question 8 of 10 8/10

Which function is NOT related to =NORMINV?

Question 9 of 10 9/10

What is the fix for #N/A in =NORMINV?

Question 10 of 10 10/10

What usually causes #N/A in =NORMINV?

Click a question to see the answer.

1. Is =NORMINV volatile?

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

Explanation: NORMINV is not volatile.

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

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

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

3. Which is the correct syntax of =NORMINV?

A. =AVEDEV(probability,mean,standard_dev)
B. =NORMINV(probability,mean,standard_dev, 0)
C. NORMINV(probability,mean,standard_dev)
D. =NORMINV(probability,mean,standard_dev) ✓

Explanation: Correct syntax: =NORMINV(probability,mean,standard_dev)

4. What usually causes #NUM! in =NORMINV?

A. Only works in old versions
B. Requires add-in
C. Select entire column for best performance
D. If probability <= 0 or if probability >= 1, NORMINV returns the #NUM! error value. If standard_dev ≤ 0, NORMINV returns the #NUM! error value. ✓

Explanation: If probability <= 0 or if probability >= 1, NORMINV returns the #NUM! error value. If standard_dev ≤ 0, NORMINV returns the #NUM! error value. — Fix: Enter a value between 0 and 1

5. What is the output type of =NORMINV?

A. Value ✓
B. Reference
C. Array
D. Date

Explanation: Output is “Value”.

6. Is argument “standard_dev” required in =NORMINV?

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

Explanation: “standard_dev” is required.

7. Which statement about =NORMINV is correct?

A. Only works in old versions
B. Text is always ignored
C. 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. For more information about the new function, see NORM.INV function. ✓
D. If mean = 0 and standard_dev = 1, NORMINV uses the standard normal distribution (see NORMSINV).

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. For more information about the new function, see NORM.INV function.

8. Which function is NOT related to =NORMINV?

A. AVERAGE
B. AVEDEV
C. AVERAGEA
D. AMORDEGRC ✓

Explanation: “AMORDEGRC” is not related to NORMINV.

9. What is the fix for #N/A in =NORMINV?

A. Only works in old versions
B. Volatile and recalculates every time
C. مقادیر ورودی به‌ویژه probability را بررسی کنید و دوباره تلاش کنید؛ در صورت تکرار، ورودی‌ها را ساده‌تر کنید. ✓
D. Output is always a dynamic array

Explanation: If the search has not converged after 100 iterations, the function returns the #N/A error value. — Fix: مقادیر ورودی به‌ویژه probability را بررسی کنید و دوباره تلاش کنید؛ در صورت تکرار، ورودی‌ها را ساده‌تر کنید.

10. What usually causes #N/A in =NORMINV?

A. If the search has not converged after 100 iterations, the function returns the #N/A error value. ✓
B. یک یا چند آرگومان غیرعددی است.
C. Volatile and recalculates every time
D. Only works in old versions