replace an outlier value with average of previous record & next record
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)
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)
Find more posts tagged with
Sort by:
1 - 2 of
21
Altair EmployeeHi,
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
Hi Martin, thank you for sharing the idea.
Sort by:
1 - 1 of
11
Altair EmployeeHi,
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