Eliminate Top 2 Percent

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello.

I am trying to eliminate the highest 2 percent of data in a field. The
purpose is two elimiinate items that are unusual to rest of the set of data
and skew the averages. Is there a fuction that will do this? Thanks!
 
chowda said:
Hello.

I am trying to eliminate the highest 2 percent of data in a field. The
purpose is two elimiinate items that are unusual to rest of the set of
data
and skew the averages. Is there a fuction that will do this? Thanks!
Click to expand...


A sub-query should do it. Here's an example using the Orders table from the
Northwind sample database ...

SELECT Orders.[Shipping Fee]
FROM Orders WHERE [Order ID] NOT IN (SELECT TOP 2 PERCENT [Order ID] FROM
Orders ORDER BY [Shipping Fee], [Order ID])
 
I can understand why you might want to discard outliers, but not why you want
to eliminate the top 2% and not the bottom 2%?

This is not a statistically valid procedure.
 
Back
Top