Calculate disparity between sets of points

[nikki19]

Hello,
I need to calculate the disparity between sets of points.

Basically, I have a set of 5 points plotted on a grid and need a way to calculate the distance between any 2 points in the set and the average of those distances. I would like to be able to do this with multiple sets on the same grid (so get a different average for each set), but could seperate them if needed.

Thank you for your help!

[Richard Buttrey]

Hi,

You'll need to upload your workbook and manually add any results grid that you want to end up with so that we can see your end goal. Along with notes as to how you've calculated the results with specific references to the original cells.