Finding average of absolute values

G

Glenn

I would like to know a formula to calculate the absolute average of a list containing both positive and negative numbers, so that the numbers below would produce a result of 9.464

3.45, 5.64, 19.71, -3.2, -15.32

Any help would be appreciated...
 
N

Norman Harker

Hi Glenn!

One way:

With your data in A1:A5

=AVERAGE(ABS(A1:A5))
Entered as an array by pressing and holding down Ctrl + Shift and then
pressing Enter. Appears in the formula bar as:

{=AVERAGE(ABS(A1:A5))}
 
Top