AnsweredAssumed Answered

Average Distance between all Points in the same Polygon

Question asked by S5230 on Jul 10, 2018
Latest reply on Jul 11, 2018 by Dan_Patterson

Hello Everybody,


I would be happy, if you could help me with this one:


I have a point shape containing almost 30000 points and I have a polygon shape with thousands of polygons. Every Point that is within one of the polygons has already been spatially joined with the ID of the polygon.


What I want to do: For every point I want to calculate the average (euclidean) distance to every other point within the same polygon (same polygon ID in the table).


It doesn't necessarily have to be an ArcGIS solution, Excel f.ex. would be just as fine.


The idea is to have a variable that tells me how centrally located a retailer is inside a shopping area (central as in close to the other retailers of the same type).


Thank you,