Formulas and Functions Help
- Welcome
- Intro to formulas and functions
-
- ACCRINT
- ACCRINTM
- BONDDURATION
- BONDMDURATION
- COUPDAYBS
- COUPDAYS
- COUPDAYSNC
- COUPNUM
- CUMIPMT
- CUMPRINC
- CURRENCY
- CURRENCYCODE
- CURRENCYCONVERT
- CURRENCYH
- DB
- DDB
- DISC
- EFFECT
- FV
- INTRATE
- IPMT
- IRR
- ISPMT
- MIRR
- NOMINAL
- NPER
- NPV
- PMT
- PPMT
- PRICE
- PRICEDISC
- PRICEMAT
- PV
- RATE
- RECEIVED
- SLN
- STOCK
- STOCKH
- SYD
- VDB
- YIELD
- YIELDDISC
- YIELDMAT
-
- AVEDEV
- AVERAGE
- AVERAGEA
- AVERAGEIF
- AVERAGEIFS
- BETADIST
- BETAINV
- BINOMDIST
- CHIDIST
- CHIINV
- CHITEST
- CONFIDENCE
- CORREL
- COUNT
- COUNTA
- COUNTBLANK
- COUNTIF
- COUNTIFS
- COVAR
- CRITBINOM
- DEVSQ
- EXPONDIST
- FDIST
- FINV
- FORECAST
- FREQUENCY
- GAMMADIST
- GAMMAINV
- GAMMALN
- GEOMEAN
- HARMEAN
- INTERCEPT
- LARGE
- LINEST
- LOGINV
- LOGNORMDIST
- MAX
- MAXA
- MEDIAN
- MIN
- MINA
- MODE
- NEGBINOMDIST
- NORMDIST
- NORMINV
- NORMSDIST
- NORMSINV
- PERCENTILE
- PERCENTRANK
- PERMUT
- POISSON
- PROB
- QUARTILE
- RANK
- SLOPE
- SMALL
- STANDARDIZE
- STDEV
- STDEVA
- STDEVP
- STDEVPA
- TDIST
- TINV
- TTEST
- VAR
- VARA
- VARP
- VARPA
- WEIBULL
- ZTEST
AVEDEV
The AVEDEV function returns the average of the difference of a set of numbers from their average (arithmetic mean).
AVEDEV(value, value…)
value: A single value or collection. Each value must be a number value, date/time value, or duration value. All values must be of the same value type.
value…: Optionally include one or more additional values or collections of values.
Notes
AVEDEV divides the sum of the numbers by the number of numbers to get the average. The difference (absolute value) between the average and each number is summed and divided by the number of numbers.
If value contains date/time values, a duration value is returned.
Examples |
|---|
=AVEDEV(2, 2, 2, 4, 4, 4) returns 1. =AVEDEV(2, 2, 2, 2, 3, 3, 3, 3, 4, 4, 4, 4) returns 0.666666666666667. =AVEDEV("3d", "6d", "4d", "7d") returns 1d 12h, a duration value. =AVEDEV("12/1/2010", "12/31/2011", "9/30/2013") returns 371d 18h 40m, also a duration value. |