The Excel AVEDEV function calculates the average of absolute deviations from the mean in a given set of data.
Variance and standard deviation functions deal with negative deviations by squaring deviations before they are averaged. AVEDEV handles negative values by working only with...Read more
The Excel DEVSQ function calculates the sum of the squared deviations from the mean for a given set of data. Variance and standard deviation functions deal with negative deviations by squaring deviations before they are averaged. DEVSQ calculates the sum of the squared deviations from the mean,...Read more
The RANK.EQ function returns the rank of a numeric value compared to a list of other numeric values. RANK.EQ can rank values from largest to smallest (i.e., the rank of highest test scores) and smallest to largest (i.e., the rank of fastest times in a race). You can use the RANK.EQ function...Read more
The RANK.AVG function returns the rank of a numeric value compared to a list of other numeric values. RANK.AVG can rank values from largest to smallest (i.e., the rank of highest test scores) and smallest to largest (i.e., the rank of fastest times in a race). When RANK.AVG encounters...Read more
The Excel HARMEAN function returns the harmonic mean for a set of numeric values. The harmonic mean is a kind of numeric average, calculated by dividing the number values in a list by the sum of the reciprocal of each value. In other words, the harmonic mean is the reciprocal of the average of...Read more
The Excel GEOMEAN function calculates the geometric mean. Geometric mean is the average of a set of products — technically, the nth root of n numbers. The general formula for the geometric mean of n numbers is the nth root of their...Read more
The Excel TRIMMEAN function calculates mean (average) while excluding outliers. The number of data points to exclude is provided as a percentage.
TRIMMEAN works by first excluding values from the top and bottom of a data set, then calculating mean. The number of data points is provided...Read more
The Excel FLOOR.PRECISE function rounds a number down to a given multiple, where multiple is provided as the significance argument. If the number is already an exact multiple, no rounding occurs and the original number is returned.
The FLOOR.PRECISE function takes two ...Read more
