find outlier among a group????

J

Jeff C

I have approximately 50,000 product records with descriptions and costs
however in each group of similar products there are some that have outlier
costs assigned. for instance one group of like items may have costs ranging
from $2-$3 with one or two of the items assigned a cost of $150.

Is there a way of looking for these kind of outliers? Thanks in advance.
 
G

Gary''s Student

1. For a common group, calculate both the mean and standard deviation.

2. Then, for each member of group, calculate the absolute value of its
deviation from the mean.

3. If the item deviation calculated in step 2 exceeds three times the
standard deviation calculated in step 1, the item may be considered an
outlier.
 
J

Jeff C

--
Jeff C
Live Well .. Be Happy In All You Do


Gary''s Student said:
1. For a common group, calculate both the mean and standard deviation.

2. Then, for each member of group, calculate the absolute value of its
deviation from the mean.

3. If the item deviation calculated in step 2 exceeds three times the
standard deviation calculated in step 1, the item may be considered an
outlier.
Click to expand...

Great! Thanks - is there a way to apply these calculations over the entire
record set at once?
 
Top