| Functions |
What it Does |
|
AVERAGE |
Returns the average of its
arguments |
| COUNT |
Counts how many numbers are in
the list of arguments |
|
AVERAGEA |
Returns the average of its
arguments, including numbers, text, and logical values |
|
COUNTA |
Counts how many values are in
the list of arguments) |
| RANK |
Returns the rank of a number in
a list of numbers |
| LARGE |
Returns the k-th largest value
in a data set |
| SMALL |
Returns the k-th smallest
value in a data set |
| COUNTBLANK |
Counts the number of blank cells
within a range |
| COUNTIF |
Counts the number of nonblank
cells within a range that meet the given criteria (SUMPRODUCT does better) |
| AVEDEV |
Returns the average of the
absolute deviations of data points from their mean |
| BETADIST |
Returns the cumulative beta
probability density function |
| BETAINV |
Returns the inverse of the
cumulative beta probability density function |
| BINOMDIST |
Returns the individual term
binomial distribution probability |
| CHIDIST |
Returns the one-tailed
probability of the chi-squared distribution |
| CHIINV |
Returns the inverse of the
one-tailed probability of the chi-squared distribution |
| CHITEST |
Returns the test for
independence |
| CONFIDENCE |
Returns the confidence interval
for a population mean |
| CORREL |
Returns the correlation
coefficient between two data sets |
| COVAR |
Returns covariance, the average
of the products of paired deviations |
| CRITBINOM |
Returns
the smallest value for which the cumulative binomial distribution is less
than or equal to a criterion value |
| DEVSQ |
Returns the sum of squares of
deviations |
| EXPONDIST |
Returns the exponential
distribution |
| FDIST |
Returns the F probability
distribution |
| FINV |
Returns the inverse of the F
probability distribution |
| FISHER |
Returns the Fisher
transformation |
| FISHERINV |
Returns the inverse of the
Fisher transformation |
| FORECAST |
Returns a value along a linear
trend |
| FREQUENCY |
Returns a frequency distribution
as a vertical array |
| FTEST |
Returns the result of an F-test |
| GAMMADIST |
Returns
the gamma distribution |
| GAMMAINV |
Returns the inverse of the gamma
cumulative distribution |
| GAMMALN |
Returns the natural logarithm of
the gamma function, Γ (x) |
| GEOMEAN |
Returns the geometric mean |
| GROWTH |
Returns values along an
exponential trend |
| HARMEAN |
Returns the harmonic mean |
| HYPGEOMDIST |
Returns
the hypergeometric distribution |
| INTERCEPT |
Returns the intercept of the
linear regression line |
| KURT |
Returns the kurtosis of a data
set |
| LINEST |
Returns the parameters of a
linear trend |
| LOGEST |
Returns the parameters of an
exponential trend |
| LOGINV |
Returns the inverse of the
lognormal distribution |
| LOGNORMDIST |
Returns the cumulative lognormal
distribution |
| MAX |
Returns the maximum value of a range |
| MAXA |
Returns the maximum numerical value of a range that includes numerical and alphabetical values |
| MEDIAN |
Returns the median of the given
numbers |
| MIN |
Returns the minimum value of a range |
| MINA |
Returns the minimum numerical value of a range that includes numerical and alphabetical values |
| MODE |
Returns the most common value in
a data set |
| NEGBINOMDIST |
Returns
the negative binomial distribution |
| NORMDIST |
Returns the normal cumulative
distribution |
| NORMINV |
Returns the inverse of the
normal cumulative distribution |
| NORMSDIST |
Returns the standard normal
cumulative distribution |
| NORMSINV |
Returns the inverse of the
standard normal cumulative distribution |
| PEARSON |
Returns the Pearson product
moment correlation coefficient |
| PERCENTILE |
Returns the k-th percentile of
values in a range |
| PERCENTRANK |
Returns the percentage rank of a
value in a data set |
| PERMUT |
Returns the number of
permutations for a given number of objects |
| POISSON |
Returns the Poisson distribution |
| PROB |
Returns the probability that
values in a range are between two limits |
| QUARTILE |
Returns the quartile of a data
set |
| RSQ |
Returns the square of the
Pearson product moment correlation coefficient |
| SKEW |
Returns the skewness of a
distribution |
| SLOPE |
Returns the slope of the
linear regression line |
| SMALL |
Returns the k-th smallest
value in a data set |
| STANDARDIZE |
Returns a normalized value |
| STDEV |
Estimates standard
deviation based on a sample |
| STDEVA |
Estimates standard deviation
based on a sample, including numbers, text, and logical values |
| STDEVP |
Calculates standard deviation
based on the entire population |
| STDEVPA |
Calculates standard deviation
based on the entire population, including numbers, text, and logical values |
| STEYX |
Returns the standard error of
the predicted y-value for each x in the regression |
| TDIST |
Returns the Student's
t-distribution |
| TINV |
Returns the inverse of the
Student's t-distribution |
| TREND |
Returns values along a linear
trend |
| TRIMMEAN |
Returns the mean of the interior
of a data set |
| TTEST |
Returns the probability
associated with a Student's t-test |
| VAR |
Estimates variance based on a
sample |
| VARA |
Estimates variance based on a
sample, including numbers, text, and logical values |
| VARP |
Calculates variance based on the
entire population |
| VARPA |
Calculates variance based on the
entire population, including numbers, text, and logical values |
| WEIBULL |
Returns the Weibull distribution |
| ZTEST |
Returns the two-tailed P-value
of a z-test |
| New Functions in Excel 2007 |
| AVERAGEIF |
Calculates the average within a range that meet a given criteria (SUMPRODUCT does better) |
| AVERAGEIFS |
Calculates the average within a range that meet one or many given criteria (SUMPRODUCT does better) |
| COUNTIFS |
Counts the number of nonblank
cells within a range that meet the given criteria (SUMPRODUCT does better) |
Back home