Compatibility =CHIDIST(x,deg_freedom)

Quiz =CHIDIST — 10 Questions

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

Question 1 of 10 1/10

Which use case fits =CHIDIST?

Question 2 of 10 2/10

What is the output type of =CHIDIST?

Question 3 of 10 3/10

Is argument “x” required in =CHIDIST?

Question 4 of 10 4/10

Does =CHIDIST return a dynamic array?

Question 5 of 10 5/10

Which statement about =CHIDIST is correct?

Question 6 of 10 6/10

Is argument “deg_freedom” required in =CHIDIST?

Question 7 of 10 7/10

Which function is NOT related to =CHIDIST?

Question 8 of 10 8/10

Which function is related to =CHIDIST?

Question 9 of 10 9/10

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

Question 10 of 10 10/10

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

Click a question to see the answer.

1. Which use case fits =CHIDIST?

A. Securities & Bonds
B. Loans & Installments
C. Reporting ✓
D. Descriptive Statistics

Explanation: Use case “Reporting” fits CHIDIST.

2. What is the output type of =CHIDIST?

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

Explanation: Output is “Number”.

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

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

Explanation: “x” is required.

4. Does =CHIDIST return a dynamic array?

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

Explanation: CHIDIST does not spill.

5. Which statement about =CHIDIST is correct?

A. If deg_freedom is not an integer, it is truncated.
B. Select entire column for best performance
C. CHIDIST is calculated as CHIDIST = P(X>x), where X is a χ2 random variable.
D. 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. ✓

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. Is argument “deg_freedom” required in =CHIDIST?

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

Explanation: “deg_freedom” is required.

7. Which function is NOT related to =CHIDIST?

A. FORECAST
B. PERCENTILE
C. MODE
D. BINOM.DIST ✓

Explanation: “BINOM.DIST” is not related to CHIDIST.

8. Which function is related to =CHIDIST?

A. OCT2BIN
B. F.DIST.RT
C. FORECAST ✓
D. GEOMEAN

Explanation: “FORECAST” is related to CHIDIST.

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

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

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

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

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

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