how to identify outliers

From: "Rhys A(dot)D(dot) Stewart" <rhys(dot)stewart(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: how to identify outliers
Date: 2009-10-27 21:36:12
Message-ID: 189966030910271436v4390fa34n77831932adbdd928@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hey all,
I have the following table: data(pnum text, distance float8, route text).
I would like to remove the outliers in distance, i.e. lets say i get
the avg dist of pnum for each route and the std deviation of the
distance what is the best way to identify the outliers?

Rhys.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message fox7 2009-10-27 22:11:31 Slow running query with views...how to increase efficiency? with index?
Previous Message Little, Douglas 2009-10-27 21:31:40 Re: Pgadmin support for writing files or psql \copy command