| 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 |