|  

» Excluding Exceptional Values when Calculating an Average

Problem:

List1 (column A) contains 10 numbers, two of which (0 & 500) are significantly smaller or greater than the remainder.
If included in an average calculation, these exceptional values would disproportionately influence the result.
We, therefore, need a way of calculating an average that more accurately reflects the general spread of data.

Solution:

Use the TRIMMEAN function as shown in the following formula:
=TRIMMEAN(A2:A11,0.2)


Rate This Tip
12 34 5
Rating: 3.33     Views: 11459
No comments have been submitted.
Click here to post comment
For Registered Users
Name
Comment Title
Comments