1. ME
Distance: 2.3049% / 0.02304880
Target: Vasil_scaled
87.9 Greek+Albanian
8.6 Balto_Slavic
2.4 Brahui+Balochi
1.1 Semitic

FRIEND

Distance: 2.5344% / 0.02534386
Target: Aleksander_scaled
60.8 Greek+Albanian
20.1 Balto_Slavic
10.1 Neolithic_Farmers
8.6 Semitic
0.4 Amerindian

2. ## The Following 2 Users Say Thank You to Vasile For This Useful Post:

Luso (06-19-2021),  Nino90 (01-09-2021)

3. Target: Celia_scaled
Distance: 3.0426% / 0.03042615
85.0 Iberian+Basques
7.2 NW_European+Beakers
4.0 Ethiopian+Somali+Iberomaurusian
3.4 Arabic
0.4 European_Hunters_Gatherers

4. ## The Following 3 Users Say Thank You to luasits For This Useful Post:

Luso (06-19-2021),  omgpeeps (06-16-2021),  Pedro Ruben (06-19-2021)

5. Originally Posted by michal3141
I've been playing with the following idea:

1. Take the Global25 scaled spreadsheet with all individuals
2. Apply k-means clustering algorithm to find K clusters for individuals in the spreadsheet
3. Label each cluster so that it has a meaningful name
4. Compute the average G25 coordinates for each cluster (take an average of coordinates belonging to all individuals in each cluster)
5. Compose a calculator based on these coordinates

I've chosen K=25 clusters and below is the calculator I've obtained based on the steps above (component names are subjective!):

