Eliminate Top 2 Percent

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

 

[twoodmore via AccessMonster.com]

Select Top 98 Percent Field1 From Table1
Order By Field1 ASC

 

[Brendan Reynolds]

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!

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

 

[Guest]

Thank You...worked perfect

Select Top 98 Percent Field1 From Table1
Order By Field1 ASC

 

[Guest]

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.