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!
Related Posts with Help with getting percentiles
Adding values in estpost/esttabHi, i'm using estpost and esttab to export variables summarizes. I would like to get Count/750 for e…
Propensity score matching with restrictionsDear all, I have a monthly panel data of firm (variable: gvkey) and their turnover (variable: trn) …
How can I replace the missing data value with the existing repeated values by cityHow can I replace the missing data value with the existing repeated values by city! clear input int …
-mylabels- issue with invalid label specifierUsed the following code: mylabels "1 Jun 2015" "1 Aug 2015" "1 Oct 2015" "1 Dec 2015" "1 Feb 2016" …
regression by industry and yearHi members, I am trying to run a regression by industry and year. I used the following code but I g…
Subscribe to:
Post Comments (Atom)
0 Response to Help with getting percentiles
Post a Comment