Data analysis: Detection and removal of outliers
 

I would like a script for detection of €�outliers€� during data anaylsis and
removal as a second step.

I have a range of cells containing €�control€� values and specific cells
containing the €�outlier€� limit values (high/low, e.g. +/- 2 SD from average).
i.e. the range that valid data should be within.

I would like to run a script that checks if any of the €�control€� values are
outliers and then deletes them.
Deletion of outliers should be limited to e.g. 2 values.
The script should only run once.

I can not use €�conditional formatting€� since the €�outlier€� limit values
change when deleting values, the formatting will follow and possible create
new outliers.

I hope my description is good enough.

Anybody with input to something like this?

Data analysis: Detection and removal of outliers
 

- Btw, I'm running Win2k, Excel 2002 SP3.

"Viggo Linde" wrote:

I would like a script for detection of €�outliers€� during data anaylsis and
removal as a second step.

I have a range of cells containing €�control€� values and specific cells
containing the €�outlier€� limit values (high/low, e.g. +/- 2 SD from average).
i.e. the range that valid data should be within.

I would like to run a script that checks if any of the €�control€� values are
outliers and then deletes them.
Deletion of outliers should be limited to e.g. 2 values.
The script should only run once.

I can not use €�conditional formatting€� since the €�outlier€� limit values
change when deleting values, the formatting will follow and possible create
new outliers.

I hope my description is good enough.

Anybody with input to something like this?