Excel Formulas

Statistics Excel Formula Examples

Copy-paste examples for statistics formulas in Excel.

💡 Ideas for You

Helpful resources matched to this page.

4 focused options
📚 Step-by-step booksIndependent learning resources and step-by-step books from Create & Learn.📘 Topic guideAmazon ideas related to Statistics.🧮 Formula booksBooks and references for spreadsheet formulas and examples.⌨️ Productivity setupHelpful books, office tools, and productivity resources.

Browse formulas

Choose a formula page for copy-paste examples, step-by-step notes, and common mistakes.

fx

AVERAGE Formula

Calculate the average of values.

fx

AVERAGEIF Formula

Average values that meet one condition.

fx

AVERAGEIFS Formula

Average values that meet multiple conditions.

fx

MEDIAN Formula

Return the middle value.

fx

MODE Formula

Return the most common value.

fx

MIN Formula

Return the smallest value.

fx

MAX Formula

Return the largest value.

fx

SMALL Formula

Return the nth smallest value.

fx

LARGE Formula

Return the nth largest value.

fx

COUNT Formula

Count numeric cells.

fx

COUNTA Formula

Count non-empty cells.

fx

COUNTBLANK Formula

Count blank cells.

fx

COUNTIF Formula

Count cells that meet one condition.

fx

COUNTIFS Formula

Count cells that meet multiple conditions.

fx

STDEV.S Formula

Calculate sample standard deviation.

fx

VAR.S Formula

Calculate sample variance.

fx

PERCENTILE Formula

Return a percentile value.

fx

QUARTILE Formula

Return a quartile value.

fx

RANK Formula

Rank a value against other values.