Trimmean for limited array

S

Sige

Hi there,

What function would you use to determine an average on a limited array
which should be evaluated?

With a limited array I mean: just 5 to 8 values.
The reason why: I might have a pos. or a neg outlier in this limited
range which I would filter out. The probability to have 2 outliers is
nearly inexistant.

I thought =TRIMMEAN(B10:B17;40%) would be the best option.

Do you have other suggestions?

Best Regards Sige
 
D

Domenic

If, for example, you have 5 values and you'd like to average the 4
highest ones, you can use the following formula...

=AVERAGE(LARGE(A1:A5,{1,2,3,4}))

Hope this helps!
 
B

Bernie Deitrick

Sige,

For a small sample with outliers, average (mean) may not be the best measure. Perhaps MEDIAN would
be more appropriate, or using the STDEV as a measure before deciding. Personally, I would compare
the results from some past data sets and see what function or combinations of functions returns the
more useful number most of the time.

HTH,
Bernie
MS Excel MVP
 

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