## How to use the AVEDEV function

The AVEDEV function calculates the average of the absolute deviations of data points from their mean.

The absolute deviation from the mean helps us understand how "spread out" the values in a data set are, it describes the variation in a data set.

Formula in cell D3:

=AVEDEV(B3:B7)

### Excel Function Syntax

AVEDEV(*number1*, *[number2]*, ...)

### Arguments

number1 |
Required. A cell reference to number(s) or an array of numbers. |

[number2] |
Optional. Up to 254 additional number arguments. |

### Comments

AVEDEV is a measure of the variability in a data set. Variability is the extent to which a distribution is stretched or squeezed.

### Functions in 'Statistical' category

The AVEDEV function function is one of many functions in the 'Statistical' category.

Calculates the average of the absolute deviations of data points from their mean.

Calculates the average of numbers in a cell range.

Returns the average of a group of values. Text and boolean value FALSE evaluates to 0. TRUE to 1.

Returns the average of cell values that are valid for a given condition.

Returns the average of cell values that evaluates to TRUE for multiple criteria.

Calculates the beta distribution.

Calculates the inverse of the cumulative beta distribution.

Calculates the individual term binomial distribution probability.

Calculates the minimum value for which the binomial distribution is equal to or greater than a given threshold value.

Calculates the probability of the chi-squared distribution, cumulative distribution or probability density.

Calculates the right-tailed probability of the chi-squared distribution.

Calculates the inverse of the left-tailed probability of the chi-squared distribution.

Calculates the inverse of the right-tailed probability of the chi-squared distribution.

Calculates the test for independence, the value returned from the chi-squared statistical distribution and the correct degrees of freedom. Use this function to check if hypothesized results are valid.

Calculates the confidence interval for a population mean.

Calculates the confidence range for a population mean using a Student's t distribution.

Calculates the correlation between two groups of numbers.

Counts all numerical values in an argument.

Counts the non-empty or blank cells in a cell range.

Counts empty or blank cells in a range.

Calculates the number of cells that is equal to a condition.

Calculates the number of cells across multiple ranges that equals all given conditions.

Calculates the covariance meaning the average of the products of deviations for each pair in two different datasets.

Calculates the sample covariance meaning the average of the products of deviations for each pair in two different datasets.

Calculates the exponential distribution representing an outcome in the form of probability.

Calculates the F probability for two tests.

Calculates the right-tailed F probability for two tests.

Calculates the two-tailed probability from an F-test

Calculates a value based on existing x and y values using linear regression.

Calculates how often values occur within a range of values and then returns a vertical array of numbers.

Calculates the GAMMA value.

Calculates the gamma often used in queuing analysis (probability statistics) that may have a skewed distribution.

Calculates the geometric mean.

Returns estimated exponential growth based on given data.

Returns a value representing the y-value where a line intersects the y-axis.

Calculates the k-th largest value from an array of numbers.

Returns an array of values representing the parameters of a straight line based on the "least squares" method.

Returns an array of values representing the parameters of an exponential curve that fits your data, based on the "least squares" method.

Calculates the lognormal distribution of argument x, based on a normally distributed ln(x) with the arguments of mean and standard_dev.

Calculate the largest number in a cell range.

Calculates the highest value based on a condition or criteria.

Calculates the median based on a group of numbers. The median is the middle number of a group of numbers.

Returns the smallest number in a cell range.

Returns the smallest number. Text values and blanks are ignored, boolean value TRUE evaluates to 1 and FALSE to 0 (zero).

Calculates the smallest value based on a given set of criteria.

Returns the most frequent number in a cell range. It will return multiple numbers if they are equally frequent.

Calculates the most frequent value in an array or range of data.

Calculates the normal distribution for a given mean and standard deviation.

Calculates the inverse of the normal cumulative distribution for a given mean and standard deviation.

Calculates the percent rank of a given number in a data set.

Calculates the percent rank of a given number compared to the whole data set.

Returns the number of permutations for a set of elements that can be selected from a larger number of elements.

Returns the number of permutations for a specific number of elements that can be selected from a larger group of elements.

Calculates a number of the density function for a standard normal distribution.

Returns the quartile of a data set.

Returns the quartile of a data set, based on percentile values from 0..1, inclusive.

Returns the rank of a number out of a list of numbers.

Calculates the rank of a number in a list of numbers, based on its position if the list were sorted.

Calculates the skewness of a group of values.

Calculates the slope of the linear regression line through coordinates.

Returns the k-th smallest value from a group of numbers.

Calculates a normalized value from a distribution characterized by mean and standard_dev.

Returns standard deviation based on the entire population.

Returns standard deviation based on a sample of the entire population.

Estimates the standard deviation from a sample of values.

Returns the standard deviation based on the entire population, including text and logical values.

Calculates values along a linear trend.

Calculates the mean of the interior of a data set.

Returns the variance based on the entire population. The function ignores logical and text values.

The VAR.S function tries to estimate the variance based on a sample of the population. The function ignores logical and text values.

## How to comment

How to add a formula to your comment<code>Insert your formula here.</code>

Convert less than and larger than signsUse html character entities instead of less than and larger than signs.

< becomes < and > becomes >

How to add VBA code to your comment[vb 1="vbnet" language=","]

Put your VBA code here.

[/vb]

How to add a picture to your comment:Upload picture to postimage.org or imgur

Paste image link to your comment.

Contact OscarYou can contact me through this contact form