|
AVEDEV
|
Returns the average of the absolute deviations of values from their
mean.
|
|
AVERAGE
|
Returns the average (arithmetic mean) of the parameters.
|
|
AVERAGEA
|
Returns the average (arithmetic mean) of the parameters.
|
|
AVERAGEIF
|
Returns the average (arithmetic mean) of the array elements that
satisfy a condition.
|
|
AVERAGEIFS
|
Returns the average (arithmetic mean) of all array elements which
satisfy one or several conditions.
|
|
BETA.DIST
|
Returns the cumulative distribution function or the probability density
function of a beta distribution.
|
|
BETA.INV
|
Returns the inverse of the BETA.DIST function.
|
|
BINOM.DIST
|
Returns a probability for a binomial distribution.
|
|
BINOM.DIST.RANGE
|
Returns the probability for a binomial distribution over an interval.
|
|
BINOM.INV
|
Returns the smallest value for which the cumulative binomial
distribution is less than or equal to a criterion value.
|
|
CHISQ.DIST
|
Returns a value for a chi-squared distribution.
|
|
CHISQ.INV
|
Returns the inverse of the CHISQ.DIST function.
|
|
CONFIDENCE.NORM
|
Returns a confidence interval for a normal distribution.
|
|
CONFIDENCE.T
|
Returns a confidence interval for a Student's t-distribution.
|
|
CORREL
|
Returns the Pearson correlation coefficient of two sets of data.
|
|
COUNT
|
Returns the number of values which can be interpreted as numbers.
|
|
COUNTA
|
Returns the number of values which are not blank.
|
|
COUNTBLANK
|
Returns the number of elements of the given array which are either
blank or are equal to the empty text string.
|
|
COUNTIF
|
Returns the number of array elements which satisfy a condition.
|
|
COUNTIFS
|
Returns the number of array elements which satisfy one or several
conditions.
|
|
COVARIANCE.P
|
Returns the population covariance, that is, the covariance of the
product of paired deviations, for an entire population.
|
|
COVARIANCE.S
|
Returns the sample covariance, that is, the covariance of the product
of paired deviations, for a sample of the population.
|
|
DEVSQ
|
Returns the sum of squares of deviations from the mean.
|
|
EXPON.DIST
|
Returns a value for an exponential distribution.
|
|
FISHER
|
Returns a value for the Fisher transformation.
|
|
FISHERINV
|
Returns the inverse of the FISHER function.
|
|
FORECAST
|
Fits a straight line to data using linear regression and returns the
vertical coordinate of a point on that line.
|
|
FREQUENCY
|
Returns the frequency distribution of the values of the first array
when grouped into the intervals of the second array.
|
|
GAMMA
|
Returns the values of the Gamma function.
|
|
GAMMA.DIST
|
Returns a value for a Gamma distribution.
|
|
GAMMA.INV
|
Returns the inverse of the cumulative GAMMA.DIST function.
|
|
GAMMALN
|
Returns the natural logarithm of the gamma function.
|
|
GAMMALN.PRECISE
|
Returns the natural logarithm of the gamma function.
|
|
GAUSS
|
Returns a value in the standard normal cumulative distribution.
|
|
GEOMEAN
|
Returns the geometric mean of the parameters.
|
|
GROWTH
|
Returns the points of an exponential curve of the form y = b * m ^ x
through the given data points using linear regression.
|
|
HARMEAN
|
Returns the harmonic mean of the given values.
|
|
HYPGEOM.DIST
|
Returns a value for a hypergeometric distribution.
|
|
INTERCEPT
|
Fits a straight line to data using linear regression and returns its
intercept on the vertical axis.
|
|
KURT
|
Returns a measure of how peaked or flat a distribution is (the
kurtosis) based on the given parameters.
|
|
LARGE
|
Returns the nth largest number in the given array, where n is given as
the second parameter.
|
|
LINEST
|
Finds a straight line, y = m * x + b, that best fits the given data,
and returns an array containing two values corresponding to m and b in
the equation above.
|
|
LOGNORM.DIST
|
Returns a value for the cumulative distribution function of a lognormal
distribution.
|
|
LOGNORM.INV
|
Returns the inverse of the LOGNORM.DIST function.
|
|
MAX
|
Returns the largest number of the given numbers.
|
|
MAXA
|
Returns the largest number of the given numbers.
|
|
MAXIFS
|
Returns the largest number of all array elements which satisfy one or
several conditions.
|
|
MEDIAN
|
Returns the median of the given numbers.
|
|
MIN
|
Returns the smallest number of the given numbers.
|
|
MINA
|
Returns the smallest number of the given numbers.
|
|
MINIFS
|
Returns the smallest number of all array elements which satisfy one or
several conditions.
|
|
MODE.MULT
|
Returns the values that appear most frequently.
|
|
MODE.SNGL
|
Returns the value that appears most frequently.
|
|
NEGBINOM.DIST
|
Returns a probability for a negative binomial distribution.
|
|
NORM.DIST
|
Returns a value for a normal distribution.
|
|
NORM.INV
|
Returns the inverse of the cumulative NORM.DIST function.
|
|
NORM.S.DIST
|
Returns a value for the cumulative distribution function of a normal
distribution.
|
|
NORM.S.INV
|
Returns the inverse of the cumulative NORM.S.DIST function.
|
|
PEARSON
|
Returns the Pearson correlation coefficient of two sets of data.
|
|
PERCENTILE.EXC
|
Returns the number of the given array at the kth percentile, where k is
a number between 0 and 1 (exclusive), which can also be specified with
the % operator (.
|
|
PERCENTILE.INC
|
Returns the number of the given array at the kth percentile, where k is
a number between 0 and 1 (inclusive), which can also be specified with
the % operator (.
|
|
PERCENTRANK.EXC
|
Returns the percentile rank of a number in an array.
|
|
PERCENTRANK.INC
|
Returns the percentile rank of a number in an array.
|
|
PERMUT
|
Returns the number of permutations for a given number of objects, where
an object can only be chosen once.
|
|
PERMUTATIONA
|
Returns the number of permutations for a given number of objects, where
objects can be repeated.
|
|
PHI
|
Returns a value for a standard normal distribution.
|
|
POISSON.DIST
|
Returns a value for a Poisson distribution.
|
|
PROB
|
Returns the probability that a value is inside a given interval.
|
|
QUARTILE.EXC
|
Returns the number of the given array at the given quartile value.
|
|
QUARTILE.INC
|
Returns the number of the given array at the given quartile value.
|
|
RANK.AVG
|
Returns the rank of the given number in the given number array.
|
|
RANK.EQ
|
Returns the rank of the given number in the given number array.
|
|
RSQ
|
Returns the square of the Pearson correlation coefficient of two sets
of data.
|
|
SERIESSUM
|
Returns the sum of the first terms of a power series.
|
|
SKEW
|
Returns a measure of how skewed a distribution is, represented by the
given parameters.
|
|
SKEW.P
|
Returns a measure of how skewed a distribution is based on a
population.
|
|
SLOPE
|
Fits a straight line to data using linear regression and returns its
slope.
|
|
SMALL
|
Returns the nth smallest number in the given array, where n is given as
the second parameter.
|
|
STANDARDIZE
|
Converts a value in a normal distribution to its equivalent in a
standard normal distribution.
|
|
STDEV.P
|
Returns the population standard deviation of the parameters.
|
|
STDEV.S
|
Returns the sample standard deviation of the parameters.
|
|
STDEVA
|
Returns the sample standard deviation of the parameters.
|
|
STDEVPA
|
Returns the population standard deviation of the parameters.
|
|
STEYX
|
Fits a straight line to data using linear regression and returns the
standard error of the actual vertical coordinates compared to the
vertical coordinates of the straight line.
|
|
T.DIST
|
Returns a value for Student's left-tailed t-distribution.
|
|
T.INV
|
Returns the inverse of the left-tailed T.DIST function.
|
|
TRIMMEAN
|
Returns the mean (average) of the given values, ignoring a percentage
of array elements at the beginning and end of the given array.
|
|
VAR.P
|
Returns the population variance of the parameters.
|
|
VAR.S
|
Returns the sample variance of the parameters.
|
|
VARA
|
Returns the sample variance of the parameters.
|
|
VARPA
|
Returns the population variance of the parameters.
|
|
WEIBULL.DIST
|
Returns a value for a Weibull distribution.
|
|
Z.TEST
|
Returns the one-tailed cumulative probability value of a Z-test.
|