Functions
Z.TEST
Z-test p-value
Try it
When to use it
When should I use Z.TEST?
Use Z.TEST when you want to test whether a hypothesized population mean is plausible given a sample — it returns the one-tailed p-value of a z-test, and is most appropriate when the sample size is large (typically n ≥ 30) or the population standard deviation is known.
Used in
Syntax
Z.TEST(data,mu,[sigma])Examples
=Z.TEST({1,2,3,4,5,6},5.5,1.2) // => 0.9999777214546978
=Z.TEST({1,2,3,4,5,6},5.5) // => 0.9955856195235906