Hello,
I have 5 rows that has data in many columns (different categories for each row). I wish to identify the two rows that are the outliers or the three rows that are the closest to each other the most times in each category in order to choose the most precise 3 representative rows. I was thinking of identifying the interquartile range or finding the values with the smallest differences in each column but I am still not sure how to total the occurrences up to identify the two rows to exclude or the three rows to include.
Much thanks in advance.
I have 5 rows that has data in many columns (different categories for each row). I wish to identify the two rows that are the outliers or the three rows that are the closest to each other the most times in each category in order to choose the most precise 3 representative rows. I was thinking of identifying the interquartile range or finding the values with the smallest differences in each column but I am still not sure how to total the occurrences up to identify the two rows to exclude or the three rows to include.
Much thanks in advance.