Formulas > =AVEDEV()
How to Use AVEDEV() in Google Sheets
Description
How To Actually Use AVEDEV() in Sheets
AVEDEV(value1, [value2, ...])
Try AVEDEV yourself
Use the AVEDEV formula to calculate the average deviation of the values in the range A1:A10 from their mean.
Hints (2)
-
Remember that AVEDEV takes a range of values as its argument.
-
The result will show how much the values deviate from their average.
Looking for a video tutorial? Members can email me anytime! Check out the blogs below for more info on this formula. Or generate your formula. Find more formulas here at BetterSheets.co/formulas
Learn more about the AVEDEV() formula:
Generate a AVEDEV() formula for your needs
Describe your task in plain English and get a paste-ready formula that uses AVEDEV(). 2 free AI generations, no signup. Members get unlimited use.
Generate a AVEDEV() formula