Document Solutions for Excel, .NET Edition Overview
Key Features
Getting Started
Features
Templates
Formula Reference
- Add-in and Automation Functions
- Compatibility Functions
  - BETADIST
  - BETAINV
  - BINOMDIST
  - CHIDIST
  - CHIINV
  - CHITEST
  - CONFIDENCE
  - COVAR
  - CRITBINOM
  - EXPONDIST
  - FDIST
  - FINV
  - FLOOR
  - FTEST
  - GAMMADIST
  - GAMMAINV
  - HYPGEOMDIST
  - LOGINV
  - LOGNORMDIST
  - MODE
  - NEGBINOMDIST
  - NORM.INV
  - NORMDIST
  - NORMSDIST
  - NORMSINV
  - PERCENTILE
  - PERCENTRANK
  - POISSON
  - QUARTILE
  - RANK
  - STDEV
  - STDEVP
  - TDIST
  - TINV
  - TTEST
  - VAR
  - VARP
  - WEIBULL
  - ZTEST
- Database Functions
- Date and Time Functions
- Engineering Functions
- Financial Functions
- Information Functions
- Logical Functions
- Lookup and Reference Functions
- Math and Trigonometry Functions
- Statistical Functions
- Text Functions
- Web Functions
File Operations
Document Solutions Data Viewer
API Reference
Release Notes

ZTEST

This function returns the significance value of a z-test. The z-test generates a standard score for x with respect to the set of data and returns the two-tailed probability for the normal distribution.

Syntax

ZTEST(array, x, [sigma])

Arguments

This function has these arguments:

Argument	Description
array	[Required] Array of data to test
x	[Required] Value at which to test
sigma	[Optional] Known standard deviation for the population; if omitted, the calculation uses the sample standard deviation

Remarks

If sigma is not specified, the calculated standard deviation of the data in the array is used.

The equation for calculating the z-test is as follows, where n is the number of data points.

Examples

ZTEST(A2:D12,40,0.877)

ZTEST(R2C1:R12C4,2)

ZTEST({5,10,15,12,11,8,16,7},10) gives the result 0.355512703503418

ZTEST({5,10,15,12,11,8,16,7},10,3) gives the result 0.318675944098237