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

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?