Statistical
=Z.TEST(array,x,[sigma])
Quiz =Z.TEST — 10 Questions
10 quiz questions about =Z.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
How many optional arguments does =Z.TEST have?
Explanation: =Z.TEST has 2 required, 1 optional (3 total).
Question 2 of 10
2/10
Which formula is a valid example of =Z.TEST?
Explanation: Correct example: =Z.TEST(A2:A11,4)
Question 3 of 10
3/10
Since which Excel version is =Z.TEST available?
Explanation: Version: “Excel 2010”.
Question 4 of 10
4/10
Which statement about =Z.TEST is correct?
Explanation: Correct: Z.TEST represents the probability that the sample mean would be greater than the observed value AVERAGE(array), when the underlying population mean is μ0. From the symmetry of the Normal distribution, if AVERAGE(array) < x, Z.TEST will return a value greater than 0.5.
Question 5 of 10
5/10
Is argument “array” required in =Z.TEST?
Explanation: “array” is required.
Question 6 of 10
6/10
Which use case fits =Z.TEST?
Explanation: Use case “Probability & Hypothesis Testing” fits Z.TEST.
Question 7 of 10
7/10
Which category does =Z.TEST belong to?
Explanation: Category is “Statistical”.
Question 8 of 10
8/10
Which function is related to =Z.TEST?
Explanation: “CONFIDENCE-NORM” is related to Z.TEST.
Question 9 of 10
9/10
How many arguments does =Z.TEST have in total?
Explanation: =Z.TEST has 2 required, 1 optional (3 total).
Question 10 of 10
10/10
What usually causes #N/A in =Z.TEST?
Explanation: If array is empty, Z.TEST returns the #N/A error value. — Fix: Check the data range