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