Compatibility =ZTEST(array,x,[sigma])

Quiz =ZTEST — 10 Questions

10 quiz questions about =ZTEST — test syntax, arguments, examples & errors!

Questions: 10 questions 15 questions Random 10 or 15 questions from the pool + shuffled options each time

← ZTEST ▦ Practice in Playground

Progress — 10 questions 1 of 10

Question 1 of 10 1/10

Which statement about =ZTEST is correct?

Question 2 of 10 2/10

Which formula is a valid example of =ZTEST?

Question 3 of 10 3/10

Is argument “array” required in =ZTEST?

Question 4 of 10 4/10

Is =ZTEST volatile?

Question 5 of 10 5/10

Is argument “sigma” required in =ZTEST?

Question 6 of 10 6/10

In =ZTEST, which is argument #2?

Question 7 of 10 7/10

How many optional arguments does =ZTEST have?

Question 8 of 10 8/10

What is the type of argument “x” in =ZTEST?

Question 9 of 10 9/10

In =ZTEST, which is argument #3?

Question 10 of 10 10/10

Which function is NOT related to =ZTEST?

Click a question to see the answer.

1. Which statement about =ZTEST is correct?

A. Only works in old versions
B. This function has been replaced with one or more new functions that may provide improved accuracy and whose names better reflect their usage. Although this function is still available for backward compatibility, you should consider using the new functions from now on, because this function may not be available in future versions of Excel. ✓
C. Requires add-in
D. The following Excel formula can be used to calculate the two-tailed probability that the sample mean would be further from μ0 (in either direction) than AVERAGE(array), when the underlying population mean is μ0: =2 * MIN(ZTEST(array,μ0,sigma), 1 - ZTEST(array,μ0,sigma)).

Explanation: Correct: This function has been replaced with one or more new functions that may provide improved accuracy and whose names better reflect their usage. Although this function is still available for backward compatibility, you should consider using the new functions from now on, because this function may not be available in future versions of Excel.

2. Which formula is a valid example of =ZTEST?

A. =FORECAST(A2:A11,4)
B. ZTEST(A2:A11,4)
C. =ZTEST(A2:A11,4) ✓
D. =ZTEST(A2:A11,4, 0)

Explanation: Correct example: =ZTEST(A2:A11,4)

3. Is argument “array” required in =ZTEST?

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

Explanation: “array” is required.

4. Is =ZTEST volatile?

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

Explanation: ZTEST is not volatile.

5. Is argument “sigma” required in =ZTEST?

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

Explanation: “sigma” is optional.

6. In =ZTEST, which is argument #2?

A. x ✓
B. array
C. lookup_value
D. range

Explanation: Argument #2 is “x”.

7. How many optional arguments does =ZTEST have?

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

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

8. What is the type of argument “x” in =ZTEST?

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

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

9. In =ZTEST, which is argument #3?

A. range
B. array
C. x
D. sigma ✓

Explanation: Argument #3 is “sigma”.

10. Which function is NOT related to =ZTEST?

A. PERCENTILE
B. UNICHAR ✓
C. MODE
D. FORECAST

Explanation: “UNICHAR” is not related to ZTEST.