Detecting abnormal values in a moving range.

[[email protected]]

I need to detect isolated potentially abnormal values
in a moving range of sequential data and write them in a separate
worksheet.
For example :

Day# 1 2 3 4 5 6 7 8 9 10 11 12 13
14 15 16 17 18

Value x x y x x y y x y y y y
z z y y y y

This problem requires the control of 2 moving ranges, 5 days and 10
days.

Rules :
1. The 2 days preceding values and the 2 days following values
are equal to each other but different from the current value
Write data to separate worksheet table under columns Day# and Value

Case Day 3 : Value "y" is an isolated potentially abnormal value.
Case Day 8 : value "x" ' ' ' ' ' '


2. A cluster of 2 equal values are preceded and followed by 4 days of
values
equal to each other but different from the cluster values.
Case Day 13 & 14 : value "z" are isolated potentially abnormal
values.

Expected table :

Day# Value RangeSpan
3 y 5
8 x 5
13 z 10
14 z 10

Help appreciated.

Wayne.

[Don Guillett]

homework?

--
Don Guillett
SalesAid Software
[email protected]
<[email protected]> wrote in message
news:[email protected]...
>I need to detect isolated potentially abnormal values
> in a moving range of sequential data and write them in a separate
> worksheet.
> For example :
>
> Day# 1 2 3 4 5 6 7 8 9 10 11 12 13
> 14 15 16 17 18
>
> Value x x y x x y y x y y y y
> z z y y y y
>
> This problem requires the control of 2 moving ranges, 5 days and 10
> days.
>
> Rules :
> 1. The 2 days preceding values and the 2 days following values
> are equal to each other but different from the current value
> Write data to separate worksheet table under columns Day# and Value
>
> Case Day 3 : Value "y" is an isolated potentially abnormal value.
> Case Day 8 : value "x" ' ' ' ' ' '
>
>
> 2. A cluster of 2 equal values are preceded and followed by 4 days of
> values
> equal to each other but different from the cluster values.
> Case Day 13 & 14 : value "z" are isolated potentially abnormal
> values.
>
> Expected table :
>
> Day# Value RangeSpan
> 3 y 5
> 8 x 5
> 13 z 10
> 14 z 10
>
> Help appreciated.
>
> Wayne.
>