Name

ZTEST

Synopsis

Use ZTEST to find the two-tailed P-value of a Z-Test. This function is typically used to determine the likelihood that a particular observation is drawn from a particular population.

To Calculate

=ZTEST(Array, X, Sigma)

The Sigma argument is optional for this function. The other arguments are required.

Array

Indicates an array of numeric values to test the value of X against.

X

Indicates a numeric value that you want to test against the values in the array specified by the Array argument.

Sigma

Indicates a numeric value that specifies the standard deviation for the population. If this value is omitted, a sample standard deviation is calculated for the values of the Array argument.

Example

Figure 15-52 illustrates how ZTEST is used to determine the probability that a specific value is part of the same population as the values specified in the array.

Use ZTEST to determine the probability that a value is part of the specified array

Figure 15-52. Use ZTEST to determine the probability that a value is part of the specified array

Get Excel 2000 in a Nutshell now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial