how do i winsorize data in excel

[Samira Pimentel]

I have some outliers in a set of data, and would like another method, besides
the TRIMMEAN to smooth the outliers. Trimmean "eliminates" the outliers...
how do I Winsorize a set of data, in order to smooth the values?

 

[SCrowley]

I'm not familiar with outliers and found this:

There is no rigid mathematical definition of what constitutes an outlier;
determining whether or not an observation is an outlier is ultimately a
subjective exercise.
Some methods which are commonly used for identification assume that the data
are from a normal distribution, and identify observations which are deemed
"unlikely" based on mean and standard deviation: (from Wikipedia)

With that said

Here is some syntax for Winsorizing:
http://www.itl.nist.gov/div898/software/dataplot/refman2/auxillar/winsor.htm

Good luck!