Code:
```,PC1,PC2,PC3,PC4,PC5,PC6,PC7,PC8,PC9,PC10,PC11,PC12,PC13,PC14,PC15,PC16,PC17,PC18,PC19,PC20,PC21,PC22,PC23,PC24,PC25
Semitic,0.0905674640523,0.137912901961,-0.0551138300654,-0.0692887777778,-0.0214297254902,-0.0219595098039,0.00138392156863,-0.00539041176471,-0.012282130719,0.00223688888889,0.00519854901961,-0.00181309150327,0.00545578431373,0.00247454901961,-0.00601868627451,0.00327229411765,-0.000711607843137,0.000415653594771,0.00283518954248,-0.00250774509804,0.000574980392157,0.000962581699346,-0.00144995424837,-0.00131521568627,0.00111062745098
NW_European+Beakers,0.129666669492,0.131261487288,0.0623886991525,0.0535297224576,0.0366651525424,0.0191506716102,0.00401149788136,0.00544045338983,0.00249761652542,-0.00177911864407,-0.00493322457627,0.00443694491525,-0.0104491038136,-0.0112809639831,0.0212275635593,0.00639268220339,-0.00750705720339,0.00198757627119,0.00269692584746,0.00358536864407,0.00561904237288,0.00290740042373,-0.000372866525424,0.0100151271186,-0.000295046610169
Greek+Albanian,0.120008636364,0.143538444444,0.0194426565657,-0.0142707272727,0.0253566262626,-0.00633277777778,0.00143846464646,0.000881060606061,0.003543,0.0180027272727,-7.3797979798e-05,0.00312297979798,-0.00675282828283,0.00180437373737,-0.0117253737374,-0.000709808080808,0.00637427272727,0.00106213131313,0.0048311010101,-0.00423814141414,-0.00501384848485,0.00167737373737,0.00138808080808,8.50505050505e-06,-0.000951929292929
Maltese+European_Jewish,0.0945465376344,0.145930505376,-0.0177773548387,-0.0568792580645,0.00845137634409,-0.0206858817204,-0.00337595698925,-0.00278893548387,0.00878350537634,0.0211609784946,0.00471622580645,0.00205303225806,-0.000698559139785,-0.00069847311828,-0.00650288172043,-0.00212717204301,0.000713612903226,-0.00084864516129,-0.000609537634409,-0.00339412903226,-0.00303769892473,-0.00199307526882,0.00116760215054,0.000943279569892,0.000909032258065
NE_Asian,0.0451732263374,-0.369151226337,0.102191946502,0.00190742798354,-0.0969005349794,-0.0473964979424,-0.00867025514403,-0.00708702880658,0.0104652386831,0.00377522222222,0.0149718230453,0.000537794238683,-8.53909465021e-06,-0.00822223868313,-0.00840739917695,-0.00474265020576,-0.00127972427984,0.00513164197531,0.0138929917695,0.0098879382716,0.00367663374486,-0.0160687366255,0.00191518106996,0.00579538683128,0.00958931687243
Amerindian,0.0535519516129,-0.307443387097,0.115976766129,0.094785,-0.109640790323,-0.0170123387097,-0.286534790323,-0.342069443548,-0.0120437983871,-0.0158986451613,-0.00114851612903,-0.00214289516129,0.00120009677419,0.0218753709677,-0.00777873387097,0.00441287096774,0.00692926612903,8.175e-05,0.00202130645161,0.000519387096774,-0.00142889516129,0.00601908064516,-0.00143419354839,-0.000851217741935,-0.0016407016129
Finnish,0.126102171717,0.0731898787879,0.0863378080808,0.0740257272727,0.0225060909091,0.0214492424242,0.00964248484848,0.0140716767677,-0.000710707070707,-0.0284214444444,0.00465678787879,-0.00904343434343,0.0180614949495,0.00801131313131,-0.00616084848485,-0.0011611010101,-0.00218626262626,-0.000879141414141,-0.00136616161616,0.00090698989899,0.00350388888889,-0.00100290909091,0.00157231313131,0.000378535353535,0.00248807070707
North_Indian+Kalash,0.0671974036697,-0.0160807637615,-0.113611041284,0.079307809633,-0.0717649288991,0.0476851880734,0.00222226376147,0.00562079357798,0.00229056192661,-0.00183781651376,-0.00544483944954,7.45963302752e-05,-0.000855844036697,-0.00522650917431,0.00681123623853,0.00739336238532,-0.00108045642202,0.000302766055046,0.000759371559633,-0.00733208486239,-0.00130963302752,-0.00411230504587,0.00178229587156,-0.0013724587156,0.00124965825688
African,-0.589981211055,0.0610950653266,0.0127330050251,0.00778446231156,-0.000576814070352,0.00271184422111,0.0281410150754,-0.0157971557789,0.0139713115578,-0.0183215829146,-0.00320534170854,-0.00197913065327,-0.0109575477387,0.000568462311558,0.00539882914573,-0.00767153266332,0.00926315577889,0.0284342763819,-0.00581686934673,-0.00483397487437,-0.00334393467337,0.000449251256281,-0.00027932160804,-0.000772040201005,0.000969396984925
Caucasian,0.0991423832117,0.0912123175182,-0.0415382956204,-0.0187021715328,-0.0371949379562,0.000876346715328,0.00571303284672,-0.00359532846715,-0.0360469379562,-0.0176283430657,-0.000967222627737,0.00275230656934,-0.00500235766423,-0.00163840875912,0.00496123357664,0.000433562043796,0.000757105839416,-0.000417518248175,-0.00135651824818,0.000302624087591,0.000981839416058,-0.00117107664234,0.00036252189781,-0.00252119343066,0.000898094890511
Siberian_Turkic,0.0756485641026,-0.180982969231,0.0710823948718,0.037196374359,-0.0584202769231,-0.0104533948718,-0.000893082051282,0.000370374358974,-0.00613883076923,-0.0201123282051,0.00822854358974,-0.00329248205128,0.00803377948718,-0.0299834051282,-0.00321551794872,-0.00137958461538,-0.00390080512821,0.000869897435897,0.00297937948718,0.00226904615385,-0.0119328153846,0.00562843076923,0.00491345641026,-0.000512246153846,-0.00140506153846
Brahui+Balochi,0.0725053384615,0.0721417076923,-0.110629776923,0.0133523230769,-0.0893160076923,0.0231436384615,0.00710806153846,-0.00262535384615,-0.0531809,-0.0350902461538,-0.00162266153846,-0.000529138461538,0.000303030769231,-0.00849239230769,0.0184662769231,0.0293706615385,-0.00621632307692,0.00332314615385,0.00526284615385,-0.0233814461538,0.00147051538462,-0.0146014461538,-0.00166385384615,-0.0181229692308,0.0122134461538
Balto_Slavic,0.131969350575,0.124338149425,0.0746590862069,0.0667088390805,0.0401754022989,0.0247042931034,0.00958401149425,0.012037954023,-0.000465471264368,-0.0230580804598,-0.00219410344828,-0.00821597701149,0.0155914310345,0.0214272241379,-0.00807768965517,-0.000430517241379,0.000663149425287,-0.000250482758621,0.00261583333333,0.00158627011494,-0.00175267241379,-0.00320928735632,0.00576925287356,-0.00542787931034,0.000450747126437
Iberian+Basques,0.119217313043,0.14825846087,0.0451298347826,0.00100832173913,0.0491836782609,-0.00220689565217,-0.00193726086957,0.00218315652174,0.0257753478261,0.0359401304348,-0.00262644347826,0.00825960869565,-0.0166358086957,-0.0126313652174,0.00849843478261,-0.000119939130435,-0.0028321826087,0.000475852173913,-0.0010012,-0.00115160869565,0.00460923478261,0.000411834782609,-0.00399751304348,-0.0059095826087,0.000538330434783
Neolithic_Farmers,0.122342111801,0.178758372671,0.0147147826087,-0.0830411677019,0.0595217639752,-0.0402572919255,-0.00276894409938,-0.00305432919255,0.0407155093168,0.0818511925466,0.0060850310559,0.0126790807453,-0.0223572670807,0.000112838509317,-0.0359346645963,-0.00931588198758,0.0172244596273,0.00157298136646,0.0111902360248,-0.00989452173913,-0.00903453416149,0.00638539130435,-0.00593349689441,-0.0075068136646,-0.00393611180124
Neolithic_Northern_Europe,0.126215953271,0.167211158879,0.0548622523364,-0.0302986074766,0.085393317757,-0.0210288691589,-0.00406754205607,0.00285969158879,0.0614871121495,0.0854721214953,-0.000479607476636,0.0128241308411,-0.0282400280374,-0.0140194859813,-0.00707269158879,0.00444605607477,0.0110777383178,0.00328563551402,0.00283465420561,-0.0017776728972,0.0126575233645,0.00330046728972,-0.0156743084112,-0.0352487757009,3.46728971963e-05
Arabic,0.00925723404255,0.139899968085,-0.0416517925532,-0.0994277659574,0.00289417553191,-0.0428349414894,-0.0169032553191,-0.0023812287234,0.0525756755319,0.00870180319149,0.0113023723404,-0.0184001170213,0.040627106383,-0.00198089361702,0.00579841489362,0.00765136702128,-0.0101901010638,-0.0043289893617,-0.0127877925532,0.0153391170213,0.00107659574468,-0.00266838297872,0.00394130319149,0.00145746808511,-0.00171468085106
Ethiopian+Somali+Iberomaurusian,-0.295751913386,0.0917734488189,-0.0272684724409,-0.0673696614173,0.0015024015748,-0.0333768425197,-0.00911919685039,-0.00353406299213,0.107966055118,-0.0711208661417,-0.00580252755906,-0.00906041732283,0.007117,-0.00212719685039,0.0241881259843,-0.0165966377953,0.0151697007874,0.00122297637795,0.00189636220472,-0.00136973228346,0.000506992125984,0.000431307086614,-0.000428921259843,0.000479133858268,-0.000534622047244
Sintashta+Srubnaya+Kangju,0.121943371951,0.0984135,0.051601152439,0.0772029207317,0.00205845121951,0.0285913963415,0.00356948170732,0.00301393902439,-0.019687902439,-0.0311723597561,-0.00199121341463,0.00035456097561,-0.00257345121951,-0.0212014512195,0.0223988292683,0.0123324390244,-0.00458330487805,-0.000386237804878,-0.000466768292683,0.00153351219512,-0.00491892682927,0.00277765243902,0.00120765853659,0.00715999390244,-0.00213576219512
European_Hunters_Gatherers,0.129548,0.104985847826,0.172610532609,0.182826021739,0.108943369565,0.0550445326087,0.00870054347826,0.0239412934783,0.053187326087,-0.0213533152174,-0.00509933695652,-0.0172965434783,0.0259380869565,-0.00544056521739,0.0333709891304,0.0453701304348,0.00313342391304,0.00462273913043,-0.00643925,0.0425353804348,0.0616005326087,0.0116851847826,-0.0267018695652,-0.107186391304,0.00906581521739
Central_European,0.127216885246,0.136740190164,0.0513613508197,0.0291886098361,0.0376452754098,0.0102257081967,0.0042948295082,0.00502146557377,0.00567101639344,0.00725716065574,-0.00309763934426,0.00282242622951,-0.00686030163934,-0.00217398688525,0.00553560983607,0.00270440327869,-0.00093406557377,0.000989832786885,0.00320097704918,0.0011349442623,0.000985504918033,0.00120327213115,0.000258639344262,0.00422884918033,-0.000459350819672
South_Asian,0.00644757366771,-0.205862777429,-0.162883025078,0.116968244514,-0.00694794357367,0.0139576426332,-0.00406356112853,0.0110149435737,0.0589355956113,0.0376788746082,0.0033363322884,0.00105607210031,-0.00140040125392,0.00861154858934,-0.0154125736677,-0.0159468934169,0.009084,-0.00157821943574,-0.00324847021944,0.0190832225705,0.00226715673981,0.0117059247649,-0.00414176489028,0.00493693416928,0.00225759874608
East_Asian,0.0169115098814,-0.415090632411,-0.0364033399209,-0.0425287588933,0.0872707233202,0.0393886442688,0.000528505928854,-0.00422935968379,-0.00851317786561,-0.00420296047431,-0.0036791027668,-0.000952513833992,0.00112402371542,-0.00174939525692,-0.000678541501976,-0.000578604743083,0.000843162055336,0.000298940711462,-0.00136082608696,-0.00194014229249,0.0025537826087,0.00317193675889,0.00333839525692,-0.000333407114625,8.09288537549e-05
Uralic,0.0977504597701,-0.0288083505747,0.0568173563218,0.0552534195402,-0.0261657356322,0.00826096551724,0.00351564942529,0.00469475862069,-0.0105012413793,-0.0268358563218,0.00690060344828,-0.00471563793103,0.00943995402299,-0.0212160057471,0.000597477011494,0.000151643678161,-0.00390550574713,-0.00063124137931,-0.00490798850575,-0.00303233908046,-0.00314029885057,0.00246168390805,-0.00422297126437,0.00205879885057,-0.000928327586207
Yamnaya+Afanasievo+EHG,0.119403611111,0.0540204861111,0.0618268888889,0.138392986111,-0.0368871666667,0.0466289722222,-0.00882277777778,-0.0140154444444,-0.0433419583333,-0.0772174722222,0.00695563888889,-0.00382369444444,0.00808956944444,-0.0339354583333,0.0322203472222,0.0149641666667,-0.00651740277778,-0.00266927777778,-0.00350206944444,0.00934820833333,-0.009906125,0.005155625,0.0135573333333,0.0118556666667,-0.004445625```
I think it is a fun calculator with both modern and ancient components.

