G25 Post Your Breakdown Using Scaled Moderns Spreadsheet

[Defcon2]

Como se hace eso de Spoiler, que el texto solo se despliega cuando lo abres?

Intenté mandarte las coordenadas por el correo interno este, pero no permite textos tan largos.

Y no te piques tanto, que es una chorrada

Para hacer el spoiler es:

[*SPOILER][/SPOILER*] quitando *

https://drive.google.com/file/d/1wZr...CQncZWb8y/view

What do you say, you will have problems with the internet.


Grace's link is perfectly google

Vayamos por partes, intenta ejecutar tus coordenadas con otra calculadora y lo publicas (escaladas):

http://g25vahaduo.genetics.ovh/0-100...Calculator.htm

Si te funciona es que el problema no son tus coordenadas.

[Thracian]

Well, obviously using individuals and removing outliers make the model more accurate. Anyway I just used regular modern pop average SS,

Target: Thracian_scaled
Distance: 2.7359% / 0.02735852 | ADC: 2x
100.0 Turkish_Balkans

Target: Thracian_scaled
Distance: 2.2240% / 0.02223993 | ADC: 1x
86.0 Turkish_Balkans
10.6 Greek_Izmir
3.4 Greek_Peloponnese

Target: Thracian_scaled
Distance: 1.8494% / 0.01849384 | ADC: 0.5x
72.0 Turkish_Balkans
23.4 Greek_Peloponnese
4.6 Ezid

Target: Thracian_scaled
Distance: 1.3982% / 0.01398170 | ADC: 0.25x
49.8 Turkish_Balkans
33.2 Greek_Peloponnese
6.0 Tarkalani
5.0 Swiss_French
3.4 Tabasaran
1.4 Slovakian
1.2 Saudi

[JamesBond007]

Well, obviously using individuals and removing outliers make the model more accurate. Anyway I just used regular modern pop average SS,

Target: Thracian_scaled
Distance: 2.7359% / 0.02735852 | ADC: 2x
100.0 Turkish_Balkans

Target: Thracian_scaled
Distance: 2.2240% / 0.02223993 | ADC: 1x
86.0 Turkish_Balkans
10.6 Greek_Izmir
3.4 Greek_Peloponnese

Target: Thracian_scaled
Distance: 1.8494% / 0.01849384 | ADC: 0.5x
72.0 Turkish_Balkans
23.4 Greek_Peloponnese
4.6 Ezid

Target: Thracian_scaled
Distance: 1.3982% / 0.01398170 | ADC: 0.25x
49.8 Turkish_Balkans
33.2 Greek_Peloponnese
6.0 Tarkalani
5.0 Swiss_French
3.4 Tabasaran
1.4 Slovakian
1.2 Saudi

Oh, snap, I used the population averages rather than individuals. I don't see much of a point of using individuals per se.

Target: Kevin_scaled
Distance: 1.5189% / 0.01518900 | ADC: 1x
31.8 Norwegian
26.2 Irish
24.0 Welsh
8.6 Belgian
5.6 Dutch
3.2 English_Cornwall
0.6 Orcadian

This is bullshit bro how can I model myself after one sample from each nation ? I only get two samples with the Welsh. The scaled population averages are better but not perfect :

Distance: 1.5189% / 0.01518900 | ADC: 1x
31.8 Norwegian:NOR106
26.2 Irish:Irish26
13.8 Welsh:WalesCHF12
10.2 Welsh:WalesCHF13
8.6 Belgian:Belgium17
5.6 Dutch:Netherlands17
3.2 English_Cornwall:HG00255
0.6 Orcadian:HGDP00805

I get the most matches for Wales and England together that is the only way I can make sense this clusterfuck :

Distance to: Kevin_scaled
0.02408176 Norwegian:NOR106
0.02479753 Irish:Irish26
0.02566296 Orcadian:HGDP00802
0.02694941 Welsh:WalesCHF12
0.02699124 English_Cornwall:HG00255
0.02731905 Welsh:WalesCHF13
0.02756434 English_Cornwall:HG00249
0.02768220 English_Cornwall:HG00264
0.02799287 Irish:Irish62
0.02823165 Welsh:WalesBK58
0.02833929 Scottish:Scottish13
0.02867120 English:England15
0.02878174 Orcadian:HGDP00805
0.02878447 Orcadian:HGDP00804
0.02881169 Welsh:WalesCHF63
0.02929639 English:English6
0.02931874 Welsh:WAL004
0.02932614 Irish:Irish54
0.02968087 Irish:Irish43
0.02981643 English:HG01791
0.02987688 Scottish:Scottish27
0.03001582 French_Brittany:French23989
0.03018128 Belgian:Belgium17
0.03035180 English_Cornwall:HG00243
0.03063317 Dutch:Netherlands57

