Home
Tech info
Technology
Science
Life
Application
Electric
Program
Mobile
Windows 10
Windows 11Z.TEST function - The function returns one-sided value of the z test in Excel
The following article introduces you to the Z.TEST function - one of the functions in the statistical function group is very popular in Excel.
Description: The function returns one-sided P value of the z test. Support functions from Excel 2010 onwards.
Syntax: Z.TEST (array, x, [sigma])
Inside:
- array: An array or range of data to test for x, which is a required parameter.
- x: Value to check, is the required parameter.
- sigma: The overall standard deviation, which is an optional value, if omitted the sample standard deviation to be used.
Attention:
- If array is empty -> the function returns the # N / A error value
- When sigma is omitted -> Z.TEST is calculated by the formula:
Z.TEST (array, x, sigma) = 1- Norm.S.Dist ((Average (array) - x) / (sigma / √n), TRUE)
- Where sigma is not ignored -> Z.TEST function is calculated by the formula:
Z.TEST (array, x) = 1- Norm.S.Dist ((Average (array) - x) / (STDEV (array) / √n), TRUE)
Inside:
+ x is the sample mean AVERAGE (array)
+ n is COUNT (array).
- Z.TEST shows that when the base overall average is μ0 -> the probability of sample mean will be greater than the observed value of AVERAGE (array).
- You can use the following formula to calculate the probability of 2 sides:
= 2 * MIN (Z.TEST (array, x, sigma), 1 - Z.TEST (array, x, sigma)).
For example:
Calculate the 1-sided probability of z-tests as described in the following data table:
- Calculate the 1-sided probability value of the z-test for the dataset above. In a cell to calculate, enter the formula : = Z.TEST (D6: J6, D7, D8)
- Press Enter -> probability value 1 side of the z test for the above data set is:
- Calculate the one-sided probability value of the z-test for the data set above, ignoring the overall standard deviation. In a cell to calculate enter the formula : = Z.TEST (D6: J6, D7)
- Press Enter -> probability value 1 side of the z test for the above data set, ignoring the overall standard deviation of:
Above are instructions and some specific examples when using the Z.TEST function in Excel.
Good luck!
Isabella HumphreyYou should read it
- T.TEST function - The function returns the probability associated with Student's t-Test in Excel
- ZTEST function - Returns the probability value on one side of the z test in Excel
- FTEST function - The function returns the result of an F-Test in Excel
- TTEST - Returns the probability associated with a Student's t-Test in Excel
- T.INV.2T - The function returns the two-sided inverse of the Student's t-distribution in Excel
- BINOM.DIST.RANGE function - The function returns the probability of a test result using binomial distribution in Excel
- FISHER function - The function returns the Fissher transformation at x in Excel
- CHITEST function - The function returns the independence test in Excel
May be interested
- How to use the NORMDIST function in Excel - Function that returns the distribution in Excel
the normdist function returns a distribution with a specified mean and standard deviation. the normdist function has applications in statistics, including hypothesis testing. - CHITEST function - The function returns the independence test in Excelthe following article details how to use chitest, the function returns independence test.
- How to use the IF function in Excelthe if function in excel checks for a true or false condition. if the condition is true, the function returns a value, if the condition fails the function returns another value
- GAMMA function - The function returns the gamma function value in Excelgamma: the function returns the gamma function. support functions from excel 2013 onwards. syntax: gamma (number)
- POISSON.DIST function - The function returns the Poisson distribution in Excelpoisson.dist function: the function returns the poisson distribution, the application function to predict the number of events in a specific time. support functions from excel 2013 onwards. syntax: poisson.dist (x, mean, cumulative)
- WEIBULL function - The function returns the Weibull distribution in Excelthe function performs the calculation and returns the weibull distribution. based on this distribution to analyze reliability in theory such as calculating the average life of the device or used in the field of meteorology, hydrology and weather forecast.
- QUARTILE.EXC function - The function returns the quartile of a dataset without values 0 and 1 in Excelquartile.exc function: the function returns the quartile of the data set, with percentile values from 0 to 1 excluding 0 and 1. the support function is from excel 2010 onwards. syntax: quartile.exc (array, quart)
- PHI function - The function returns the value of the density function for a normal distribution in Excelphi function: the function returns the value of the density function for a standard normal distribution. support functions from excel 2013 onwards. syntax: phi (x)
- FORECAST function - The function returns a value along a linear trend in Excelforecast function: the function performs the calculation or prediction of a future value by using current values using linear regression. in excel 2016 this function is replaced by forecast.linear function. syntax: forecast (x, known_ys, known_xs)
- BETA.DIST function - The function returns the Beta distribution in Excelbeta.dist function: the function returns the beta distribution to study the variability of a number of things through a sample. support functions from excel 2010 onwards. syntax: beta.dist (x, alpha, beta, cumulative, [a], [b])
Office information
- LINEST function - The function returns a line description array using the least square method in Excel
- CELL function - The function returns information about the format or content of a cell in Excel
- ERROR.TYPE function - The function returns the number corresponding to one of the error values in Microsoft Excel
- INFO function - The function returns the current operating environment information in Excel
- NORM.DIST function - The function returns the normal distribution with the standard deviation and the mean value specified in Excel
- NORM.INV function - The function returns the inverse of the standard cumulative distribution in Excel
LINEST function - The function returns a line description array using the least square method in Excel
CELL function - The function returns information about the format or content of a cell in Excel
ERROR.TYPE function - The function returns the number corresponding to one of the error values in Microsoft Excel
INFO function - The function returns the current operating environment information in Excel
NORM.DIST function - The function returns the normal distribution with the standard deviation and the mean value specified in Excel
NORM.INV function - The function returns the inverse of the standard cumulative distribution in Excel