View Single Post
 
Old 02-16-2015, 08:10 AM
grexcelman grexcelman is offline Windows 7 32bit Office 2003
Novice
 
Join Date: Dec 2014
Posts: 21
grexcelman is on a distinguished road
Question 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))
Reply With Quote