Excel Statistical Functions

This section will learn  how to use Excel’s  Statistical Functions such as: Avedev, Average, AverageA, AverageIF, AverageIFS, etc.

AVEDEV – returns the average of the absolute deviations of the numbers that you provided.

AVERAGE – returns the average of the numbers that you provided

AVERAGEA – returns the average of its arguments, including numbers, text, and logical values.

AVERAGEIF – returns the average of all numbers in a range of cells that meet a given criteria.

AVERAGEIFS – returns the average of all numbers in a range of cells that meet multiple criteria.

MAX – returns the largest numeric value from the numbers that you provided.

MIN – returns the smallest numeric value from the numbers that you provided.

SMALL -returns the nth smallest numeric value from the numbers that you provided.

LARGE -returns the largest numeric value from the numbers that you provided. Or returns the largest value in the array.

Comments

So empty here ... leave a comment!

Leave a Reply

Your email address will not be published. Required fields are marked *

Sidebar