## TN.TEST function

Category:Statistics Name in English:T.TEST That makes? Returns the probability associated with the Student’s t test. Syntax TEST.TN (array1, array2, queues, type) matrix1 (required ): First data range. matrix2 (required ): …

The statistical functions in Excel will allow you to make a statistical analysis of your data. You will be able to obtain the covariance, standard deviation, beta distribution, binomial distribution among others.

Find the detail and examples of each function by clicking on its name.

FUNCIÓN |
INGLÉS |
DESCRIPCIÓN |

MIDDLE | MIDDLE | Returns the mean of a data set after removing the percentage from the lower and upper bounds. |

KESIMO.MENOR | KESIMO.MENOR | Find the k-th smallest value in a range. |

COUNTA | COUNTA | Counts the number of cells that are not empty. |

COUNT | COUNT | Counts the number of cells that contain numbers. |

HIERARCHY.EQV | HIERARCHY.EQV | Gets the position (hierarchy) of a number within a list of numbers. |

HIERARCHY.MEDIA | HIERARCHY.MEDIA | Gets the position (hierarchy) of a number within a list of numbers. If more than one value has the same hierarchy, the average of the hierarchy is returned. |

GAMMA.LN.EXACT | GAMMA.LN.EXACT | Returns the natural logarithm of the gamma function. |

MEDIA.ARMO | MEDIA.ARMO | Returns the harmonic mean of a data set. |

MEDIA.GEOM | MEDIA.GEOM | Gets the geometric mean of a list of specified numbers. |

COEFFICIENT.ASYMMETRY.P | COEFFICIENT.ASYMMETRY.P | The function COEFFICIENT.ASYMMETRY.P returns the bias of a distribution based on a population: a characterization of the degree of skewness of a distribution around its mean. |

AVERAGE | AVERAGE | Gets the average of the specified numbers. |

DEVESTA | DEVESTA | Find the standard deviation of a sample. |

MINE | MINE | Find the minimum value of a list of numbers considering numbers, text, and logical values. |

STDEV | STDEV | Calculate the standard deviation based on the entire population considering numbers, text, and logical values. |

MAXA | MAXA | Returns the largest value from a list of arguments including numbers, text, and logical values. |

DEVPROM | DEVPROM | Returns the average of the absolute deviations from the mean of the supplied numbers. |

K.TH.MAJOR | K.TH.MAJOR | Find the k-th largest value in a range. |

COUNTBLANK | COUNTBLANK | Counts blank cells within a range. |

COUNTIF | COUNTIF | Counts the cells in a range that meet the specified condition. |

COUNTIF SET | COUNTIF SET | Counts the cells in a range that meet multiple specified criteria. |

PERCENTILE RANGE.INC | PERCENTILE RANGE.INC | Returns the range of a value in a data set as a percentage (including 0 and 1). |

PROBABILITY | PROBABILITY | Returns the probability that the values in a range fall between two limits. |

QUARTILE.EXC | QUARTILE.EXC | Returns the quartile of a data set based on percentile values from 0 to 1, exclusive. |

FI | FI | The FI function returns the value of the density function for a standard normal distribution. |

GAUSS | GAUSS | The GAUSS function returns 0.5 less than the standard normal cumulative distribution. |

CORREL.COEF | CORREL.COEF | Returns the correlation coefficient between two ranges of cells. |

PERCENTILE.EXC | PERCENTILE.EXC | Returns the k-th percentile of the values in a range, where k is in the range 0 to 1, exclusive. |

SLOPE | SLOPE | Returns the slope of a linear regression line. |

INV.NORM | INV.NORM | Returns the inverse of the normal cumulative distribution for the given mean and standard deviation. |

PERCENTILE RANK.EXC | PERCENTILE RANK.EXC | Returns the range of a value in a data set as a percentage (excluding 0 and 1). |

GAMMA | GAMMA | The GAMMA function returns the values of the gamma function. |

GAMMA.DIST | GAMMA.DIST | Returns the gamma distribution. |

INV.NORM.STAND | INV.NORM.STAND | Returns the inverse of the cumulative standard normal distribution with a mean of zero and a standard deviation of one. |

INV.GAMMA | INV.GAMMA | Returns the inverse function of the cumulative gamma distribution. |

GAMMA.LN | GAMMA.LN | Returns the natural logarithm of the gamma function. |

LINEST | LINEST | Calculates statistics for a line using the “least squares” method to find the straight line that best fits the data, and returns a matrix that describes the line. |

MEDIUM | MEDIUM | Returns the median of the given numbers. |

MIN | MIN | Find the minimum value of a list of numbers. |

MODE ONE | MODE ONE | Returns the most frequently repeated value in an array or range of data. |

