Compatibility =CHIINV(probability,deg_freedom)

Quiz =CHIINV — 15 Questions

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

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

← CHIINV ▦ Practice in Playground

Progress — 15 questions 1 of 15

Question 1 of 15 1/15

Which category does =CHIINV belong to?

Question 2 of 15 2/15

What is the type of argument “probability” in =CHIINV?

Question 3 of 15 3/15

What is the fix for #VALUE! in =CHIINV?

Question 4 of 15 4/15

Which is the correct syntax of =CHIINV?

Question 5 of 15 5/15

Is argument “deg_freedom” required in =CHIINV?

Question 6 of 15 6/15

What is the type of argument “deg_freedom” in =CHIINV?

Question 7 of 15 7/15

Which function is related to =CHIINV?

Question 8 of 15 8/15

Is argument “probability” required in =CHIINV?

Question 9 of 15 9/15

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

Question 10 of 15 10/15

Which function is NOT related to =CHIINV?

Question 11 of 15 11/15

In =CHIINV, which is argument #2?

Question 12 of 15 12/15

Does =CHIINV return a dynamic array?

Question 13 of 15 13/15

How many required arguments does =CHIINV have?

Question 14 of 15 14/15

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

Question 15 of 15 15/15

In =CHIINV, which is argument #1?

Click a question to see the answer.

1. Which category does =CHIINV belong to?

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

Explanation: Category is “Compatibility”.

2. What is the type of argument “probability” in =CHIINV?

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

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

3. What is the fix for #VALUE! in =CHIINV?

A. احتمال خارج از ‎۰ تا ۱ است یا درجات آزادی کمتر از ‎۱ است.
B. برای هر دو آرگومان مقدار عددی وارد کنید. ✓
C. Volatile and recalculates every time
D. جستجو پس از ‎۱۰۰ تکرار همگرا نشده است.

Explanation: If either argument is nonnumeric, CHIINV returns the #VALUE! error value. — Fix: برای هر دو آرگومان مقدار عددی وارد کنید.

4. Which is the correct syntax of =CHIINV?

A. =CHIINV(probability,deg_freedom, 0)
B. CHIINV(probability,deg_freedom)
C. =FORECAST(probability,deg_freedom)
D. =CHIINV(probability,deg_freedom) ✓

Explanation: Correct syntax: =CHIINV(probability,deg_freedom)

5. Is argument “deg_freedom” required in =CHIINV?

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

Explanation: “deg_freedom” is required.

6. What is the type of argument “deg_freedom” in =CHIINV?

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

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

7. Which function is related to =CHIINV?

A. VDB
B. TIME
C. FORECAST ✓
D. FACT

Explanation: “FORECAST” is related to CHIINV.

8. Is argument “probability” required in =CHIINV?

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

Explanation: “probability” is required.

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

A. مقادیر ورودی را بررسی کنید یا با احتمال و درجات آزادی دیگری دوباره امتحان کنید. ✓
B. Requires add-in
C. Output is always a dynamic array
D. یکی از آرگومان‌ها غیرعددی است.

Explanation: If the search has not converged after 100 iterations, the function returns the #N/A error value. — Fix: مقادیر ورودی را بررسی کنید یا با احتمال و درجات آزادی دیگری دوباره امتحان کنید.

10. Which function is NOT related to =CHIINV?

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

Explanation: “TRUE” is not related to CHIINV.

11. In =CHIINV, which is argument #2?

A. lookup_value
B. value
C. deg_freedom ✓
D. probability

Explanation: Argument #2 is “deg_freedom”.

12. Does =CHIINV return a dynamic array?

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

Explanation: CHIINV does not spill.

13. How many required arguments does =CHIINV have?

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

Explanation: =CHIINV has 2 required, 0 optional (2 total).

14. What is the fix for #NUM! in =CHIINV?

A. Text is always ignored
B. Only works in old versions
C. Output is always a dynamic array
D. Between 0 and 1 ✓

Explanation: If probability < 0 or probability > 1, CHIINV returns the #NUM! error value. If deg_freedom < 1, CHIINV returns the #NUM! error value. — Fix: Between 0 and 1

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

A. probability ✓
B. value
C. deg_freedom
D. criteria

Explanation: Argument #1 is “probability”.