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

← Z.TEST ▦ Practice in Playground

Progress — 10 questions 1 of 10

Question 1 of 10 1/10

In =Z.TEST, which is argument #3?

Question 2 of 10 2/10

Is =Z.TEST volatile?

Question 3 of 10 3/10

What is the type of argument “array” in =Z.TEST?

Question 4 of 10 4/10

Which function is related to =Z.TEST?

Question 5 of 10 5/10

Does =Z.TEST return a dynamic array?

Question 6 of 10 6/10

Which function is NOT related to =Z.TEST?

Question 7 of 10 7/10

Which category does =Z.TEST belong to?

Question 8 of 10 8/10

Which use case fits =Z.TEST?

Question 9 of 10 9/10

Which statement about =Z.TEST is correct?

Question 10 of 10 10/10

What is the output type of =Z.TEST?

Click a question to see the answer.

1. In =Z.TEST, which is argument #3?

A. criteria
B. sigma ✓
C. lookup_value
D. range

Explanation: Argument #3 is “sigma”.

2. Is =Z.TEST volatile?

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

Explanation: Z.TEST is not volatile.

3. What is the type of argument “array” in =Z.TEST?

A. Date
B. Text
C. Array ✓
D. Value

Explanation: Type of “array” is “Array”.

4. Which function is related to =Z.TEST?

A. UNICHAR
B. TEXT
C. NORMSINV
D. CONFIDENCE-NORM ✓

Explanation: “CONFIDENCE-NORM” is related to Z.TEST.

5. Does =Z.TEST return a dynamic array?

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

Explanation: Z.TEST does not spill.

6. Which function is NOT related to =Z.TEST?

A. NORM-S-DIST
B. T-TEST
C. BITRSHIFT ✓
D. CONFIDENCE-NORM

Explanation: “BITRSHIFT” is not related to Z.TEST.

7. Which category does =Z.TEST belong to?

A. Compatibility
B. Financial
C. Date & Time
D. Statistical ✓

Explanation: Category is “Statistical”.

8. Which use case fits =Z.TEST?

A. Probability & Hypothesis Testing ✓
B. Numbering & Sample Data
C. Worksheet Info & Navigation
D. Loans & Installments

Explanation: Use case “Probability & Hypothesis Testing” fits Z.TEST.

9. Which statement about =Z.TEST is correct?

A. The following Excel formula can be used to calculate the two-tailed probability that the sample mean would be further from x (in either direction) than AVERAGE(array), when the underlying population mean is x: =2 * MIN(Z.TEST(array,x,sigma), 1 - Z.TEST(array,x,sigma)).
B. 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. ✓
C. Volatile and recalculates every time
D. Text is always ignored

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.

10. What is the output type of =Z.TEST?

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

Explanation: Output is “Number”.