Eliminate Top 2 Percent

C

chowda

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!
 
T

twoodmore via AccessMonster.com

Select Top 98 Percent Field1 From Table1
Order By Field1 ASC
 
B

Brendan Reynolds

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])
 
D

Dale Fye

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.
 
Top