formula for cell's dispersion
Looking to calculate the absolute average deviation from the mean for a given cell. I have a formula that takes the absolute value difference between the reference cell's value and the average value of the range in which it falls. not sure if there's an actual excel function that performs this or is this my best way to go?
=ABS(A4-AVERAGE($A$4:$A$13))
|