Hi all,
My problem is the following: I have a sheet with product categories, and each category has its respective prices for each month.
I want to clean the database by removing outliers, and the criteria that I thought was to drop the highest 1% and lowest 1% of the prices for each categories. This is equivalent to finding the 1% and 99% percentiles for each price distribution and dropping what is above and below them.
I tried cumul, pctile and centile functions but with no success, so I would really appreciate if someone can help. Thanks in advance!