FORECAST.ETS.SEASONALITY | FORECAST.ETS.SEASONALITY | The FORECAST.ETS.SEASONALITY function returns the length of the repeating pattern that Microsoft Excel detects for the specified time series. |

FORECAST.ETS.CONFINT | FORECAST.ETS.CONFINT | The FORECAST.ETS.CONFINT function returns a confidence interval for the expected value on the specified target date. |

VAR.P | VAR.P | Calculates variance based on the entire population. |

STDEV | STDEV | Finds the standard deviation of the entire population provided as an argument. |

COEFFICIENT.ASYMMETRY | COEFFICIENT.ASYMMETRY | Returns the skewness of a set of values. |

MAX | MAX | Find the maximum value of a list of numbers. |

FASHION MISCELLANEOUS | FASHION MISCELLANEOUS | Returns a vertical array of the most frequently occurring or repeating values in an array or range of data. It must be used as an array formula. |

Function TEST.FN | Function TEST.FN | Returns the result of an F test. |

AVERAGEIF | AVERAGEIF | Gets the average of the numbers that meet the specified criteria. |

PEARSON | PEARSON | Returns the Pearson product moment of correlation coefficient. |

TN.TEST | TN.TEST | Returns the probability associated with the Student’s t test. |

AVERAGE | AVERAGE | Returns the average of its arguments, including numbers, text, and logical values. |

DEVIA2 | DEVIA2 | Return the sum of the squares of the diversions. |

STDEV | STDEV | Calculate the standard deviation from a sample. |

VARPA | VARPA | Calculates the variance of the entire population, including numbers, text, and logical values. |

VARA | VARA | Calculates the variance of a sample, including numbers, text, and logical values. |

LOGEST | LOGEST | Calculates an exponential curve that fits the data and returns the matrix of values that describes the curve. |

AVERAGEIF | AVERAGEIF | Gets the average of the numbers that meet multiple criteria. |

PERMUTATIONS.A | PERMUTATIONS.A | The PERMUTATIONS.A function returns the number of permutations of a given number of objects (with repetitions) that can be selected from the total number of objects. |

PERCENTILE.INC | PERCENTILE.INC | Returns the k-th percentile of the values in a range, where k is in the range 0 to 1, inclusive. |

INV.BETA.N | INV.BETA.N | Returns the inverse of the cumulative beta probability density function. |

BETA.N. | BETA.N. | Returns the beta probability distribution function. |

VAR.S | VAR.S | Find the variance of a sample. |

TREND | TREND | Returns values that result from a linear trend. |

FORECAST.ETS | FORECAST.ETS | The FORECAST.ETS function returns the expected value for a target date using the exponential smoothing method. |

ZN TEST | ZN TEST | Returns the one-tailed probability value of a z-test. |

QUARTILE.INC | QUARTILE.INC | Returns the quartile of a data set. |

COEFFICIENT.R2 | COEFFICIENT.R2 | Returns the square of the moment correlation coefficient of the Pearson product. |

INTERVAL.TRUST.NORM | INTERVAL.TRUST.NORM | Returns the confidence interval for the mean of a population with a normal distribution. |

FORECAST | FORECAST | Forecasts future value through existing values. |

NORM.DIST.N | NORM.DIST.N | Returns the standard normal distribution. |

NORM.DIST | NORM.DIST | Returns the cumulative normal distribution. |

INV.LOGNORM | INV.LOGNORM | Returns the inverse function of the cumulative logarithmic normal distribution. |

INTERSECTION.AXIS | INTERSECTION.AXIS | Finds the point where a line will intersect the y-axis using the existing X and Y values. |

TYPICAL ERROR.XY | TYPICAL ERROR.XY | Returns the standard error of the predicted y-value for each x in the regression. |

NEGBINOM.DIST | NEGBINOM.DIST | Returns the negative binomial distribution. |

HYPGEOM.DIST | HYPGEOM.DIST | Returns the hypergeometric distribution. |

NORMALIZATION | NORMALIZATION | Returns a normalized value. |

DISTR.LOGNORM | DISTR.LOGNORM | Returns the logarithmic normal distribution. |

INTERVAL.TRUST.T | INTERVAL.TRUST.T | Returns the confidence interval for the mean of a population with Student’s t distribution. |

CURTOSIS | CURTOSIS | Returns the kurtosis of a data set. |

POISSON.DIST | POISSON.DIST | Returns the Poisson distribution. |

EXP.DIST | EXP.DIST | Returns the exponential distribution. |

PERMUTATIONS | PERMUTATIONS | Returns the number of permutations for a specified number of objects. |

COVARIANZA.M | COVARIANZA.M | Returns the sample covariance between two data sets. |

