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

Read moreTN.TEST function

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 …

Read moreZN TEST function

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 …

Read moreTREND function

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 …

Read moreVARA function

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 …

Read moreVAR.P function

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 …

Read moreVARPA function

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

Read moreVAR.S function