Vahaduo calcs vol.2

[vbnetkhio]

I have no idea how to make Bulgaria into 3 parts so that it keeps the diversity of the Coast, Thrace, Sofia region, Northwest, Central Balkan mountains, etc. Ideas would be appreciated.

maybe west/central/east, or just west and east(+central)

[Ion Basescul]

maybe west/central/east, or just west and east(+central)

I was fearing that the difference between Northwest and Southwest is huge, but it's actually 2.7 so not that bad overall.
I will give it a try.

[J. Ketch]

I removed French Provence from the main sheet and renamed it as an outlier in the detailed sheet, as it plots deep into Italian territory (Stearsolina and I agreed to share editing access for both sheets). Also removed Cornish and Orcadian from the main sheet as they're unnecessary/unreliable.

[Ion Basescul]

That looks fine with me.

I had 6 regions before as in the NUTS-2 map below, and now they've been reduced to 3 for the "Bigger regions" sheet.



Population: 2.8 million


Population: 2.2 million


Population: 2 million

Bulgarian_Western,22.07,25.29,17.67,11.07,18.90,2.28,0.46,0.52,0.68,0.55,0.34,0.08,0.10
Bulgarian_Central,21.04,24.37,17.93,11.70,19.89,2.41,0.58,0.37,0.80,0.35,0.38,0.12,0.06
Bulgarian_Eastern,20.34,22.65,18.01,12.96,20.61,2.65,0.61,0.36,0.68,0.40,0.46,0.14,0.08

[N-rg]

How do you get the US averages and why is Florida missing?
How do you get national averages anyway?

[Leto]

How do you get the US averages and why is Florida missing?
How do you get national averages anyway?

Why so many questions for the first post?

[Lucas]

Stearsolina and I agreed to share editing access for both sheets.

Good, it will be community work. You can add someone trustful too.

[Jana]

in your sheet, remove the regional Serbian and Montenegrin averages, and update these:

Serb,24.83,29.18,17.10,8.89,15.96,1.66,0.53,0.30,0.61,0.49,0.33,0.06,0.08
Montenegrin,23.78,26.42,18.93,9.56,17.29,1.64,0.53,0.31,0.61,0.56,0.28,0.04,0.06
Aromanian,21.38,19.84,19.71,11.24,23.23,2.94,0.15,0.36,0.51,0.30,0.27,0.06,0.00

also, some of the Greek averages are false (like the one for Western Thrace which is actually Pelpoponnesian), they should be replaced by these academic samples and proper averages before you group them into larger regions.

Greek_Athens,18,12.97,21.34,14.07,27.58,3.93,0.36,0.53,0.32,0.18,0.27,0.16,0.28
Greek_Cappadocia,6.02,3.11,16.96,28.66,37.29,5.82,1.07,0.15,0.63,0.08,0.21,0,0
Greek_Central,17.81,13.51,20.59,14.66,27.3,4.05,0.6,0.29,0.33,0.42,0.4,0.03,0.01
Greek_CentralMacedonia,18.75,18.2,20.84,12.78,24.45,2.69,0.61,0.32,0.41,0.43,0.26,0.15,0.12
Greek_Crete,13.27,8.94,19.48,18.05,32.46,5.55,0.55,0.35,0.27,0.16,0.33,0.39,0.19
Greek_Dodecanese,10.53,5.27,20.42,19.62,35.88,6.29,0.64,0.61,0.11,0.08,0.24,0.27,0.04
Greek_Kos,12.12,5.57,19.99,20.06,34.33,6.16,0.33,0.51,0.12,0.26,0.33,0.15,0.07
Greek_Peloponnese,18.52,15.57,20.38,12.29,27.35,4.01,0.16,0.28,0.42,0.24,0.50,0.10,0.18
Greek_Southeast_Laconia,15.8,12.55,21.4,13.1,28.83,5.25,0.15,0.43,0.11,0.38,0.04,1.17,0.78
Greek_Smyrna&Phokaia,16.63,11.89,20.53,15.6,29.3,4.24,0.1,0.62,0.28,0.19,0.37,0.2,0.06
Greek_Thessaly,20.57,16.87,20.64,11.95,24.54,3.49,0.45,0.4,0.37,0.53,0.31,0.04,0.11

