MIN function

Category: Statistical functions

What does this function do?

Returns the minimum value in a list of values. Ignores logical values and text.

Syntax:

MIN(number1,number2,...)

• number1 (required): The first of the values or ranges to evaluate.
• number2 (optional): From the second number or range parameters are optional.

Examples:

=MIN(1, 2, 3) = 1
=MIN(A1:A2,B1:B2) = 1, if A1:A2= {1,2} and B1:B2= {2,3}

MAX function

Category: Statistical functions

What does this function do?

Returns the maximum value in a list of values. Ignores logical values and text.

Syntax:

MAX(number1,number2,...)

• number1 (required): The first of the values or ranges to evaluate.
• number2 (optional): From the second number or range parameters are optional.

Examples:

=MAX(1, 2, 3) = 3
=MAX(A1:A2,B1:B2) = 3, if A1:A2= {1,2} and B1:B2= {2,3}

Statistical Functions

The Statistical Functions are used in Excel to perform statistical operations. Take a look at some of the most common functions.

AVERAGE - Returns the average (arithmetic mean) of the arguments, which can be numbers, names, arrays, or references that contain numbers.

COUNT - Count the number of cells in a range that contain numbers.

COUNTA - Count the number of cells in a range that are not empty.

COUNTBLANK - Count the number of cells in a range that are empty.

COUNTIF - Count the cells in a range that meet a specified condition.

COUNTIFS- Count the cells in a range that meet one or more specified conditions.

FREQUENCY - Calculate the frequency of occurrence of a value within a range of values and returns a vertical array of numbers.

LARGE - Returns the largest k-th value of a data set.

MAX - Returns the maximum value in a list of values. Ignores logical values and text.

MEDIAN - Returns the median of a data set.

MIN - Returns the minimum value in a list of values. Ignores logical values and text.

MODE.SNGL - Returns the most frequent or repetitive value of an array or range of data.

RANK.EQ - Returns the rank of a number in a list of numbers: its size relative to other values in the list; if more than one value has the same hierarchy, the top hierarchy of the set of values is returned.

SMALL - Returns the smallest k-th value of a data set.

FREQUENCY function

Category: Statistical functions

What does this function do?

Count the cells in a range that meet one or more specified conditions.

Syntax:

FREQUENCY(data_array, bins_array)

• data_array (required):An array of or reference to a set of values for which you want to count frequencies. If data_array contains no values, FREQUENCY returns an array of zeros.

• bins_array (required): An array of or reference to intervals into which you want to group the values in data_array. If bins_array contains no values, FREQUENCY returns the number of elements in data_array.

Examples:

=FREQUENCY(A1:A6,B1:B3) = {0, 1, 2, 3}, if A1:A6 = {11; 20; 21; 30; 29; 29} and B1:B3 = {10; 17; 23}. This means that the number of values equal to 10 or less is 0, the number of values in the interval 11 to 17 is 1, the number of values in the interval 18 to 23 is 2 and the number of values greater than 23 are 3.

COUNTIFS function

Category: Statistical functions

What does this function do?

Count the cells in a range that meet one or more specified conditions.

Syntax:

COUNTIFS(criteria_range1, criteria1, [criteria_range2, criteria2]…)

• criteria_range1 (required): The first range in which to evaluate the associated criteria.

• criteria1 (required): The criteria in the form of a number, expression, cell reference, or text that define which cells will be counted. For example, criteria can be expressed as 32, ">32", B4, "apples", or "32".

• criteria_range2, criteria2, ...(optional): Additional ranges and their associated criteria. Up to 127 range/criteria pairs are allowed.

Examples:

=COUNTIFS(A1:A3, “>1″) = 2 if A1:A3={1,2,3}
=COUNTIFS(B1:B5,1,A1:A5,”>1″) = 1 if B1:B5 ={1;0;0;1;1} and A1:A5 ={0;2;3;4;4}