Calculate average deviation in Excel using a custom formula with AVERAGE and ABS to measure linear data dispersion without squaring values.