English

Statistical Functions

Below listed are the various statistical functions of Microsoft Excel 2007.

AVERAGE function is used to find the average of given set of numbers.

CORREL function is used to find the relationship between two set of values.

COUNT function finds and returns the count of number of numeric entries in a given list.

COUNTA function finds and returns the count of number of numeric entries, text, errors, etc in a given list.

COUNTBLANK function finds and returns the count of blank cells from the selection.

COUNTIF function is used to count the number of items based on the condition given.

FORECAST function is used predict a value based on the two sets of values.

FREQUENCY function compares a range of data against various intervals.

LARGE function is used to pick the largest value from the list of values.

MAX function returns the highest value from the given list.

MEDIAN function is used to find the median of the given set of numbers.

MIN function returns the lowest value from the given list.

MODE function is used to find the number/entry which has appeared frequently in a group.

PERMUT function is used to find the maximum number of permutations possible with the given items.

QUARTILE function returns the quartile values of the given set of entries.

RANK function returns the rank of a value against the other values in the given numbers.

SMALL function is used to pick the smallest value from the list of values.

STDEV function is used to calculate the Standard Deviation based on a sample.