Statistical =CHISQ.TEST(actual_range,expected_range)

Quiz =CHISQ.TEST — 10 Questions

10 quiz questions about =CHISQ.TEST — test syntax, arguments, examples & errors!

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

← CHISQ.TEST ▦ Practice in Playground

Progress — 10 questions 1 of 10

Question 1 of 10 1/10

Is argument “expected_range” required in =CHISQ.TEST?

Question 2 of 10 2/10

How many arguments does =CHISQ.TEST have in total?

Question 3 of 10 3/10

Which category does =CHISQ.TEST belong to?

Question 4 of 10 4/10

Which statement about =CHISQ.TEST is correct?

Question 5 of 10 5/10

Which is the correct syntax of =CHISQ.TEST?

Question 6 of 10 6/10

What is the type of argument “expected_range” in =CHISQ.TEST?

Question 7 of 10 7/10

What is the fix for #N/A in =CHISQ.TEST?

Question 8 of 10 8/10

Does =CHISQ.TEST return a dynamic array?

Question 9 of 10 9/10

Which formula is a valid example of =CHISQ.TEST?

Question 10 of 10 10/10

What is the type of argument “actual_range” in =CHISQ.TEST?

Click a question to see the answer.

1. Is argument “expected_range” required in =CHISQ.TEST?

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

Explanation: “expected_range” is required.

2. How many arguments does =CHISQ.TEST have in total?

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

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

3. Which category does =CHISQ.TEST belong to?

A. Statistical ✓
B. Math & Trig
C. Logical
D. Compatibility

Explanation: Category is “Statistical”.

4. Which statement about =CHISQ.TEST is correct?

A. Text is always ignored
B. Requires add-in
C. The χ2 test first calculates a χ2 statistic using the formula: where: Aij = actual frequency in the i-th row, j-th column Eij = expected frequency in the i-th row, j-th column r = number or rows c = number of columns ✓
D. Select entire column for best performance

Explanation: Correct: The χ2 test first calculates a χ2 statistic using the formula: where: Aij = actual frequency in the i-th row, j-th column Eij = expected frequency in the i-th row, j-th column r = number or rows c = number of columns

5. Which is the correct syntax of =CHISQ.TEST?

A. =CHISQ.TEST(actual_range,expected_range, 0)
B. CHISQ.TEST(actual_range,expected_range)
C. =SUMPRODUCT(actual_range,expected_range)
D. =CHISQ.TEST(actual_range,expected_range) ✓

Explanation: Correct syntax: =CHISQ.TEST(actual_range,expected_range)

6. What is the type of argument “expected_range” in =CHISQ.TEST?

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

Explanation: Type of “expected_range” is “Range”.

7. What is the fix for #N/A in =CHISQ.TEST?

A. Make the two ranges the same size ✓
B. Requires add-in
C. Output is always a dynamic array
D. Select entire column for best performance

Explanation: If actual_range and expected_range have a different number of data points, CHISQ.TEST returns the #N/A error value. If r = 1 and c > 1, then df = c - 1 or if r > 1 and c = 1, then df = r - 1. r = c= 1 is not allowed and #N/A is returned. — Fix: Make the two ranges the same size

8. Does =CHISQ.TEST return a dynamic array?

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

Explanation: CHISQ.TEST does not spill.

9. Which formula is a valid example of =CHISQ.TEST?

A. =SUMPRODUCT(A2:B4,A6:B8)
B. CHISQ.TEST(A2:B4,A6:B8)
C. =CHISQ.TEST(A2:B4,A6:B8, 0)
D. =CHISQ.TEST(A2:B4,A6:B8) ✓

Explanation: Correct example: =CHISQ.TEST(A2:B4,A6:B8)

10. What is the type of argument “actual_range” in =CHISQ.TEST?

A. Reference
B. Range ✓
C. Mixed
D. Array

Explanation: Type of “actual_range” is “Range”.