Excel Statistical Functions

Statistical Functions
Statistical
Functions
Description
Count Functions
COUNT Counts the number of cells in a range that contain numbers
COUNTBLANK Counts only those cells in a range that are empty
COUNTA Counts the Number of Nonblank cells
COUNTIF Returns a Number Rounded away from Zero to the Nearest Multiple of significance
COUNTIFS Rounds a number down toward zero to the nearest multiple of significance
Frequency and Rank Functions
FREQUENCY Number of times values appear within a range of values
RANK.EQ Returns the rank of a number in a list of numbers
RANK.AVG Returns the rank of a number in a list of numbers.  If more than one value has the same rank, the average rank is returned.
PERCENTRANK.INC Returns the rank of a value in a data set as a percentage (0 to 100 inclusive) of the data set
PERCENTRANK.EXC Returns the rank of a value in a data set as a percentage (0 to 100 exclusive) of the data set
PERCENTILE.INC Given an array of values, it returns the value that is at the percentile you specify.  Can find values anywhere from the 0 percentile to the 100-percentile inclusive.
PERCENTILE.EXC Given an array of values, it returns the value that is at the percentile you specify.  Can find values anywhere from the 0 percentile to the 100-percentile exclusive.
Measures of Central Tendency
AVERAGE Returns the Average of its arguments from only those cells that contain numeric data
AVERAGEA Returns the Average of its arguments. It includes Numeric and Nonnumeric cells. It does not include Blanks.
AVERAGEIF Averages values that meet a single criterion
AVERAGEIFS Averages values that meet multiple criteria

MEDIAN The median is the the middle number of a group of numbers; half the numbers have values greater than the median, and half the numbers have values less than the median
MODE.SNGL  Finds the Mode which is the most frequently occuring number in a set of numbers
MODE.MULT Returns a vertical array of the most frequently occuring, or repetivitive values in an array or range of data.
Size Functions
MIN Returns the smallest value from a set of values
MAX Returns the largest value from a set of values
LARGE Returns the nth largest value from a set of values
SMALL Returns the nth smallest value from a set of values
Variance Functions
VAR.S Estimates variance based on a sample of the entire population
VAR.P Calculates variance based on the entire population
Standard Deviation Functions
STDEV.S Standard deviation based on a sample of the entire population
STDEV.P Standard deviation based on the entire population
Trend Line Functions
SLOPE Measures the rate of Change in a line
INTERCEPT The Point where a lince crosses the Y-axis
TREND Use this function when you have a series of known X and Y coordinates and you want to follow the pattern of that line to new X-coordinates that you specify. Excel will return the y_coordinates for the new X-coordinates
FORECAST Predicts a future value based on existing values