Finding average of absolute values

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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...
 
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))}
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Average of absolute values of moving ranges 1
Predictive Model Formula 1
Average of a string containing multiple values 20
Average formula 1
Averaging values 1
Conditional Averages 1
Average function 9
Time - 2 things: Average mm:ss.00, Negitive Times 5

Back
Top