Z.TEST()/ZTEST()

Syntax. Z.TEST(array,μ0,sigma)

Definition. This function returns the one-tailed probability value for a Gauss test (normal distribution). For the expected value of a random variable (μ0), the Z.TEST() function returns the probability that the sample mean would be greater than the average of observations in the data set (array)—that is, the observed sample mean.

Arguments

  • array (required). The array or range of data against which to test μ0.

  • μ0 (required). The value to test.

  • sigma (optional). The known standard deviation of the population. If this argument is not specified, the standard deviation of the sample is used.

Note

If array is empty, the Z.TEST() function returns the #N/A error.

Z.TEST() is calculated as follows when sigma is ...

Get Microsoft® Excel® 2010 Formulas & Functions Inside Out 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