Jump to content

Centroid: Difference between revisions

521 bytes added ,  14 February 2021
Line 22: Line 22:
# minimum weighted distance sum - find the weighted distance sum that is the lowest. The corresponding city is the centroid city;
# minimum weighted distance sum - find the weighted distance sum that is the lowest. The corresponding city is the centroid city;
# add cities - more cities can be added to see whether the found centroid city is correct. For this recommence on step 1;
# add cities - more cities can be added to see whether the found centroid city is correct. For this recommence on step 1;
=== Spreadsheet ===
The recipe described above has been implemented in a Google spreadsheet. For each country (territory) a separate spreadsheet needs to be created (just copy an existing) one. Each spreadsheet has multiple worksheets.
* population worksheet: this worksheet lists the largest cities and their population (as columns), ordered by the population. The fraction is calculated from the data.
* distance worksheet: this worksheet contains the distances between the cities noted on the population spreasheet.
== Result ==
== Result ==
This recipe has been applied on the following countries:
This recipe has been applied on the following countries:
3,543

edits