The Excel AVERAGEA function returns the average of a group of supplied values. Unlike AVERAGE, AVERAGEA will also evaluate the …

# Category: Statistical functions

In addition to formulas, another way to conduct mathematical computations in Excel is through functions. Statistical functions apply a mathematical process to a group of cells in a worksheet. For example, the SUM function is used to add the values contained in a range of cells.

The Excel AVEDEV function returns the average of the absolute value of deviations from the mean for a given set of …