Microsoft Office Tutorials and References
In Depth Information
The equation for the cumulative distribution function is
The equation for the probability density function is
Use either TRUE or
FALSE for the
cumulative argument with the
ZTEST returns the two-tailed P-value of a z-test.
The ZTEST function is used to generate a standard score for x for the data set, and returns the
two-tailed probability for the normal distribution. Use this function to assess whether a
particular data value is from a particular population. Figure 11.56 shows an example of ZTEST .
Is the data set against which to test x.
Is the value to test.
Is the population standard deviation. If omitted the sample standard
deviation is used.
The equation for ZTEST is