Compatibility =CHIDIST(x,deg_freedom)

Quiz =CHIDIST — 15 Questions

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

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

← CHIDIST ▦ Practice in Playground

Progress — 15 questions 1 of 15

Question 1 of 15 1/15

What is the output type of =CHIDIST?

Question 2 of 15 2/15

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

Question 3 of 15 3/15

Is argument “deg_freedom” required in =CHIDIST?

Question 4 of 15 4/15

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

Question 5 of 15 5/15

Which statement about =CHIDIST is correct?

Question 6 of 15 6/15

In =CHIDIST, which is argument #1?

Question 7 of 15 7/15

How many required arguments does =CHIDIST have?

Question 8 of 15 8/15

In =CHIDIST, which is argument #2?

Question 9 of 15 9/15

Which use case fits =CHIDIST?

Question 10 of 15 10/15

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

Question 11 of 15 11/15

What usually causes #VALUE! in =CHIDIST?

Question 12 of 15 12/15

What is the type of argument “x” in =CHIDIST?

Question 13 of 15 13/15

Which category does =CHIDIST belong to?

Question 14 of 15 14/15

Does =CHIDIST return a dynamic array?

Question 15 of 15 15/15

Is =CHIDIST volatile?

Click a question to see the answer.

1. What is the output type of =CHIDIST?

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

Explanation: Output is “Number”.

2. What is the type of argument “deg_freedom” in =CHIDIST?

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

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

3. Is argument “deg_freedom” required in =CHIDIST?

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

Explanation: “deg_freedom” is required.

4. What is the fix for #VALUE! in =CHIDIST?

A. برای هر دو آرگومان مقدار عددی وارد کنید. ✓
B. Only works in old versions
C. Select entire column for best performance
D. مقدار x منفی است یا درجات آزادی خارج از بازهٔ ‎۱ تا ‎۱۰^۱۰ است.

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

5. Which statement about =CHIDIST 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. For more information about the new functions, see CHISQ.DIST function and CHISQ.DIST.RT function. ✓
B. Select entire column for best performance
C. CHIDIST is calculated as CHIDIST = P(X>x), where X is a χ2 random variable.
D. If deg_freedom is not an integer, it is truncated.

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 functions, see CHISQ.DIST function and CHISQ.DIST.RT function.

6. In =CHIDIST, which is argument #1?

A. lookup_value
B. value
C. x ✓
D. range

Explanation: Argument #1 is “x”.

7. How many required arguments does =CHIDIST have?

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

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

8. In =CHIDIST, which is argument #2?

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

Explanation: Argument #2 is “deg_freedom”.

9. Which use case fits =CHIDIST?

A. Conditional Formatting & Validation
B. Reporting ✓
C. Investment Appraisal
D. Securities & Bonds

Explanation: Use case “Reporting” fits CHIDIST.

10. What is the fix for #NUM! in =CHIDIST?

A. یکی از آرگومان‌ها غیرعددی است.
B. Only works in old versions
C. Allowed values ✓
D. Select entire column for best performance

Explanation: If x is negative, CHIDIST returns the #NUM! error value. If deg_freedom < 1 or deg_freedom > 10^10, CHIDIST returns the #NUM! error value. — Fix: Allowed values

11. What usually causes #VALUE! in =CHIDIST?

A. If either argument is nonnumeric, CHIDIST returns the #VALUE! error value. ✓
B. Only works in old versions
C. Select entire column for best performance
D. Requires add-in

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

12. What is the type of argument “x” in =CHIDIST?

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

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

13. Which category does =CHIDIST belong to?

A. Logical
B. Statistical
C. Text
D. Compatibility ✓

Explanation: Category is “Compatibility”.

14. Does =CHIDIST return a dynamic array?

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

Explanation: CHIDIST does not spill.

15. Is =CHIDIST volatile?

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

Explanation: CHIDIST is not volatile.