Statistics
AVEDEV
Description: Returns average deviation.
Example:
AVEDEV(number1, number2, ...)
AVERAGE
Description: Returns the arithmetic mean.
Example:
AVERAGE(number1, number2, ...)
AVERAGEA
Description: Returns the arithmetic mean.
Example:
AVERAGEA(value1, value2,...)
AVERAGEIF
Description: Finds the average of the values in a given array that satisfy a given criteria, and returns the average value of the corresponding values in a second given array
Example:
AVERAGEIF(range, criteria, average_range)
AVERAGEIFS
Description: Finds the average of the values in a given array that satisfy a set of given criteria.
Example:
AVERAGEIFS(average_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...)
BINOMDIST
Description: Returns the cumulative beta probability density function.
Example:
BINOMDIST(number_s, trials, probability_s, cumulative)
CHIDIST
Description: Returns the chi-squared distribution.
Example:
CHIDIST(x, degrees_freedom)
CHIINV
Description: Returns the inverse of Chidist.
Example:
CHIINV(probability, degrees_freedom)
CHITEST
Description: Returns the test for independence. CHITEST returns the value from the chi-squared (c2) distribution for the statistic and the appropriate degrees of freedom.
Example:
CHITEST(actual_range, expected_range)
CONFIDENCE
Description: Returns the confidence interval.
Example:
CONFIDENCE(alpha, standard_dev,size)
CORREL
Description: Returns the correlation between two sets of data.
Example:
CORREL(array1, array2)
COUNT
Description: Returns the count of the data listed in the arguments.
Example:
COUNT(value1, value2,...)
COUNTA
Description: Returns the count of the data listed in the arguments.
Example:
COUNTA(value1, value2,...)
COUNTBLANK
Description: Returns the count of the empty cells listed in the arguments.
Example:
COUNTBLANK(range)
COUNTIF
Description: Returns the count of values that meet a specified criteria.
Example:
COUNTIF(range, criteria)
COVAR
Description: Returns covariance.
Example:
COVAR(array1, array2)
CRITBINOM
Description: Returns the critical value for the cumulative binomial distribution.
Example:
CRITBINOM(trials, probability_s, alpha)
DEVSQ
Description: Returns the sum of the squares of the mean deviation.
Example:
DEVSQ(number1, number2,...)
EXPONDIST
Description: Returns the exponential distribution.
Example:
EXPONDIST(x, lambda, cumulative)
FDIST
Description: Returns the F probability distribution.
Example:
FDIST(x, degrees_freedom1, degrees_freedom2)
Finv
Description: Returns the inverse of Fdist.
Example:
FINV(probability,deg_freedom1,deg_freedom2)
FISHER
Description: Returns the Fisher transformation.
Example:
FISHER(x)
FISHERINV
Description: Returns the inverse of Fisher.
Example:
FISHERINV(y)
FORECAST
Description: Returns the value forecasted by the linear trend.
Example:
FORECAST(x, known_ys, known_xs)
GAMMADIST
Description: Returns the gamma distribution.
Example:
GAMMADIST(x, alpha,beta, cumulative)
Gammainv
Description: Returns the inverse of Gammadist.
Example:
Gammainv(p, alpha, beta)
GAMMALN
Description: Returns the natural logarithm of gamma function.
Example:
GAMMALN(number)
GEOMEAN
Description: Returns the geometric mean.
Example:
GEOMEAN(number1, number2,...)
GROWTH
Description: This feature enables you to calculate predicted exponential growth using existing data. This calculates and returns an array of values used for the regression analysis.
Example:
GROWTH(known_y's, [known_x's], [new_x's],
HARMEAN
Description: Returns the harmonic mean.
Example:
HARMEAN(number1, number2,...)
HYPGEOM.DIST
Description: Returns the probability of a given number of sample successes, given the sample size, population successes and population size.
Example:
HYPGEOM.DIST(sample_s, number_sample, population_s, number_population, cumulative)
HYPGEOMDIST
Description: Returns the hypergeometric distribution.
Example:
HYPGEOMDIST(sample, numberofsample, population, numberofpopulation)
INTERCEPT
Description: Returns the Y intercept of the least squares fit line.
Example:
INTERCEPT(known_y's, known_x's)
KURT
Description: Returns the kurtosis of the set of arguments.
Example:
KURT(number1, number2, ...)
LARGE
Description: Returns the kth largest value.
Example:
LARGE(array, k)
LOGEST
Description: This feature enables you to calculate predicted exponential growth using existing data. This calculates and returns an array of values used for the regression analysis.
Example:
LOGEST(known_y's, [known_x's], [const], [stats])
LOGINV
Description: Returns the inverse of the Lognormdist.
Example:
LOGINV(probability, mean, standard_dev)
LOGNORMDIST
Description: Returns the cumulative lognormal distribution function.
Example:
LOGNORMDIST(x, mean, standard_dev)
MAX
Description: Returns the largest value among the arguments.
Example:
MAX(number1, number2, ...)
MAXA
Description: Returns the largest value among the arguments.
Example:
MAXA(value1, value2, ...)
MEDIAN
Description: Returns the median value among the arguments.
Example:
MEDIAN(number1, number2, ...)
MIN
Description: Returns the smallest value among the arguments.
Example:
MIN(number1, number2, ...)
MINA
Description: Returns the smallest value among the arguments.
Example:
MINA(value1, value2, ...)
MODE
Description: Returns the most frequently occurring value.
Example:
MODE(number1, number2, ...)
NEGBINOMDIST
Description: Returns the negative binomial distribution.
Example:
NEGBINOMDIST(number_f, number_s, probability_s)
NORMDIST
Description: Returns the normal cumulative distribution.
Example:
NORMDIST(x, mean, standard_dev, cumulative)
NORMINV
Description: Returns the inverse of Normdist.
Example:
NORMINV(probability, mean, standard_dev)
NormsDist
Description: Returns the probability that the observed value of a standard normal random variable will be less than or equal to the parameter.
Example:
NormsDist(value)
NormsInv
Description: Returns the standard normal random variable that has Mean 0 and Standard Deviation 1
Example:
NormsDist(value)
PEARSON
Description: Returns the Pearson product.
Example:
PEARSON(array1, array2)
PERCENTILE
Description: Returns the kth percentile of the given values.
Example:
PERCENTILE(array, k)
PERCENTRANK
Description: Returns the position of a value in the range of values.
Example:
PERCENTRANK(array, x, significance)
Permut
Description: Returns the number of permutations.
Example:
Permut(n, k)
POISSON
Description: Returns the Poisson distribution.
Example:
POISSON(x, mean, cumulative)
PROB
Description: Returns a probability.
Example:
PROB(x_range, prob_range, lower_limit, upper_limit)
QUARTILE
Description: Returns which quarter a value belongs to within an ordered set of data.
Example:
QUARTILE(array, quart)
RANK
Description: Returns the position of a value in an ordered list.
Example:
RANK(number, ref, order)
RSQ
Description: Returns the square of the Pearson product moment correlation coefficients.
Example:
RSQ(known_y's, known_x's)
SKEW
Description: Returns the skewness of a distribution.
Example:
SKEW(number1, number2, ...)
SLOPE
Description: Returns the slope of the linear regression line.
Example:
SLOPE(known_y's, known_x's)
SMALL
Description: Returns the kth smallest value.
Example:
SMALL(array, k)
STANDARDIZE
Description: Returns the normalized value.
Example:
STANDARDIZE(x, mean, standard_dev)
STDEV
Description: Returns the sample standard deviation.
Example:
STDEV(number1, number2, ...)
STDEVA
Description: Returns the sample standard deviation.
Example:
STDEVA(value1, value2 , ...)
STDEVP
Description: Returns the population standard deviation.
Example:
STDEVP(number1, number2, ...)
STDEVPA
Description: Returns the population standard deviation.
Example:
STDEVPA(value1, value2, ...)
STEYX
Description: Returns the standard error.
Example:
STEYX(known_y's, known_x's)
TRIMMEAN
Description: Returns the mean after removing out-liers.
Example:
TRIMMEAN(array, percent)
Var
Description: Returns the sample variance.
Example:
Var(number1, number2, ... number_n)
VarA
Description: Returns the sample variance.
Example:
VarA(value1, value2, ... value_n)
VarP
Description: Returns the population variance.
Example:
VarP(listofvalues)
VARPA
Description: Returns the population variance.
Example:
VARPA(value1, value2, ...)
Weibull
Description: Returns the Weibull distribution.
Example:
WEIBULL(x,alpha,beta,cumulative)
ZTEST
Description: Returns the P-value of a z-test.
Example:
ZTEST(array, u0, sigma)