This section provides an overview of some of Excel’s most useful statistical functions.
AVERAGE
Function AVERAGE (AVERAGE) is used to calculate the arithmetic average. Arguments can be given, for example, as a reference to a range of cells.
HEARTLESS
To calculate the arithmetic mean of cells that meet a given criterion, use the function HEARTLESS (AVERAGEIF). Here is how, for example, you can calculate the arithmetic mean of all cells in a range A1:O1, whose value is not equal to zero (<>0).
Note: Sign <> means NOT EQUAL. Function HEARTLESS very similar to function SUMMESLI.
MEDIAN
Using functions MEDIAN (MEDIAN) you can define the median (middle) of a set of numbers.
Check:
FASHION
Function FASHION (MODE) finds the most frequently occurring number in a set of numbers.
Standard deviation
To calculate the standard deviation, use the function STDEV (STDEV).
MIN
Using functions MIN (MIN) you can find the minimum value from a set of numbers.
MAX
Using functions MAX (MAX) you can find the maximum value from a set of numbers.
LARGE
Here’s how using the function LARGE (LARGE) you can find the third largest value from a set of numbers.
Check:
LEAST
Here’s how to find the second smallest value using the function LEAST (SMALL).
Check:
