Office information

T.DIST: The function returns the Student's t-distribution on the left. Functions used in testing the hypothesis of small numbers of data sets. Support functions from Excel 2010

T.DIST.2T: The function returns the two-tailed Student's t-distribution. Functions used in testing the hypothesis of small numbers of data sets. Support functions from Excel 2010

T.DIST.RT: The function returns the Student's t-distribution on the right. Functions used in testing the hypothesis of small numbers of data sets. Support functions from Excel 2010

T.INV: The function returns the inverse value of the Student t-distribution. Support functions from Excel 2010 onwards. Syntax: T.INV (probability, deg_freedom)

T.INV.2T: The function returns the two-sided inverse of the Student's t-distribution. Support functions from Excel 2010 onwards. Syntax: T.INV (probability, deg_freedom)

T.TEST: The function returns the probability associated with Student's t-Test. Support functions from Excel 2010 onwards. Syntax: T.TEST (array1, array2, tails, type)

TREND: The function returns values ​​in a linear trend. Syntax: TREND (known_ys, [known_xs], [new_xs], [const])

TRIMMEAN function: The function returns the average of the inside of the data set. The function calculates by removing which percentage of the value is in the first or last

VAR.P function: Function that calculates variance based on the entire set, ignoring logical values ​​and text. Support functions from Excel 2010 onwards. Syntax: VAR.P (number1,

VAR.S function: Function that calculates variance based on a sample, ignoring logical values ​​and text. Support functions from Excel 2010 onwards. Syntax: VAR.S (number1,

VARA function: The function performs a calculation of variance based on a sample, including logical values ​​and text. Syntax: VARA (value1, [value2], ...)

VARPA function: Function that calculates variance based on the entire set, including logical values ​​and text. Syntax: VARPA (value1, [value2], ...)

Z.TEST: The function returns the one-sided P value of the z test. Support functions from Excel 2010 onwards. Syntax: Z.TEST (array, x, [sigma])

LINEST function: The function returns the line description array using the least squares method. Syntax: LINEST (known_ys, [known_xs], [const], [stats])

CELL function: The function returns information about the format or content of a cell. Syntax: CELL (info_type, [reference])

ERROR.TYPE function: The function returns the number corresponding to one of the error values ​​in Microsoft Excel, or the # N / A error if there are no errors. Syntax: ERROR.TYPE

INFO function: The function returns the current operating environment information. Syntax: INFO (type_text)

NORM.DIST: The function returns the normal distribution with a standard deviation and a defined mean. Functions widely used in hypothesis testing statistics. Support functions from

NORM.INV function: The function returns the inverse of the standard cumulative distribution with the standard deviation and the specified mean. Support functions from Excel 2010

NORM.S.DIST: The function returns the normalized distribution with a mean of 0 and a standard deviation of 1. Use the function instead of a table containing standardized curve