My results.

with pen=0 (the best fit):

[1] "distance%=2.6273"

michal3141

Balto_Slavic,80.2
Neolithic_Farmers,8.4
Yamnaya+Afanasievo+EHG,7.8
European_Hunters_Gatherers,1.4
Siberian_Turkic,1.2
Arabic,0.8
Finnish,0.2

with pen=0.001 (default, predominately modern populations):

[1] "distance%=2.7295"

michal3141

Balto_Slavic,78.4
Finnish,8.4
Central_European,4.2
Greek+Albanian,1.4
Yamnaya+Afanasievo+EHG,1.4
Maltese+European_Jewish,1.2
Neolithic_Farmers,1.2
Sintashta+Srubnaya+Kangju,1
Semitic,0.8
Neolithic_Northern_Europe,0.6
Uralic,0.6
Arabic,0.2
Brahui+Balochi,0.2
Caucasian,0.2
European_Hunters_Gatherers,0.2
Target: Ancestry_scaled
Distance: 1.7748% / 0.01774837
92.6 NW_European+Beakers
4.6 Neolithic_Northern_Europe
1.6 Finnish
1.0 Uralic
0.2 Neolithic_Farmers

Target: Ancestry_scaled
Distance: 1.7777% / 0.01777694
92.0 NW_European+Beakers
4.4 Neolithic_Northern_Europe
3.2 Finnish
0.4 Neolithic_Farmers

