Creating a new variable containing the mean difference between the coordinates of a group

[Joost Koning]

I have a dataset containing information of a lot of corporate owners and their subsidiaries, with coordination information about the location about those subsidiaries.

The data-set (which is attached to this messagE) has, among others, these variables:

• index (containing an index number, different for every row of data)
• ID_x (containing a name, different for every corporate owner)
• CompanynameLatinalphabet (containing an index number, different for every corporate owner)
• Noofsubsidiaries (containing the number of subsidiaries of the corporate owner)
• SubsidiaryName (containing the name of the subsidiary)
• Latitude (containing the latitude of the subsidiary-location)
• Longitude (containing the longitude of the subsidiary-location)

I want to create a new variable containing the mean difference in geographic location (so coordinates) of the subsidiaries relative to each other, done for every corporate owner separately, but don’t know how.

Is anyone able to help me? Thanks a lot in advance!