Function: Ignore Mimimum and Maximum Values

M

Michael J

Is there a spreadsheet function to calculate the average, ignoring a single
minimum and maximum value. This is similar to what they use in the olympics
to calculate a score.

Example: for this list:

A1: 10
A2: 10
A3: 8
A4: 7
A5: 6
A6: 6
A7: 6

I would need to average only cells A2 through A6, ignoring a single max and
min value. The list is normally not sorted and the the number of values is
not constant.
Is there a statistical calulcation to do this?
 
J

JE McGimpsey

One way:

=TRIMMEAN(A1:A7, 2/7))

For more or fewer numbers, this can be generalized as

=TRIMMEAN(A:A,2/COUNT(A:A))
 

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

Top