Which function for smoothing average?

B

Brett

Say I have the following data in a column:

2
4
1
5
6
25

The data entry of 25 will skew an average. Which Excel function can I
use to offset such a skew?

Thanks,
Brett
 
J

JE McGimpsey

There are myriad methods for excluding data from data sets - some even
valid, but no one Excel function.

If these are sample data, why do you assume that 25 skews the average?
25 falls within 2 standard deviations of the sample mean, so it's hard
to justify excluding it from a normally distributed population.

If they're not, what criterion would you apply to determine that a
particular value skews the average. For instance, if the data were

1,5,6,5,6,6

would 1 be considered a skew?
 
Top