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
Progress — 10 questions
1 of 10
Question 1 of 10
1/10
Does =CHISQ.TEST return a dynamic array?
Explanation: CHISQ.TEST does not spill.
Question 2 of 10
2/10
Which function is related to =CHISQ.TEST?
Explanation: “SUMPRODUCT” is related to CHISQ.TEST.
Question 3 of 10
3/10
Is argument “expected_range” required in =CHISQ.TEST?
Explanation: “expected_range” is required.
Question 4 of 10
4/10
Which function is NOT related to =CHISQ.TEST?
Explanation: “NORMSDIST” is not related to CHISQ.TEST.
Question 5 of 10
5/10
What is the type of argument “actual_range” in =CHISQ.TEST?
Explanation: Type of “actual_range” is “Range”.
Question 6 of 10
6/10
What is the output type of =CHISQ.TEST?
Explanation: Output is “Number”.
Question 7 of 10
7/10
What usually causes #N/A in =CHISQ.TEST?
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
Question 8 of 10
8/10
In =CHISQ.TEST, which is argument #2?
Explanation: Argument #2 is “expected_range”.
Question 9 of 10
9/10
Which use case fits =CHISQ.TEST?
Explanation: Use case “Probability & Hypothesis Testing” fits CHISQ.TEST.
Question 10 of 10
10/10
What is the fix for #N/A in =CHISQ.TEST?
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