Greek_Thrace,16.15,15.82,19.26,15.31,28.11,3.28,0.36,0.25,0.36,0.09,0.55,0.29,0.19
Greek_West,18.22,18.63,20.5,13.48,24.98,2.64,0,0.63,0.34,0.13,0.37,0.05,0.05
Greek_Pontus,2.31,1.6,15.84,37.71,36.38,3.88,1.29,0.32,0.22,0.04,0.36,0.01,0.03
Greek_Cyclades,17.87,9.96,20.68,15.25,28.66,4.63,0.1,0.57,0.5,0.54,0.53,0.16,0.08
Greek_Lefkada,20.6,11.93,21.04,9.4,31.18,3.6,0,0,0,0,0,0,0
Greek_Achaea,18.03,17.36,20.32,13.86,25.45,3.07,0.00,0.15,0.28,0.34,0.75,0.33,0.05
Greek_Andros,17.49,7.08,20.60,13.75,33.45,5.18,0.00,0.64,0.48,0.42,0.44,0.26,0.22
Greek_Arcadia,18.67,15.99,22.74,11.72,25.92,3.52,0.00,0.20,0.29,0.25,0.11,0.60,0.00
Greek_Chios,12.44,7.95,20.50,18.87,33.30,5.32,0.34,0.28,0.24,0.11,0.30,0.33,0.04
Greek_Cyprus,7.55,2.17,20.48,19.47,41.02,7.60,0.14,0.46,0.15,0.02,0.27,0.67,0.00
Greek_Deep_Mani,15.21,8.70,20.91,14.82,32.69,5.67,0.26,0.50,0.10,0.24,0.52,0.39,0.00
Greek_Epirus,20.37,17.42,19.60,13.54,25.79,1.85,0.00,0.00,0.93,0.00,0.44,0.00,0.06
Greek_Euboea_South,20.06,14.63,22.07,12.29,25.65,4.18,0.05,0.35,0.13,0.21,0.28,0.06,0.01
Greek_Florina,21.38,20.79,20.04,11.18,23.01,2.09,0.23,0.29,0.51,0.17,0.27,0.03,0.02
Greek_Ikaria,12.91,7.77,21.44,16.75,33.87,5.34,1.01,0.23,0.17,0.01,0.45,0.04,0.00
Greek_Kalymnos,11.96,6.79,20.84,18.43,35.00,5.30,0.61,0.28,0.02,0.06,0.27,0.40,0.04
Greek_Karpathos,10.68,5.74,20.58,19.19,34.18,7.47,0.86,0.64,0.14,0.09,0.00,0.30,0.13
Greek_Kastellorizo,9.57,3.93,19.32,20.10,40.03,5.21,0.04,0.53,0.11,0.04,0.49,0.52,0.11
Greek_Kefalonia,17.53,11.97,21.39,14.65,28.21,4.91,0.28,0.16,0.23,0.25,0.32,0.12,0.00
Greek_Konya,6.50,4.87,19.02,26.51,35.81,5.20,0.94,0.07,0.55,0.03,0.51,0.00,0.00
Greek_Kos,12.13,5.57,19.98,20.06,34.34,6.16,0.31,0.54,0.10,0.18,0.40,0.14,0.08
Greek_Kythera,14.77,9.49,19.93,15.93,32.13,5.74,0.74,0.07,0.30,0.46,0.14,0.30,0.00
Greek_Laconia,18.84,15.11,20.50,12.63,26.97,4.43,0.31,0.44,0.26,0.14,0.28,0.01,0.07
Greek_Laconia_Karitsa,20.99,14.91,20.66,13.09,24.68,4.27,0.07,0.21,0.29,0.40,0.10,0.31,0.01
Greek_Lesbos,14.61,9.99,18.42,18.44,31.50,4.87,0.06,0.72,0.64,0.15,0.49,0.11,0.02
Greek_Messenia,18.78,15.09,21.04,13.10,27.21,2.99,0.43,0.41,0.29,0.28,0.32,0.06,0.00
Greek_Nisyros,14.49,5.02,19.94,18.20,34.34,5.49,0.33,0.12,0.15,0.43,0.57,0.43,0.50
Greek_Rhodes,10.04,3.54,21.36,19.05,38.25,6.00,0.22,0.19,0.34,0.15,0.59,0.27,0.00
Greek_Samos,17.74,10.86,20.44,17.69,27.34,4.03,0.11,0.42,0.17,0.00,0.64,0.01,0.56
Greek_Symi,10.31,3.21,20.58,19.40,38.22,5.84,0.72,0.03,0.46,0.17,0.46,0.50,0.10
Greek_Tsakonia,16.73,11.60,21.69,13.28,31.37,3.87,0.14,0.33,0.00,0.34,0.63,0.03,0.00

done.

[Jana]

If you want to only have one or max two averages in K13 Updated then you can put all Hungarian regional averages to the expanded sheet and only leave the Transylvanian average, since it is pretty unique. Maybe leave North Hungarian too, since it has a distance of 3 to the Hungarian average, but I don't know if that is enough to make it that unique?

Also if you decide to make broader averages for Greece, Italy and other countries, try to weigh them based on how much people those averages represent. Some of them represent ca. 300.000 people, while others ca. 2 million.

Left Hungarian, Transylvanian and Hungarian_North for now. Let me know if you want any further changes. I think keeping Hun north is okay for Hungary which has medium-sized population for Euro standards, and they are notably more Slavic.
that way it shows continuity towards Slovaks in the north Hungarian average does not have.

[Jana]

-removed all Bosniak averages except general and Sandžak
-removed all Hungarian averages except general, Transylvania and northern
-removed all Croatian regions, except general, added northern and southern
-removed Serbian/Montenegrin regions and updated their averages
-Aromanian average was updated
-deleted Greek regions and added all regions Vbn posted

what to do with Greece now?