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).