Contents

Know more about this
(or any other) subject?

Show off your know-how at Quamut Wiki.

Learn more with these titles from Barnes & Noble

Learn Excel 2007 from Mr. Excel

Microsoft Office Excel 2007 Step by Step

Beginning Pivot Tables in Excel 2007: From Novice to Professional

Microsoft Office Excel 2007 QuickSteps

2007 Microsoft Office System Inside Out

Previous:
Math and Trigonometry Functions

Next:
Lookup and Reference Functions

Statistical Functions

Function	Description	Syntax
AVEDEV	Returns the average of the absolute deviations of data points from their mean	(number1,number2,...)
AVERAGE	Returns the average of its arguments	(number1,number2,...)
AVERAGEA	Returns the average of its arguments, including numbers, text, and logical values	(value1,value2,...)
AVERAGEIF	Returns the average (arithmetic mean) of all the cells in a range that meet a given criteria	(range,criteria,average_range)
AVERAGEIFS	Returns the average (arithmetic mean) of all cells that meet multiple criteria	(average_range, criteria_range1,criteria1, criteria_range2,criteria2...)
BETADIST	Returns the beta cumulative distribution function	(x,alpha,beta,A,B)
BETAINV	Returns the inverse of the cumulative distribution function for a specified beta distribution	(probability,alpha,beta,A,B)
BINOMDIST	Returns the individual term binomial distribution probability	(number_s,trials, probability_s,cumulative)
CHIDIST	Returns the one-tailed probability of the chi-squared distribution	(x,degrees_freedom)
CHIINV	Returns the inverse of the one-tailed probability of the chi-squared distribution	(probability,degrees_freedom)
CHITEST	Returns the test for independence	(actual_range, expected_range)
CONFIDENCE	Returns the confidence interval for a population mean	(alpha,standard_dev,size)
CORREL	Returns the correlation coefficient between two data sets	(array1,array2)
COUNT	Counts how many numbers are in the list of arguments	(value1,value2,...)
COUNTA	Counts how many values are in the list of arguments	(value1,value2,...)
COUNTBLANK	Counts the number of blank cells within a range	(range)
COUNTIF	Counts the number of cells within a range that meet the given criteria	(range,criteria)
COUNTIFS	Counts the number of cells within a range that meet multiple criteria	(range1, criteria1,range2, criteria2...)
COVAR	Returns covariance, the average of the products of paired deviations	(array1,array2)
CRITBINOM	Returns the smallest value for which the cumulative binomial distribution is less than or equal to a criterion value	(trials,probability_s,alpha)
DEVSQ	Returns the sum of squares of deviations	(number1,number2,...)
EXPONDIST	Returns the exponential distribution	(x,lambda,cumulative)
FDIST	Returns the F probability distribution	(x,degrees_freedom1, degrees_freedom2)
FINV	Returns the inverse of the F probability distribution	(probability, degrees_freedom1, degrees_freedom2)
FISHER	Returns the Fisher transformation	(x)
FISHERINV	Returns the inverse of the Fisher transformation	(y)
FORECAST	Returns a value along a linear trend	(x,known_y’s,known_x’s)
FREQUENCY	Returns a frequency distribution as a vertical array	(data_array,bins_array)
FTEST	Returns the result of an F-test	(array1,array2)
GAMMADIST	Returns the gamma distribution	(x,alpha,beta,cumulative)
GAMMAINV	Returns the inverse of the gamma cumulative distribution	(probability,alpha,beta)
GAMMALN	Returns the natural logarithm of the gamma function, (x)	(x)
GEOMEAN	Returns the geometric mean	(number1,number2,...)
GROWTH	Returns values along an exponential trend	(known_y’s,known_x’s, new_x’s,const)
HARMEAN	Returns the harmonic mean	(number1,number2,...)
HYPGEOMDIST	Returns the hypergeometric distribution	(sample_s,number_sample, population_s, number_population)
INTERCEPT	Returns the intercept of the linear regression line	(known_y’s,known_x’s)
KURT	Returns the kurtosis of a data set	(number1,number2,...)
LARGE	Returns the kth largest value in a data set	(array,k)
LINEST	Returns the parameters of a linear trend	(known_y’s,known_x’s,const, stats)
LOGEST	Returns the parameters of an exponential trend	(known_y’s,known_x’s,const, stats)
LOGINV	Returns the inverse of the lognormal distribution	(probability,mean, standard_dev)
LOGNORMDIST	Returns the cumulative lognormal distribution	(x,mean,standard_dev)
MAX	Returns the maximum value in a list of arguments	(number1,number2,...)
MAXA	Returns the maximum value in a list of arguments, including numbers, text, and logical values	(value1,value2,...)
MEDIAN	Returns the median of the given numbers	(number1,number2,...)
MIN	Returns the minimum value in a list of arguments	(number1,number2,...)
MINA	Returns the smallest value in a list of arguments, including numbers, text, and logical values	(value1,value2,...)
MODE	Returns the most common value in a data set	(number1,number2,...)
NEGBINOMDIST	Returns the negative binomial distribution	(number_f,number_s, probability_s)
NORMDIST	Returns the normal cumulative distribution	(x,mean,standard_dev, cumulative)
NORMINV	Returns the inverse of the normal cumulative distribution	(probability,mean, standard_dev)
NORMSDIST	Returns the standard normal cumulative distribution	(z)
NORMSINV	Returns the inverse of the standard normal cumulative distribution	(probability)
PEARSON	Returns the Pearson product moment correlation coefficient	(array1,array2)
PERCENTILE	Returns the kth percentile of values in a range	(array,k)
PERCENTRANK	Returns the percentage rank of a value in a data set	(array,x,significance)
PERMUT	Returns the number of permutations for a number of objects	(number,number_chosen)
POISSON	Returns the Poisson distribution	(x,mean,cumulative)
PROB	Returns the probability that values in a range are between two limits	(x_range,prob_range, lower_limit,upper_limit)
QUARTILE	Returns the quartile of data set	(array,quart)
RANK	Returns the rank of a number in a list of numbers	(number,ref,order)
RSQ	Returns the square of the Pearson product moment correlation coefficient	(known_y’s,known_x’s)
SKEW	Returns the skewness of a distribution	(number1,number2,...)
SLOPE	Returns the slope of the linear regression line	(known_y’s,known_x’s)
SMALL	Returns the kth smallest value in a data set	(array,k)
STANDARDIZE	Returns a normalized value	(x,mean,standard_dev)
STDEV	Estimates standard deviation based on a sample	(number1,number2,...)
STDEVA	Estimates standard deviation based on a sample, including numbers, text, and logical values	(value1,value2,...)
STDEVP	Calculates standard deviation based on the entire population	(number1,number2,...)
STDEVPA	Calculates standard deviation based on the entire population, including numbers, text, and logical values	(value1,value2,...)
STEYX	Returns the standard error of the predicted y-value for each x in the regression	(known_y’s,known_x’s)
TDIST	Returns Student t-distribution	(x,degrees_freedom,tails)
TINV	Returns the inverse of the Student t-distribution	(probability,degrees_freedom)
TREND	Returns values along a linear trend	(known_y’s,known_x’s, new_x’s,const)
TRIMMEAN	Returns the mean of the interior of a data set	(array,percent)
TTEST	Returns the probability associated with a Student t-test	(array1,array2,tails,type)
VAR	Estimates variance based on a sample	(number1,number2,...)
VARA	Estimates variance based on a sample, including numbers, text, and logical values	(value1,value2,...)
VARP	Calculates variance based on the entire population	(number1,number2,...)
VARPA	Calculates variance based on the entire population, including numbers, text, and logical values	(value1,value2,...)
WEIBULL	Returns the Weibull distribution	(x,alpha,beta,cumulative)
ZTEST	Returns the one-tailed probability-value of a z-test	(array,μ0,sigma)

Acknowledgments & Disclaimer

Previous:
Math and Trigonometry Functions

Next:
Lookup and Reference Functions

Download the PDF
for just $2.95

Excel 2007: Functions

► Complete guide
► Handy, portable format