## 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 ): …

## ZN TEST function

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 …

## PERCENTILE RANK.EXC function

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 …

## PERCENTILE RANGE.INC function

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 …

## TREND function

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 …

## VARA function

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 …

## VAR.P function

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 …

## VARPA function

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 …

## VAR.S function

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 ): …

## PERMUTATIONS.A function

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 …