6. ## The Following User Says Thank You to lana6765 For This Useful Post:

omgpeeps (06-16-2021)

7. Target:
Distance: 1.3455% / 0.01345479
47.4 NW_European+Beakers
37.8 Caucasian
6.2 Neolithic_Farmers
5.8 Brahui+Balochi
1.8 East_Asian
1.0 Greek+Albanian

8. ## The Following 2 Users Say Thank You to 06lab For This Useful Post:

Luso (06-19-2021),  omgpeeps (06-16-2021)

9. I'm not sure if I tried this one, but here I go =)

Target: cpalscaled
Distance: 2.7495% / 0.02749471
88.6 Central_European
6.0 Yamnaya+Afanasievo+EHG
3.2 Balto_Slavic
1.2 Neolithic_Farmers
1.0 Finnish

Distance to: cpalscaled
0.03004914 Central_European
0.04138178 NW_European+Beakers
0.06842827 Balto_Slavic
0.07355590 Iberian+Basques
0.07681431 Greek+Albanian
0.08485156 Sintashta+Srubnaya+Kangju
0.09505034 Finnish
0.13665378 Maltese+European_Jewish
0.15218927 Caucasian
0.15555967 Neolithic_Northern_Europe
0.17480911 Semitic
0.18247300 Neolithic_Farmers
0.18355173 Uralic
0.18674553 Yamnaya+Afanasievo+EHG
0.22957123 Arabic
0.24224038 Brahui+Balochi
0.26456172 North_Indian+Kalash
0.26761695 European_Hunters_Gatherers
0.33624807 Siberian_Turkic
0.43888897 South_Asian
0.47125759 Ethiopian+Somali+Iberomaurusian
0.53382063 NE_Asian
0.57559295 East_Asian
0.66164901 Amerindian
0.72954828 African

