Office information

COUNTA function: The function performs counting non-blank cells in the list of arguments. Syntax: COUNTA (value1, [value2], ...)

COUNTBLANK function: The function performs counting empty cells in the list of arguments. Syntax: COUNTBLANK (range)

COUNTIF function: The function performs counting the number of cells in the data table that meet certain conditions. Syntax: COUNTIF (range, criteria)

COUNTIFS function: The function performs counting the number of cells in a data table that satisfy many conditions. Syntax: COUNTIFS (criteria_range1, criteria1, [criteria_range2,

DEVSQ function: Returns the sum of squares of deviations of data points from the sample mean. Syntax: DEVSQ (number1, [number2], ...)

EXPON.DIST function: The function returns the exponential distribution, using this function to model the time of events. Syntax: EXPON.DIST (x, lambda, cumulative)

F.DIST function: The function returns the probability distribution F. The function supports the version from Excel 2010. Syntax: F.DIST (x, deg_freedom1, deg_freedom2, cumulative)

F.DIST.RT function: The function returns the right probability distribution F for 2 data sets. Support functions from the Excel 2010 version. Syntax: F.DIST (x, deg_freedom1,

F.INV function: The function returns the inverse of the probability distribution F. Support function from the Excel 2010 version. Syntax: F.INV (probability, deg_freedom1,

F.INV.RT function: The function returns the inverse of the right probability distribution F. Support functions from the Excel 2010 version. Syntax: F.INV.RT (probability,

F.TEST: The function returns the result of the F - test, the probability of two ends where the variance of 2 arrays is not significant. Support functions from Excel 2010 version.

FISHER function: The function returns the Fissher transformation at x. This transformation creates a normal distribution function, using this function to test a hypothesis based on

FISHERINV function: The function returns the inverse of the Fissher transformation. Use this function to analyze the correlation between two data arrays, if y = FISHER (x) ->

FORECAST 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

FREQUENCY function: Function that calculates and returns the frequency of occurrences of values ​​within a certain range and returns a vertical number array. Syntax: FREQUENCY

GAMMA: The function returns the gamma function. Support functions from Excel 2013 onwards. Syntax: GAMMA (number)

GAMMA.DIST: The function returns the gamma distribution, using this function to study skewed distribution variables. Support functions from Excel 2010 onwards. Syntax: GAMMA.DIST

SECOND function: The function returns the second part of the time value. The second value is an integer, and has a value between 0 and 59 seconds. Syntax: SECOND (serial_number)

TIME function: The function returns the decimal number for a time value. The decimal number that the function returns is from 0 to 0.99988426, which corresponds to the time from

TIMEVALUE function: The function returns the decimal number of time indicated by a text string. The decimal number that the function returns is from 0 to 0.99988426, which