V
Viggo Linde
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?
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?