Office information

GEOMEAN function: The function returns the average of a positive array or range of data. Use the function to calculate the average growth when knowing the gross profit with

GROWTH function: The function calculates the exponential growth value using existing data. Syntax: GROWTH (known_ys, [known_xs], [new_xs], [const])

GUSSE function: The function returns the probability that an element of the normalized population will fall into the mean and the standard deviation. Support functions from Excel

HARMEAN function: The function returns the harmonic mean of a dataset, the harmonic mean is the reciprocal of the arithmetic mean of the reciprocals. Syntax: HARMEAN (number1,

HYPGEOM.DIST: The function returns the hyperinfection distribution, using this function for problems with finite sets of vowismooix observations whether or not they are successful.

Description: The function returns the sharp coefficient of the dataset. Kurtosis indicates the sharp or flat characteristics of a dataset. - If the coefficient is positive - the

LARGE function: The function returns the kth largest value in a dataset. Use the function to determine the position of the value in a dataset. Syntax: LARGE (array, k)

LOGEST: The function returns the data array that describes the exponential curve that fits the given data. - The equation of the curve is: y = b * m ^ x or y = (b * (m1 ^ x1) * (m2

LOGNORM.DIST: The function returns the logarithmic distribution of x. Where LN (x) is usually distributed with parameter mean and standard deviation. Support functions from Excel

LOGNORM.INV: The function returns the inverse of the logarithmic distribution of x. Where LN (x) is usually distributed with parameter mean and standard deviation. Use functions to

MAX function: The function returns the largest value in the set of values. Syntax: MAX (number1, [number2], ...)

MAXA function: The function returns the largest value in a set of values ​​including text and logical values. Syntax: MAXA (value1, [value2], ...)

MEDIAN function: The function returns the median of the given numbers. Median number is the number in the middle of a set of numbers. Syntax: MEDIAN (number1, [number2], ...)

MIN function: The function returns the smallest value in the given numbers. Syntax: MIN (number1, [number2], ...)

MINA function: The function returns the smallest value in the given numbers including text and logical values. Syntax: MINA (value1, [value2], ...)

MODE.MULT function: The function returns a vertical array of the most frequently occurring values, or repeating values ​​in an array or data range. Support functions from Excel

NEGBINOM.DIST: The function returns the negative binomial distribution, the probability that there will be Number_f failures before the Number_s th success, with the probability of

CONFIDENCE.T function: The function returns the confidence interval of the population by using the Student's t-distribution. Support functions from Excel 2010 onwards. Syntax:

CORREL function: The function returns the correlation coefficient between two data sets. Correlation coefficient is used to determine the relationship between two attributes.

COUNT function: The function performs counting cells containing numbers in the list of arguments. Syntax: COUNT (value1, [value2], ...)