[Thracian]

Oh, snap, I used the population averages rather than individuals. I don't see much of a point of using individuals per se.

Target: Kevin_scaled
Distance: 1.5189% / 0.01518900 | ADC: 1x
31.8 Norwegian
26.2 Irish
24.0 Welsh
8.6 Belgian
5.6 Dutch
3.2 English_Cornwall
0.6 Orcadian

This is bullshit bro how can I model myself after one sample from each nation ? I only get two samples with the Welsh. The scaled population averages are better but not perfect :

Distance: 1.5189% / 0.01518900 | ADC: 1x
31.8 Norwegian:NOR106
26.2 Irish:Irish26
13.8 Welsh:WalesCHF12
10.2 Welsh:WalesCHF13
8.6 Belgian:Belgium17
5.6 Dutch:Netherlands17
3.2 English_Cornwall:HG00255
0.6 Orcadian:HGDP00805

I get the most matches for Wales and England together that is the only way I can make sense this clusterfuck :

Distance to: Kevin_scaled
0.02408176 Norwegian:NOR106
0.02479753 Irish:Irish26
0.02566296 Orcadian:HGDP00802
0.02694941 Welsh:WalesCHF12
0.02699124 English_Cornwall:HG00255
0.02731905 Welsh:WalesCHF13
0.02756434 English_Cornwall:HG00249
0.02768220 English_Cornwall:HG00264
0.02799287 Irish:Irish62
0.02823165 Welsh:WalesBK58
0.02833929 Scottish:Scottish13
0.02867120 English:England15
0.02878174 Orcadian:HGDP00805
0.02878447 Orcadian:HGDP00804
0.02881169 Welsh:WalesCHF63
0.02929639 English:English6
0.02931874 Welsh:WAL004
0.02932614 Irish:Irish54
0.02968087 Irish:Irish43
0.02981643 English:HG01791
0.02987688 Scottish:Scottish27
0.03001582 French_Brittany:French23989
0.03018128 Belgian:Belgium17
0.03035180 English_Cornwall:HG00243
0.03063317 Dutch:Netherlands57

My point is some samples are outliers and they are not representative for their ethnicities. For example let's check Macedonian:Macedonian3,

Distance to: Macedonian:Macedonian3
0.03285317 Bosnian
0.03337958 Slovenian
0.03340071 Croatian
0.03406851 Serbian
0.03973720 Montenegrin
0.03991260 Hungarian
0.04036597 Macedonian
0.04274561 Romanian
0.04597825 Austrian
0.04625368 Bulgarian
0.04845648 German_East
0.04886465 Moldavian
0.04897031 Czech
0.04989305 Gagauz
0.05326171 Moldavian_o
0.05683744 Polish
0.05724114 Ukrainian
0.05742594 Slovakian
0.05753032 Italian_Northeast
0.05758468 French_Alsace
0.05760442 German
0.05798502 Greek_Thrace
0.05958287 Italian_Aosta_Valley
0.06052460 Sorb_Niederlausitz
0.06163370 Cossack_Ukrainian

0.04036597 to Macedonian is a pretty big distance. So, I do not believe that this sample is useful for Macedonian average because it makes the average slightly northwestern shifted. So, removing this sample and using rest of Macedonian samples make the model more accurate.Maybe I am wrong but I can get more accurate results in this way.

[xripkan]

Well, obviously using individuals and removing outliers make the model more accurate. Anyway I just used regular modern pop average SS,

Target: Thracian_scaled
Distance: 2.7359% / 0.02735852 | ADC: 2x
100.0 Turkish_Balkans

Target: Thracian_scaled
Distance: 2.2240% / 0.02223993 | ADC: 1x
86.0 Turkish_Balkans
10.6 Greek_Izmir
3.4 Greek_Peloponnese

Target: Thracian_scaled
Distance: 1.8494% / 0.01849384 | ADC: 0.5x
72.0 Turkish_Balkans
23.4 Greek_Peloponnese
4.6 Ezid

Target: Thracian_scaled
Distance: 1.3982% / 0.01398170 | ADC: 0.25x
49.8 Turkish_Balkans
33.2 Greek_Peloponnese
6.0 Tarkalani
5.0 Swiss_French
3.4 Tabasaran
1.4 Slovakian
1.2 Saudi

can you post without add dist col?

[Thracian]

can you post without add dist col?

Target: Thracian_scaled
Distance: 0.7907% / 0.00790727
52.0 Greek_Peloponnese
15.6 Cossack_Kuban
7.6 Kho_Singanali
4.8 Norwegian
4.6 Tabasaran
4.0 Palestinian_Beit_Sahour
3.6 Abazin
3.2 Saudi
2.4 Spanish_La_Rioja
0.6 Indonesian_Java
0.6 Pulliyar
0.4 Brahmin_Tamil_Nadu
0.4 Slovakian
0.2 Ju_hoan_North