10. ## The Following 3 Users Say Thank You to omgpeeps For This Useful Post:

AbideInLove (06-19-2021),  Luso (06-19-2021),  Mr.G (06-16-2021)

11. why the hell does Finnish keep popping up on all these calculators...

Target: Luso_scaled
Distance: 2.4733% / 0.02473348
82.0 Iberian+Basques
7.2 Maltese+European_Jewish
5.2 Ethiopian+Somali+Iberomaurusian
5.0 Finnish
0.4 Neolithic_Farmers
0.2 Arabic

12. ## The Following 2 Users Say Thank You to Luso For This Useful Post:

AbideInLove (06-19-2021),  Pedro Ruben (06-19-2021)

13. Originally Posted by Luso
why the hell does Finnish keep popping up on all these calculators...

Target: Luso_scaled
Distance: 2.4733% / 0.02473348
82.0 Iberian+Basques
7.2 Maltese+European_Jewish
5.2 Ethiopian+Somali+Iberomaurusian
5.0 Finnish
0.4 Neolithic_Farmers
0.2 Arabic
Probably reflecting the “extremes” of your genome- the “Finnish” is probably selected for some very ancient pan-European genes..

This calculator seems cool! If some cool individual could run my mother's coordinates, I'd appreciate that somethin' aweful.

