Estimating ancient genes among present-day European populations, part 2

Following my obvious quideline I substituted the Scandinavian hunter-gatherer group by Hungarian Neolithic hunter-gatherer (KO1).  My goal was to find out possible difference in relations between Yamnaya and both hunter-gatherer groups.   I thought that he result could reveal ancient migrations.   Indeed, the result shows possible genetic connection between Yamnaya, Corded Ware and Scandinavian cultures, which is of course reasonable from the historical perspective. The Hungarian hunter-gatherer looks more like belonging to some more southern diverged populations. 

I appreciate if someone with good mathematic skills could make a correlation analysis between all four groups and paying attention to differences between Excel-sheets, I myself am happy to see how tightly Yamnaya, Corded Ware and Scandinavian HG groups correlate.  It looks definitely like substituting Scandinavian HG's by the Hungarian one moves all Scandinavian similarity to the Corded Ware culture.  Drawing speculative conclusions I would say that also early animal husbandry connects these regions.  One of the most interesting questions is now related to new finds of ancient  yDna from the East European plain. 


Corded-Ware-LN
- Yamnaya 0.68
- Hun. farmer 0.175
- SC-HG    0.138

Corded-Ware-LN
- Yamnaya 0.804
- Hun. farmer 0.125
- Hun. HG 0.067

This same continuity between Yamnaya, Corded Ware and North Europe is observable widely among all North Europeans.

Download my earlier xls-sheet here
Download my new xls-sheet here

Next I try to estimate Eastern Hunter-Gatherers.  Possible eastern sinilarity with present-day populations would be interesting.

edit 22.03.15   Adding Karelian Hunter-Gatherer as a fifth admixture proportion decreased chisq (below 1 at best) in Northeast Europe, meaning a better fit. Concurrently the proportion of Hungarian Neolithic farmers in same results increased, as compensation to increased hunter-gatherer proportion.  This all was reasonable and expected.  But in the south the transition was minimal, for example Basques had no ancient Karelian admix and actually nothing changed.   This all looks so expected.  Incredible!     The biggest issue I have now, after the next update, is to find the lost South European admixture.