Excel Functions
Central Tendency
| AVERAGE | Mean - Returns the arithmetic mean of the values in a list, range or array. |
| MEDIAN | Median - Returns the median value in a list or array of numbers. |
| QUARTILE.EXC | Median - Returns the quartile of a data set (exclusive). |
| QUARTILE.INC | Median - Returns the quartile of a data set (inclusive). |
| MODE | Mode - Returns the value that occurs most frequently in a list or array of numbers. |
| SUM | Weighted Average - Returns the total of the values in a list, range or array. |
| SUMPRODUCT | Weighted Average - Returns the sum of the product of one or more arrays of values. |
| MAX | Mid Range - Returns the largest value in a list, range or array. |
| MIN | Mid Range - Returns the smallest value in a list, range or array. |
| GEOMEAN | Geometric Mean - Returns the geometric mean of an array of numbers. |
| HARMEAN | Harmonic Mean - Returns the harmonic mean of a data set. |
| AVERAGE Mean - Returns the arithmetic mean of the values in a list, range or array. |
| MEDIAN Median - Returns the median value in a list or array of numbers. |
| QUARTILE.EXC Median - Returns the quartile of a data set (exclusive). |
| QUARTILE.INC Median - Returns the quartile of a data set (inclusive). |
| MODE Mode - Returns the value that occurs most frequently in a list or array of numbers. |
| SUM Weighted Average - Returns the total of the values in a list, range or array. |
| SUMPRODUCT Weighted Average - Returns the sum of the product of one or more arrays of values. |
| MAX Mid Range - Returns the largest value in a list, range or array. |
| MIN Mid Range - Returns the smallest value in a list, range or array. |
| GEOMEAN Geometric Mean - Returns the geometric mean of an array of numbers. |
| HARMEAN Harmonic Mean - Returns the harmonic mean of a data set. |
Dispersion
| MAX | Range - Returns the largest value in a list, range or array. |
| MIN | Range - Returns the smallest value in a list, range or array. |
| PERCENTILE.EXC | Percentile - Returns the number corresponding to a particular percentage from an array of numbers (exclusive). |
| PERCENTILE.INC | Percentile - Returns the number corresponding to a particular percentage from an array of numbers (inclusive). |
| QUARTILE.EXC | Quartile - Returns the quartile of a data set (exclusive). |
| QUARTILE.INC | Quartile - Returns the quartile of a data set (inclusive). |
| AVEDEV | Mean Deviation - Returns the average deviation of the numbers in a list, table or cell range. |
| VAR.S | Variance - Returns the variance based on a sample. |
| VARA | Variance - Returns the variance based on a sample (including logical values and text). |
| VAR.P | Variance - Returns the variance based on an entire population. |
| VARPA | Variance - Returns the variance based on an entire population (including logical values and text). |
| STDEV.S | Standard Deviation - Returns the standard deviation based on a sample. |
| STDEVA | Standard Deviation - Returns the standard deviation based on a sample (including logical values and text). |
| STDEV.P | Standard Deviation - Returns the standard deviation based on an entire population. |
| STDEVPA | Standard Deviation - Returns the standard deviation based on an entire population (including logical values and text). |
| MAX Range - Returns the largest value in a list, range or array. |
| MIN Range - Returns the smallest value in a list, range or array. |
| PERCENTILE.EXC Percentile - Returns the number corresponding to a particular percentage from an array of numbers (exclusive). |
| PERCENTILE.INC Percentile - Returns the number corresponding to a particular percentage from an array of numbers (inclusive). |
| QUARTILE.EXC Quartile - Returns the quartile of a data set (exclusive). |
| QUARTILE.INC Quartile - Returns the quartile of a data set (inclusive). |
| AVEDEV Mean Deviation - Returns the average deviation of the numbers in a list, table or cell range. |
| VAR.S Variance - Returns the variance based on a sample. |
| VARA Variance - Returns the variance based on a sample (including logical values and text). |
| VAR.P Variance - Returns the variance based on an entire population. |
| VARPA Variance - Returns the variance based on an entire population (including logical values and text). |
| STDEV.S Standard Deviation - Returns the standard deviation based on a sample. |
| STDEVA Standard Deviation - Returns the standard deviation based on a sample (including logical values and text). |
| STDEV.P Standard Deviation - Returns the standard deviation based on an entire population. |
| STDEVPA Standard Deviation - Returns the standard deviation based on an entire population (including logical values and text). |
Statistics
| F.TEST | |
| CHISQ.TEST |
| F.TEST |
| CHISQ.TEST |
CONFIDENCE.NORM
CONFIDENCE.T
T.TEST
© 2026 Better Solutions Limited. All Rights Reserved. © 2026 Better Solutions Limited TopPrevNext