Loading ExcelGPT

AI-Powered Excel Assistant

Published on 2025-12-08T00:02:25+08:00

Statistical Functions: AVERAGE, MEDIAN, STDEV

Statistical Functions in Excel

Central Tendency

AVERAGE

Calculates the arithmetic mean of values.

=AVERAGE(A1:A100)

MEDIAN

Returns the middle value when data is sorted.

=MEDIAN(A1:A100)

MODE

Returns the most frequently occurring value.

=MODE.SNGL(A1:A100)
=MODE.MULT(A1:A100)  // for multiple modes

Dispersion Measures

Standard Deviation

=STDEV.S(A1:A100)  // sample
=STDEV.P(A1:A100)  // population

Variance

=VAR.S(A1:A100)  // sample
=VAR.P(A1:A100)  // population

Other Useful Functions

Function	Description
PERCENTILE.INC	=PERCENTILE.INC(A1:A100, 0.9) - 90th percentile
QUARTILE.INC	=QUARTILE.INC(A1:A100, 1) - first quartile
RANK.EQ	=RANK.EQ(A1, A:A, 0) - rank descending

Conditional Statistics

AVERAGEIF / AVERAGEIFS
MAXIFS / MINIFS
COUNTIF / COUNTIFS

Conclusion

These functions form the foundation of data analysis in Excel and are essential for any analyst.

Share this article

Related Posts

Statistical Functions: AVERAGE, MEDIAN, STDEV

Master Excel statistical functions including AVERAGE, MEDIAN, MODE, STDEV, and more for comprehensive data analysis.

2025-12-08T00:02:25+08:00

Data Validation: Control What Users Can Enter

Master Excel data validation to create dropdown lists, restrict input types, and ensure data quality in your spreadsheets.

2025-12-08T00:02:25+08:00

Power Query: Import and Transform Data Like a Pro

Master Power Query for automated data import and transformation. Connect to multiple sources, clean data, and refresh with one click.

2025-12-08T00:02:25+08:00

Statistical Functions: AVERAGE, MEDIAN, STDEV - ExcelGPT