Below is the list of 19 useful statistical functions, please see below for details or check all Excel functions here:
| Function | Formula |
|---|---|
| Average Function | Average(Num1, Num2, …) |
| Averagea Function | Averagea(Num1, Num2, …) |
| Averageif Function | Averageif(Range, Criteria, [Range]) |
| Averageifs Function | Averageifs(Range, Range1, Criteria1, [Range2, Criteria2], …) |
| Concatenate Function | Concatenate (Cell 1, Cell 2…) |
| Count Function | Count(Value1, [Value2], …) |
| Counta Function | Counta(Value1, [Value2], …) |
| Countblank Function | Countblank(Range) |
| Count Cells that Contain a Value | Countif(Range, Criteria) |
| Countifs Function | Countifs(Range 1, Criteria 1, Range 2, Criteria 2…) |
| Frequency Function | Frequency(Data_Array, Bins_Array) |
| Large Function | Large(Array, K) |
| Max Function | Max(Num1, [Num2], …) |
| Maxa Function | Maxa(Num1, [Num2], …) |
| Median Function | Median(Num1, [Num2], …) |
| Min Function | Min(Num1, [Num2], …) |
| Mina Function | Mina(Num1, [Num2], …) |
| Rank.Avg Function | Rank.Avg(Num, Ref, [Order]) |
| Small Function | Small(Array, K) |