|
AVEDEV |
Returns the average of the absolute deviations of data points from their mean |
|
AVERAGE |
Returns the average of its arguments |
|
AVERAGEA |
Returns the average of its arguments, including numbers, text, and logical values |
|
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 |
|
COUNT |
Counts how many numbers are in the list of arguments |
|
COUNTA |
Counts how many values are in the list of arguments |
|
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, G(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 |
|
LARGE |
Returns the k-th largest value in 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 in a list of arguments |
|
MAXA |
Returns the maximum value in a list of arguments, including numbers, text, and logical values |
|
MEDIAN |
Returns the median of the given numbers |
|
MIN |
Returns the minimum value in a list of arguments |
|
MINA |
Returns the smallest value in a list of arguments, including numbers, text, and logical 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 |
|
RANK |
Returns the rank of a number in a list of numbers |
|
RSQ |
Returns the square of the Pearson product moment correlatin 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 |