ZTEST Function

The ZTEST function is one of the statistical functions. It is used to return the one-tailed probability-value of a z-test. For a given hypothesized population mean, μ0, ZTEST returns the probability that the sample mean would be greater than the average of observations in the data set (array) — that is, the observed sample mean.

The ZTEST function syntax is:

ZTEST(array, x [, sigma])

where

array is the range of numeric values against which to test x.

x is the value to test.

sigma is a population standard deviation. This is an optional argument. If it is omitted, the sample standard deviation is used.

The values can be entered manually or included into the cell you make reference to.

To apply the ZTEST function,

1. select the cell where you wish to display the result,
2. click the Insert function
   icon situated at the top toolbar,
   or right-click within a selected cell and select the Insert Function option from the menu,
   or click the
   icon situated at the formula bar,
3. select the Statistical function group from the list,
4. click the ZTEST function,
5. enter the required arguments separating by commas or select a range of cells with the mouse,
6. press the Enter button.

The result will be displayed in the selected cell.

Alla pagina precedente