Returns the one-tailed P-value of a Z-test with standard distribution.

Sample Usage




Z.TEST(data, value, [standard_deviation])

  • data - The array or range containing the dataset to consider.

  • value - The test statistic to use in the Z-test.

  • standard_deviation - [ OPTIONAL ] - The standard deviation to assume for the Z-test. If this is not provided, STDEV(data) will be calculated.


  • The P-value returned by Z.TEST is the probability that a randomly generated sample (of the same size as the data) has a mean value greater than that of the original data set.
  • You can use ZTEST or Z.TEST to perform this function. 

See Also

NORMSDIST: Returns the value of the standard normal cumulative distribution function for a specified value.

NORMDIST: The NORMDIST function returns the value of the normal distribution function (or normal cumulative distribution function) for a specified value, mean, and standard deviation.

CONFIDENCE: Calculates the width of half the confidence interval for a normal distribution.


Visit the Learning Center

Using Google products, like Google Docs, at work or school? Try powerful tips, tutorials, and templates. Learn to work on Office files without installing Office, create dynamic project plans and team calendars, auto-organize your inbox, and more.

Clear search
Close search
Google apps
Main menu