Office information

: The function returns the Pearson product moment correlation coefficient, r with a scalar index in the range from -1 to 1. The function reflects the linear relationship expansion

PERCENTILE.EXC function: The function returns the kth percentile of values ​​in the range with k in the range from 0 to 1, excluding values ​​0 and 1. Syntax: PERCENTILE.EXC

PERCENTILE.INC function: The function returns the kth percentile of values ​​in the range with k in the range from 0 to 1. Syntax: PERCENTILE.INC (array, k)

PERMUT function: The function returns the number of permutations of a given object. Permutations are subsets of values ​​where the position and number of elements in permutations

PERMUTATIONA function: The function returns the number of permutations (can be repeated) of a given object. Support functions from Excel 2013 onwards. Syntax: PERMUTATIONA (number,

PHI function: The function returns the value of the density function for a standard normal distribution. Support functions from Excel 2013 onwards. Syntax: PHI (x)

POISSON.DIST function: The function returns the Poisson distribution, the application function to predict the number of events in a specific time. Support functions from Excel 2013

QUARTILE.EXC function: The function returns the quartile of the data set, with percentile values ​​from 0 to 1 excluding 0 and 1. The support function is from Excel 2010 onwards.

QUARTILE.INC function: The function returns the quartile of a data set, with percentile values ​​from 0 to 1 including 0 and 1. Support functions from Execl 2010 onwards. Syntax:

RANK.AVG function: The function returns the rank of a number in a list of numbers whose size is in correlation with other values. If multiple values ​​have the same rank -> the

RSQ: The function returns the square of the Pearson moment correlation coefficient through data points in known_ys and known_xs. Syntax: RSQ (known_ys, known_xs)

SKEW function: The function returns the deviation of the distribution - the deviation represents the asymmetry of the distribution around its axis. - Negative deviations: The

SLOPE function: The function returns the slope of a linear regression line through data points. The slope is the vertical distance divided by the horizontal distance between any

SMALL function: The function returns the kth smallest value in a dataset. Syntax: SMALL (array, k)

STANDARDIZE function: The function returns the normalized value from a distribution characterized by mean and standard_dev arguments. Syntax: STANDARDIZE (x, mean, standard_dev)

STDEV.P: The function returns the standard deviation based on the whole population, ignoring logical values ​​and text. Standard deviation is a measure of the dispersion of values

STDEV.S function: The function returns the standard deviation based on a sample, ignoring logical values ​​and text. Standard deviation is a measure of the dispersion of values

GAMMA.INV: The function returns the inverse of the gamma distribution, using this function to study their distribution variables that may be symmetrical. Support functions from

GAMMALN: The function returns the natural logarithm of the gamma function, Γ (x). Syntax: GAMMALN (x)

GAMMALN.PRECISE function: The function returns the natural logarithm of the gamma function, Γ (x). The function is not different from the GAMMALN function, but the function only