Menu
EXCEL Z.TEST FUNCTION
Excel Z.TEST Function Introduction
The Excel Z.Test function computes the one-tailed probability value of the Z-Test for a specified hypothesised sample mean and a supplied set of results.
In other words, the function returns the likelihood that the specified hypothesised sample mean exceeds the mean of the supplied data values.
Excel 2010 introduces the Z.Test function. This, however, is essentially an improved version of the Ztestfunction, which was available in previous versions of Excel.
Description of Excel Z.TEST Function
Syntax :
=Z.TEST( array, x, [sigma] )
Parameters :
- array – The array is the collection of numbers against which the hypothesised sample mean will be checked.
- x-The sample mean as hypothesised.
- [sigma]-An optional input representing the population standard deviation, if known. If this parameter is not specified, the function will utilise the sample standard deviation.
Step By Step Guide of Z.TEST Function
Example :
- Column A of the spreadsheet on the right has a 12-value array. The average of these numbers is 5.25.
- The Excel Z.Test function is shown in Cells B1 and B2 of the example spreadsheet to determine
- the one-tailed probability value of the Z-Test for two distinct hypothesised sample means.
- The one-tailed probability value of the Z-Test for the predicted sample mean of 5.0 is computed using the formula: =Z.TEST(A1:A12, 5.0), yielding the result 0.371103279.
- The one-tailed probability value of the Z-Test for the predicted sample mean of 6.0 is computed using the formula: =Z.TEST(A1:A12, 6.0), yielding the result 0.838129187.
Key Points
- #N/A – Occurs if the array given is empty.
- #NUM! – Occurs when the [sigma] argument is provided and equals zero.
- #DIV/0! – If any of the following conditions is met: The [sigma] parameter is missing, and the given array’s standard deviation is 0. or There is just one value in the given array.
- #VALUE! – This error occurs when either the supplied x or the supplied [sigma] is non-numeric.
Related Functions
HLOOKUP Function
HLOOKUP Function
Explore NowVLOOKUP Function
VLOOKUP Function
Explore NowINDEX Function
INDEX Function
Explore NowMATCH Function
MATCH Function
Explore NowDATE Function
DATE Function
Explore NowIF Function
IF Function
Explore NowOR Function
OR Function
Explore NowAND Function
AND Function
Explore NowRANK Function
RANK Function
Explore NowSUMIF Function
SUMIF Function
Explore NowXIRR Function
XIRR Function
Explore NowWORKDAYS Function
WORKDAYS Function
Explore Now
