trimmed mean function and if bold function

  • Thread starter Thread starter Kyle
  • Start date Start date
K

Kyle

Does anyone know if either a trimmed mean function (one
that rejects data that is more than 2 standard devations
from the mean, but does not necessarily remove a given
percent from each tail) or a if bold function (where
Excel can insert a true/false type answer (but instead
either inserting the number or inserting a blank cell
into the column is the row reference is either bold &
italliced or normal)exist? And if so how does one
find/use/implement them? Thanks for you help and time!
 
One way for the trimmed mean (array entered: CTRL-SHIFT-ENTER or
CMD-RETURN):

=AVERAGE(IF((ABS(rng-AVERAGE(rng)))>(2*STDEV(rng)), "", rng))

where rng is your data range.

I can't follow your "if bold" function specification.
 
Kyle,

I don't think an isbold function exists. Their aren't any
is(insert_desired_format_here) functions. You would
probably need to write a user defined function (VBA)

Dan E
 
Back
Top