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

Which function is related to =Z.TEST?

Question 2 of 10 2/10

Is argument “x” required in =Z.TEST?

Question 3 of 10 3/10

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

Question 4 of 10 4/10

Which use case fits =Z.TEST?

Question 5 of 10 5/10

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

Question 6 of 10 6/10

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

Question 7 of 10 7/10

Which statement about =Z.TEST is correct?

Question 8 of 10 8/10

How many required arguments does =Z.TEST have?

Question 9 of 10 9/10

What usually causes #N/A in =Z.TEST?

Question 10 of 10 10/10

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

Click a question to see the answer.

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

A. IMREAL
B. AVERAGEA
C. VDB
D. CONFIDENCE-NORM ✓

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

2. Is argument “x” required in =Z.TEST?

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

Explanation: “x” is required.

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

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

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

4. Which use case fits =Z.TEST?

A. Dynamic Ranges & Dashboards
B. Probability & Hypothesis Testing ✓
C. Advanced Formulas
D. Text Manipulation

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

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

A. Volatile and recalculates every time
B. Output is always a dynamic array
C. Text is always ignored
D. Check the data range ✓

Explanation: If array is empty, Z.TEST returns the #N/A error value. — Fix: Check the data range

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

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

Explanation: Type of “sigma” is “Number”.

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

A. Volatile and recalculates every time
B. 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)).
C. Only works in old versions
D. 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. ✓

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.

8. How many required arguments does =Z.TEST have?

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

Explanation: =Z.TEST has 2 required, 1 optional (3 total).

9. What usually causes #N/A in =Z.TEST?

A. Requires add-in
B. If array is empty, Z.TEST returns the #N/A error value. ✓
C. Output is always a dynamic array
D. Volatile and recalculates every time

Explanation: If array is empty, Z.TEST returns the #N/A error value. — Fix: Check the data range

10. How many arguments does =Z.TEST have in total?

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

Explanation: =Z.TEST has 2 required, 1 optional (3 total).