Hello,
How to deal with this missing values.
Column Rat-Row 8. i would like > average MISSING VALUE.xlsx (10.1 KB)
Column Rat depending same Class en same Dist. O.
In this example is equal to (90+107)/2 = 98,5
For the other column it will be exactly the same idea : average same Class same Dist.O
Thanks a lot for your answer, it is exactly what i want to do but i want to take in account the CLASS and distance column.
For example
C1 dist. O 2000 Class 1 = mean C1/ Dist. O and Class 1
This is exactly what’s happening The group loop ensures that. It will consider all rows for the combination Dist. O and Class 1 and then calculate the mean for those rows only.