View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
SCrowley SCrowley is offline
external usenet poster
 
Posts: 47
Default how do i winsorize data in excel

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/softw...lar/winsor.htm

Good luck!

--
Thank you,

scrowley(AT)littleonline.com


"Samira Pimentel" wrote:

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?