STATISTICAL FUNCTIONS

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