Excel Statistical Analysis Functions

Excel shines at statistical analysis. It has a range of functions you can use to determine tendency and variability, comparatives, and correlations among other things. The following tables show which function to use to calculate a desired value and insert it into a call in an Excel worksheet.

Excel Central Tendency and Variability Functions

Function	What It Calculates	Function	What It Calculates
AVERAGE	Mean of a set of numbers	MEDIAN	Median of a set of numbers
AVERAGEIF	Mean of a set of numbers that meet a condition	VARP	Variance of a set of numbers considered to be a population
AVERAGEIFS	Mean of a set of numbers that meet one or more conditions	VAR	Variance of a set of numbers considered to be a sample
HARMEAN	Harmonic mean of a set of positive numbers	STDEVP	Standard deviation of a set of numbers considered to be a population
GEOMEAN	Geometric mean of a set of positive numbers	STDEV	Standard deviation of a set of numbers considered to be a sample
MODE	Mode of a set of numbers	STANDARDIZE	A standard score based on a given mean and standard deviation

Excel Relative Standing Functions

Function	What It Calculates
RANK	Rank of a number in a set of numbers
PERCENTRANK	Rank of a number expressed as a percent
PERCENTILE	The indicated percentile in a set of numbers
QUARTILE	The 1st, 2nd, 3rd, or 4th quartile of a set of numbers

Excel Correlation and Regression Functions

Function	What it Calculates
CORREL	Correlation coefficient between two sets of numbers
PEARSON	Same as CORREL. (Go figure!)
RSQ	Coefficient of determination between two sets of numbers (square of the correlation coefficient)
SLOPE	Slope of a regression line through two sets of numbers
INTERCEPT	Intercept of a regression line through two sets of numbers
STEYX	Standard error of estimate for a regression line through two sets of numbers

dummies

Source:http://www.dummies.com/how-to/content/excel-statistical-analysis-functions.html