English

# Statistical Functions

Below listed are the various statistical functions of Microsoft Excel 2007. Average():

AVERAGE function is used to find the average of given set of numbers. Correl():

CORREL function is used to find the relationship between two set of values. Count():

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

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

COUNTBLANK function finds and returns the count of blank cells from the selection. Countif():

COUNTIF function is used to count the number of items based on the condition given. Forecast():

FORECAST function is used predict a value based on the two sets of values. Frequency():

FREQUENCY function compares a range of data against various intervals. Large():

LARGE function is used to pick the largest value from the list of values. Max():

MAX function returns the highest value from the given list. Median():

MEDIAN function is used to find the median of the given set of numbers. Min():

MIN function returns the lowest value from the given list. Mode():

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

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

QUARTILE function returns the quartile values of the given set of entries. Rank():

RANK function returns the rank of a value against the other values in the given numbers. Small():

SMALL function is used to pick the smallest value from the list of values. Stdev():

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