COVARIANCE.P | COVARIANCE.P | Returns the covariance of the population between two data sets. |

CHICUAD.TEST | CHICUAD.TEST | Returns the value of the chi square distribution. |

TEST.FISHER.INV | TEST.FISHER.INV | Returns the inverse function of the Fisher transformation. |

FORECAST.LINEAR | FORECAST.LINEAR | The FORECAST.LINEAR function calculates or predicts a future value on a linear trend using existing values. |

FORECAST.ETS.STAT | FORECAST.ETS.STAT | The FORECAST.ETS.STAT function returns the required statistics of the forecast. |

SERIES BINOMDIST | SERIES BINOMDIST | The SERIES BINOMDIST function returns the probability of a test result that uses a binomial distribution. |

GROWTH | GROWTH | Calculate exponential growth forecast from existing data. |

CDFDIST | CDFDIST | Returns the right-tailed distribution of probability F or degree of diversity. |

DISTR.WEIBULL | DISTR.WEIBULL | Returns the Weibull distribution. |

INV.F.CD | INV.F.CD | Returns the inverse of the right-tailed F probability distribution. |

CHICADIST | CHICADIST | Returns the chi square distribution. |

CDTDIST | CDTDIST | Returns the right-tailed Student’s t distribution. |

NDIST | NDIST | Returns the left-tailed distribution of probability F or degree of diversity. |

2C TDIST | 2C TDIST | Returns the two-tailed Student’s t distribution. |

INV.F | INV.F | Returns the inverse of the probability distribution F. |

BINOMDIST | BINOMDIST | Returns the probability of a discrete random variable following a binomial distribution. |

BINOM INV | BINOM INV | Returns the smallest value whose cumulative binomial distribution is greater than or equal to a criterion value. |

FISHER | FISHER | Returns the Fisher transformation on x. |

INV.CHICUAD | INV.CHICUAD | Returns the inverse of the left-tailed probability of the chi-square distribution. |

INV.CHICUAD.CD | INV.CHICUAD.CD | Returns the inverse of the right-tailed probability of the chi-square distribution. |

INV.T | INV.T | Returns the inverse of the left-tailed Student’s t-distribution. |

INV.T.2C | INV.T.2C | Returns the inverse of the two-tailed Student’s t distribution. |

CD CHICADIST | CD CHICADIST | Returns the right-tailed probability of the chi-square distribution. |

TNDIST | TNDIST | Returns the left-tailed Student’s t distribution. |

FREQUENCY | FREQUENCY | Gets the frequency with which the values within a data range are repeated. |

Category:Statistics Name in English:T.TEST That makes? Returns the probability associated with the Student’s t test. Syntax TEST.TN (array1, array2, queues, type) matrix1 (required ): First data range. matrix2 (required ): …

Category:Statistics Name in English:Z.TEST That makes? Returns the one-tailed probability value of a z-test. Syntax TEST.ZN (matrix, x, [sigma]) array (required ): Data range to check for x. x (mandatory …

Category:Statistics Name in English:PERCENTRANK.EXC That makes? Returns the range of a value in a data set as a percentage (excluding 0 and 1). Syntax RANGO.PERCENTIL.EXC (matrix, x, [significant_digit]) matrix (mandatory …

Category:Statistics Name in English:PERCENTRANK.INC That makes? Returns the range of a value in a data set as a percentage (including 0 and 1). Syntax RANGO.PERCENTIL.INC (matrix, x, [significant_digit]) matrix (mandatory …

Category:Statistics Name in English:TREND That makes? Returns values that result from a linear trend. Syntax TREND (known_y, [known_x], [new_x_matrix], [constant]) known_y (required ): y values, known in the equation y …

Category:Statistics Name in English:VARA That makes? Calculates the variance of a sample, including numbers, text, and logical values. Syntax VARA (value1, [value2],…]) value1 (required ): The first value in the …

Category:Statistics Name in English:VAR.P That makes? Calculates variance based on the entire population. Syntax VAR.P ( number1 , [number2],…]) number1 (required ): The first value of the population. number2 (optional …

Category:Statistics Name in English:VARPA That makes? Calculates the variance of the entire population, including numbers, text, and logical values. Syntax VARPA (value1, [value2],…]) value1 (required ): The first value in …

Category:Statistics Name in English:VAR.S That makes? Find the variance of a sample. Syntax VAR.S ( number1 , [number2],…]) number1 (required ): The first value in the sample. number2 (optional ): …

Category:Statistics What does the PERMUTATIONS.A function do? The PERMUTATIONS.A function returns the number of permutations of a given number of objects (with repetitions) that can be selected from the total …