New feature on Vahaduo "Reduce"

[Nino90]

You can choose to reduce your results with 3 or 4 or 5 samples. It will run the whole spreadsheet.

Here is my run choosing only 3 populations,

Average ancient spreadsheet:

Target: Nino_scaled
Distance: 1.7288% / 0.01728791 | R3P
51.6 VK2020_IRL_Eyrephort_VA
37.4 Levant_LBN_MA_o6
11.0 RUS_Chalmny-Varre

 

Distance to: RUS_Chalmny-Varre
0.02369731 Saami
0.03665417 Saami_Kola
0.05636610 Udmurt
0.05916953 Besermyan
0.06004001 Komi
0.07199194 Chuvash
0.07533794 Tatar_Kazan
0.08837482 Tatar_Mishar
0.09336764 Russian_Pinega
0.10212269 Vepsian
0.10353836 Mari
0.10418279 Tatar_Lipka
0.10441984 Finnish_East
0.10569644 Karelian
0.11829077 Mordovian
0.12019966 Russian_Kostroma
0.12085972 Ingrian
0.12227201 Finnish
0.12429533 Bashkir
0.13034534 Tatar_Crimean_steppe
0.13531331 Cossack_Kuban
0.14448755 Russian_Tver
0.14945439 Estonian
0.15248996 Russian_Kursk
0.15452163 Yukagir_Forest

Distance to: Levant_LBN_MA_o6
0.03274450 Spanish_Castello
0.03302779 Spanish_Girona
0.03335175 Spanish_Catalunya_Central
0.03388478 Spanish_Lleida
0.03399661 French_South
0.03410300 Spanish_Penedes
0.03430550 Spanish_Soria
0.03549204 Spanish_Pirineu
0.03599325 Spanish_Camp_de_Tarragona
0.03601201 Spanish_Peri-Barcelona
0.03702959 Spanish_Cataluna
0.03703637 Spanish_Aragon
0.03766928 Spanish_Valencia
0.03771176 Spanish_La_Rioja
0.03888655 Spanish_Terres_de_l'Ebre
0.03891527 Swiss_French
0.03893618 Spanish_Cantabria
0.03897419 Spanish_Baleares
0.03900541 French_Auvergne
0.03925571 Spanish_Navarra
0.03928462 Basque_Spanish
0.03945460 Spanish_Castilla_La_Mancha
0.03957171 Spanish_Barcelones
0.03984496 French_Occitanie
0.04000314 Spanish_Mallorca

Distance to: VK2020_IRL_Eyrephort_VA
0.03079046 Norwegian
0.03350856 Danish
0.03453286 Swedish
0.03512184 Dutch
0.03513752 Icelandic
0.03790994 Scottish
0.03815765 Welsh
0.03827452 Orcadian
0.03832658 Irish
0.03890785 Shetlandic
0.03928792 English
0.04215471 English_Cornwall
0.04281854 Afrikaner
0.04304110 German
0.04346988 French_Brittany
0.05174158 Belgian
0.05183907 Czech
0.05223493 Austrian
0.05234707 German_East
0.05238728 French_Pas-de-Calais
0.05443671 Slovakian
0.05490332 French_Nord
0.05541355 French_Seine-Maritime
0.05719650 Hungarian
0.05734836 French_Paris

And reduced to 3 populations:

Target: Nino_scaled
Distance: 2.3124% / 0.02312401 | R3P
61.4 Swedish
35.8 Spanish_Soria
2.8 Nganassan

Target: Nino_scaled
Distance: 2.2407% / 0.02240715 | R4P
47.2 Swedish
39.0 Spanish_Soria
9.0 Saami
4.8 Kubachinian

I am really impressed with the results. It choosed my Saami admixture and also realistic South European VS North. But Still Spanish instead of Italian.

[ThaYamamoto]

Yep been having fun with this, a really cool addition. Now for g25 coordinates we have this, classic nMonte type oracles, multiethnic nMonte [g25 studio] and of course randwulf's gradient by descent which keeps getting better and better. Wonderful.

[Kellebel]

Why am I not seeing this? I knew I was deaf, but have I become blind aswell now?

