ZTEST(ref,x)
ZTEST z-.
@ref - , @x - .
@ref ZTEST #DIV/0!.
Excel.
, A1, A2, ..., A5 11.4, 17.3, 21.3, 25.9 40.1.
ZTEST(A1:A5,20) 0.254717826.
CONFIDENCE, NORMDIST, NORMINV, NORMSDIST, NORMSINV, STANDARDIZE.