replace an outlier value with average of previous record & next record

anildas

replace an outlier value with average of previous record & next record 
Utilization
---------
78
80 
2000 (outlier)
91
76
I want replace if the Utilization >99.99 with the average of previous record and next record of the outlier (ie average of 80+91)

MartinLiebig

Hi,

you can use Generate Attributes first to assign missing values by a rule, like

if(Utilization>90, MISSING_NUMERIC, Utilization)

Then you can use Replace Missing Values (Series) to interpolate.

Best,

Martin

MartinLiebig

Hi,

you can use Generate Attributes first to assign missing values by a rule, like

if(Utilization>90, MISSING_NUMERIC, Utilization)

Then you can use Replace Missing Values (Series) to interpolate.

Best,

Martin

anildas

Hi Martin, thank you for sharing the idea.