[firemonkey]

How do you do that? I can't see any instructions.

[ThaYamamoto]

Why am I not seeing this? I knew I was deaf, but have I become blind aswell now?

How do you do that? I can't see any instructions.

Its on here, it hasn't been patched on to the g25vahaduo site yet prolly cuz its experimental:

https://vahaduo.github.io/vahaduo/

you have to paste in your sources from the g25vahaduo page or your own sheets ofc

[Riverman]

It doesn't improve my results all too much. Pretty much the same for me, but good idea and generally useful.

[cvolt]

I tried it with the g25 modern spreadsheet for my dad and I ... Interesting lol

Target: cvoltsdad_scaled
Distance: 1.2960% / 0.01295956 | R3P
50.4 Irish
40.4 Slovakian
9.2 Basque_Spanish

Target: cvolt_scaled
Distance: 2.0925% / 0.02092460 | R3P
37.0 Icelandic
33.4 Swedish
29.6 Spanish_Soria

[Aroon1916]

A fun new feature. I tried it with the modern averages spreadsheet.

Target: Aroon_scaled
Distance: 1.2626% / 0.01262634 | R3P
49.8 English
33.2 Irish
17.0 Russian_Orel

Target: Aroon_scaled
Distance: 1.2511% / 0.01251101 | R4P
43.2 Irish
36.6 English
17.6 Russian_Orel
2.6 Italian_Lombardy

Target: Aroon_scaled
Distance: 1.2442% / 0.01244163 | R5P
53.0 Irish
24.0 English
11.0 Cossack_Ukrainian
6.8 Lithuanian_VZ
5.2 Italian_Lombardy

Target: AroonMom_scaled
Distance: 1.8411% / 0.01841125 | R3P
51.0 English_Cornwall
37.8 Orcadian
11.2 Russian_Smolensk

Target: AroonMom_scaled
Distance: 1.8406% / 0.01840646 | R4P
50.0 English_Cornwall
36.2 Orcadian
11.0 Russian_Smolensk
2.8 Shetlandic

Target: AroonMom_scaled
Distance: 1.8324% / 0.01832415 | R5P
56.0 English_Cornwall
29.2 Orcadian
10.0 Lithuanian_PZ
2.6 Spanish_Asturias
2.2 Kaitag

Target: AroonDad_scaled
Distance: 1.9360% / 0.01936017 | R3P
66.2 Norwegian
28.4 Spanish_Soria
5.4 Tabasaran

Target: AroonDad_scaled
Distance: 1.8872% / 0.01887210 | R4P
58.8 Norwegian
28.2 Spanish_Soria
8.4 Slovakian
4.6 Tabasaran

Target: AroonDad_scaled
Distance: 1.8891% / 0.01889086 | R5P
57.6 Norwegian
29.0 Spanish_Soria
8.8 Slovakian
4.6 Darginian

[MR J]

Interesting feature.

Target: J
Distance: 0.8924% / 0.00892414 | R3P
53.4 Shetlandic
41.2 French_Paris
5.4 Chuvash

Target: J
Distance: 0.8585% / 0.00858466 | R4P
55.0 Shetlandic
38.6 French_Paris
3.6 Mari
2.8 Bantu_Kenya

Target: J
Distance: 0.8399% / 0.00839933 | R5P
40.6 Shetlandic
35.4 French_Paris
18.2 Danish
3.4 Mari
2.4 Bantu_Kenya

[Seabass]

I bet if there was the option for 2, my results would be pretty bang on!

Target: Seabass_Dad_scaled
Distance: 1.8569% / 0.01856906 | R3P
63.8 Welsh
32.8 Irish
3.4 Spanish_Soria

Target: Seabass_scaled
Distance: 1.6647% / 0.01664671 | R3P
47.8 Spanish_Castilla_Y_Leon
29.8 Armenian
22.4 Shetlandic

Target: Seabass_Mum_scaled
Distance: 1.9188% / 0.01918830 | R3P
51.6 Italian_Lazio
39.8 Palestinian_Beit_Sahour
8.6 Berber_Tunisia_Chen