,PC1,PC2,PC3,PC4,PC5,PC6,PC7,PC8,PC9,PC10,PC11,PC1 2,PC13,PC14,PC15,PC16,PC17,PC18,PC19,PC20,PC21,PC2 2,PC23,PC24,PC25
Audrey_scaled,0.12862,0.127957,0.061094,0.04522,0. 035083,0.019522,0.011281,0.014076,0.005318,-0.008018,-0.003573,-0.005695,0.006392,0.008808,-0.000679,0.000133,-0.00013,-0.003927,0.00352,0.005127,-0.007861,-0.000989,-0.000616,0.003494,0.001197

,PC1,PC2,PC3,PC4,PC5,PC6,PC7,PC8,PC9,PC10,PC11,PC1 2,PC13,PC14,PC15,PC16,PC17,PC18,PC19,PC20,PC21,PC2 2,PC23,PC24,PC25
Audrey,0.0113,0.0126,0.0162,0.014,0.0114,0.007,0.0 048,0.0061,0.0026,-0.0044,-0.0022,-0.0038,0.0043,0.0064,-0.0005,0.0001,-0.0001,-0.0031,0.0028,0.0041,-0.0063,-0.0008,-0.0005,0.0029,0.001

14. ## The Following User Says Thank You to AbideInLove For This Useful Post:

Luso (06-19-2021)

Distance: 1.7554% / 0.01755376
80.2 North_Indian+Kalash
17.4 Brahui+Balochi
2.4 NW_European+Beakers

Target: Kapisa_Mom_scaled
Distance: 2.4979% / 0.02497907
82.4 North_Indian+Kalash
16.6 Brahui+Balochi
1.0 Balto_Slavic

Target: Kapisa_scaled
Distance: 1.7646% / 0.01764640
83.4 North_Indian+Kalash
15.4 Brahui+Balochi
1.0 Balto_Slavic
0.2 African

16. ## The Following User Says Thank You to Kapisa For This Useful Post:

Hurricane (06-19-2021)

17. Maternal grandparents and i

Target: Milka_scaled
Distance: 2.4908% / 0.02490831
62.2 Balto_Slavic
24.6 Neolithic_Farmers
13.2 Semitic

Target: Miodrag_scaled
Distance: 1.8443% / 0.01844290
52.6 Balto_Slavic
30.2 Neolithic_Farmers
6.6 Semitic
5.4 Finnish
5.2 Brahui+Balochi

Target: nikola_scaled
Distance: 2.6302% / 0.02630206
63.4 Balto_Slavic
19.4 Neolithic_Farmers
17.2 Semitic

18. grandma

Target: boilermeschew827grandma_scaled
Distance: 2.0204% / 0.02020384
66.2 NW_European+Beakers
11.4 Neolithic_Northern_Europe
10.8 Iberian+Basques
10.8 Neolithic_Farmers
0.8 African

myself

Target: boilermeschew827_scaled
Distance: 1.6463% / 0.01646310
46.0 NW_European+Beakers
44.2 Balto_Slavic
4.0 Neolithic_Northern_Europe
2.0 Neolithic_Farmers
1.8 European_Hunters_Gatherers
1.4 East_Asian
0.6 South_Asian

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•