[Kaspias]

Target: Kaspias_scaled
Distance: 3.2650% / 0.03264975 | ADC: 2x
100.0 Turkish_Balkans

Target: Kaspias_scaled
Distance: 3.2650% / 0.03264975 | ADC: 1x
100.0 Turkish_Balkans

Target: Kaspias_scaled
Distance: 2.6762% / 0.02676159 | ADC: 0.5x
90.2 Turkish_Balkans
6.0 Turkmen_Uzbekistan
3.2 Jordanian
0.6 Azeri

Target: Kaspias_scaled
Distance: 2.1841% / 0.02184106 | ADC: 0.25x
83.2 Turkish_Balkans
11.4 Palestinian_Beit_Sahour
2.2 Selkup
1.6 Itelmen
1.4 Turkmen_Uzbekistan
0.2 Tabasaran

Target: Kaspias_scaled
Distance: 1.4616% / 0.01461624
37.0 Greek_Peloponnese
20.8 Cossack_Kuban
17.4 Palestinian_Beit_Sahour
9.4 Tabasaran
3.4 Itelmen
3.0 Altaian
3.0 Mountain_Jew_Chechnya
2.0 Shor_Khakassia
1.6 Spanish_Soria
1.0 Mansi
0.6 Luhya_Kenya
0.4 Papuan
0.4 Selkup




Target: Kaspias_Cousin
Distance: 2.8184% / 0.02818441 | ADC: 2x
100.0 Turkish_Balkans

Target: Kaspias_Cousin
Distance: 2.8184% / 0.02818441 | ADC: 1x
100.0 Turkish_Balkans

Target: Kaspias_Cousin
Distance: 2.3752% / 0.02375214 | ADC: 0.5x
88.2 Turkish_Balkans
5.6 Moroccan_Jew
3.2 Azeri
1.8 Turkmen_Uzbekistan
1.2 Roma_Porto

Target: Kaspias_Cousin
Distance: 1.7299% / 0.01729920 | ADC: 0.25x
74.6 Turkish_Balkans
12.2 Palestinian_Beit_Sahour
6.8 Spanish_Soria
1.8 Roma_Porto
1.8 Sakha
1.6 Kho_Singanali
0.6 Cree
0.4 Turkmen_Uzbekistan
0.2 Tarkalani

Target: Kaspias_Cousin
Distance: 1.0152% / 0.01015240
26.2 Greek_Peloponnese
22.0 Palestinian_Beit_Sahour
12.6 Slovakian
12.4 Spanish_Soria
8.2 Kho_Singanali
6.8 Lithuanian_VA
4.6 Abazin
4.6 Sakha
1.0 Nivkh
0.8 Bosnian
0.4 Aymara
0.2 Cree
0.2 Igorot

[Freeroostah]

[xripkan]

Mine
Distance: 1.8156% / 0.01815583
45.8 Albanian
29.8 Greek_Peloponnese
11.6 Greek_Crete
4.2 Macedonian
3.6 Karaite_Egypt
2.2 Greek_Thrace
1.8 Mari
0.4 Pulliyar
0.4 Sardinian
0.2 Tibetan

Distance: 1.8432% / 0.01843154 | ADC: 0.25x
52.4 Albanian
27.0 Greek_Peloponnese
15.4 Greek_Crete
4.0 Turkish_Balkans
1.0 Mari
0.2 Pulliyar

Distance: 1.9422% / 0.01942219 | ADC: 0.5x
51.2 Albanian
28.8 Greek_Izmir
15.6 Greek_Peloponnese
3.8 Turkish_Balkans
0.6 Ashkenazi_Russia

Distance: 2.0268% / 0.02026834 | ADC: 1x
55.4 Albanian
35.0 Greek_Peloponnese
9.6 Greek_Izmir

Distance: 2.0650% / 0.02064968 | ADC: 2x
61.4 Albanian
38.6 Greek_Peloponnese

[Ljubic]

Target: Ljubic
Distance: 1.5244% / 0.01524428 | ADC: 0.25x
30.0 Slovenian
27.0 Bosnian
27.0 Macedonian
9.6 Serbian
3.2 Montenegrin
3.0 Lithuanian_RA
0.2 BedouinB

Distance to: Ljubic
0.01832337 Bosnian
0.02141029 Montenegrin
0.02214832 Serbian
0.02433875 Croatian
0.02526973 Slovenian
0.02894077 Romanian
0.02983512 Macedonian
0.03016420 Hungarian
0.03413364 Austrian
0.03695227 Bulgarian
0.03856575 Moldavian
0.04304294 Czech