cat3appr Posted August 30, 2020 Posted August 30, 2020 (edited) hi all, How would you remove the outliers from this graph? Please see the image and the spreadsheet attached I need to remove the Easting / Northing entries ( column C, D) which are too far from the dense area, keep only those inside the orange circle... thanks! remove outlier.xlsx Edited August 30, 2020 by cat3appr Quote
BIGAL Posted August 30, 2020 Posted August 30, 2020 Just do a ray tracing algorithm say from centre to point and if greater than rad then delete. Can do ellipse using intersect with compare. Quote
SLW210 Posted August 31, 2020 Posted August 31, 2020 Why not do this in MS Excel? https://www.dummies.com/software/microsoft-office/excel/how-to-highlight-statistical-outliers-in-excel/ You might find even better methods on an MS Excel Forum. Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.