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
How many required arguments does =Z.TEST have?
Explanation: =Z.TEST has 2 required, 1 optional (3 total).
Question 3 of 10
3/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 4 of 10
4/10
In =Z.TEST, which is argument #1?
Explanation: Argument #1 is “array”.
Question 5 of 10
5/10
What is the output type of =Z.TEST?
Explanation: Output is “Number”.
Question 6 of 10
6/10
What is the type of argument “array” in =Z.TEST?
Explanation: Type of “array” is “Array”.
Question 7 of 10
7/10
Since which Excel version is =Z.TEST available?
Explanation: Version: “Excel 2010”.
Question 8 of 10
8/10
What is the type of argument “x” in =Z.TEST?
Explanation: Type of “x” is “Number”.
Question 9 of 10
9/10
Which function is related to =Z.TEST?
Explanation: “CONFIDENCE-NORM” is related to Z.TEST.
Question 10 of 10
10/10
Is argument “array” required in =Z.TEST?
Explanation: “array” is required.