| AVEDEV |
Retuns the average of the absolute deviations of data points from their mean. |
| AVERAGE |
Returns the average of its arguments. |
| AVERAGEA |
Returns the average of the values in its list of arguments including text and logical values.Returns the average of the values in its list of arguments including 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 (X^2) distribution; the area in the right tail under the chi-squared distribution curve. |
| CHIINV |
Returns the inverse of the one-tailed probability of the chi-squared (X^2) distribution. |
| CHITEST |
Returns the test for independence of the characteristics in a table. |
| CONFIDENCE |
Returns the confidence interval for a population mean. |
| CORREL |
Returns the correlation coefficient between two data sets. |
| COUNT |
Counts the number of cells that contain numbers (including dates and formulas that evaluate to numbers) within the list of arguments. |
| COUNTA |
Counts the number of cells that are not empty. |
| COUNTBLANK |
Counts the empty cells in a specified range. |
| COUNTIF |
Counts the number of cells in a range that meet a given criteria. |
| COVAR |
Returns the covariance, the average of products of deviations, for each data point pair. |
| CRITBINOM |
Returns the minimum number yields a binomial distribution less than or equal to the specified criteria |
| DEVSQ |
Returns the sum of the squares of deviations of a data set from their sample mean. |
| 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 at x. |
| FISHERINV |
Returns the inverse of the Fisher transformation at y. |
| FORECAST |
Calculates or predicts a future value by using existing values. |
| FREQUENCY |
Calculates how often values occur within a range of values and then returns a vertical array of numbers. |
| 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. |
| GEOMEAN |
Returns the geometric mean of an array or range of positive data. |
| GROWTH |
Calculates predicted exponential growth by using existing data. |
| HARMEAN |
Returns the harmonic mean of a data set. |
| HYPGEOMDIST |
Returns the hypergeometric distribution. |
| INTERCEPT |
Calculates the point at which a line will intersect the y-axis by using existing x and y values. |
| KURT |
Returns the Kurtosis of a data set. |
| LARGE |
Returns the k-th largest value in a data set. |
| LINEST |
Calculates a straight line that best fits your data using the least squares method. |
| LOGEST |
Calculates an exponential curve that fits your data and returns an array of values that describes the curve. |
| LOGINV |
Returns the inverse of the lognormal cumulative distribution function of x, where in x is normally distributed with parameters mean and standard deviation. |
| LOGNORMDIST |
Returns the cumulative lognormal distribution of x, where in x is normally distributed with parameters mean and standard deviation. |
| MAX |
Returns the largest value in a set of values. |
| MAXA |
Returns the largest value in a set of values including text and logical values. |
| MEDIAN |
Returns the median of the given numbers. |
| MIN |
Returns the smallest value in a set of values. |
| MINA |
Returns the smallest value in a set of values including text and logical values. |
| MODE |
Returns the most frequently occuring, or repetitive, number in an array or range of data. |
| NEGBINOMDIST |
Returns the negative binomial distribution. |
| NORMDIST |
Returns the normal cumulative distribution for the specified mean and standard deviation. |
| NORMINV |
Returns the inverse of the normal cumulative distribution for the specified mean and standard deviation. |
| NORMSDIST |
Returns the standard normal cumulative distribution function. |
| NORMSINV |
Returns the inverse of the standard normal cumulative distribution function. |
| PEARSON |
Returns the Pearson product moment correlation coefficient, r, a dimensionless index that ranges from -1.0 to 1.0 inclusive and reflects the extent of a linear relationship between two data sets. |
| PERCENTILE |
Returns the k-th percentile of values in a range. |
| PERCENTRANK |
Returns the rank of a value in a data set set as a percentage of the data set. |
| PERMUT |
Returns the number of permutations for a given number of objects that can be selected from a range of numbers. |
| POISSON |
Returns the Poisson distribution. |
| PROB |
Returns the probability that values in a range are between two specified limits. |
| QUARTILE |
Returns the quartile of a data set. |
| RANK |
Returns the rank of a number in a list of numbers. |
| RSQ |
Returns the r^2 value of a linear regression line. |
| SKEW |
Returns the skew of a distribution. |
| SLOPE |
Returns the slope of a regression line through data points in KNOWN*Y’S and KNOWN_X’S. |
| SMALL |
Returns the k-th smallest value in a data set. |
| STANDARDIZE |
Returns a normalized value from a distribution characterized by MEAN and STANDARD* DEV. |
| STDEV |
Estimates standard deviation based on a sample. |
| STDEVA |
Estimates standard deviation based on a sample. Includes text and logical values. |
| STDEVP |
Estimates standard deviation based on a sample assuming that the arguments represent the total population. |
| STDEVPA |
Estimates standard deviation based on a sample assuming that the arguments represent the total population. Includes text and logical values. |
| STEYX |
Returns the standard error of the predicted y value for each x in the regression. |
| TDIST |
Returns the percentage points (probability) for the student t-distribution, where a numeric value x is a calculated value of t for which the percentage points are to be computed. |
| TINV |
Returns the t-value of the Student’s t-distribution as a function of the probability and the degrees of freedom. |
| TREND |
Returns the y-values along a linear trendline that best fits the values in a data set. |
| TRIMMEAN |
Returns the mean of the interior of a data set. |
| TTEST |
The probability associated with t-test. |
| VAR |
Returns an estimate for the variance of a population based on a sample data set. |
| VARA |
Returns an estimate for the variance of a population based on a sample data set and may include text or logical values. |
| VARP |
Calculates variance based on the entire population. |
| VARPA |
Calculates variance based on the entire population and may include text or logical values. |
| WEIBULL |
Returns the Weibull distribution. |
| ZTEST |
Returns the two-tailed P-value of a z-test. |