If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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? |
Thread Tools | |
Display Modes | |
|
|