Excel AVEDEV Function
Use:- Computes mean absolute deviation (MAD) of a set of data
- Syntax:
- AVEDEV( range )
- Examples:
- Cell D12 formula: AVEDEV( C4:G4 )
Cell D13 formula: AVEDEV( D3:D9 )
Cell D14 formula: AVEDEV( C3:G9 )
Cell D15 formula: AVEDEV( D3:D9,G3:G9 ) 
- Related Functions:
- STDEV, STDEVP, VAR,
VARP