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

User: "anildas"
anildas
New Altair Community Member
Updated by Jocelyn
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)

Find more posts tagged with

AI Studio
Sort by:
1 - 1 of 11
    User: "MartinLiebig"
    MartinLiebig
    Altair Employee
    Accepted Answer
    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
    View in context
Quick Links