Include me next time please!Quote:
Originally Posted by Mazik
Printable View
Include me next time please!Quote:
Originally Posted by Mazik
Quote:
Originally Posted by Graham
There is only one 'North', the True North:cool::p
http://i.imgur.com/YuoEGOJ.jpg
You should flip the map upside down, haha.
The PCA looks like a Nordic flag :p
You two are my long lost cousins, i knew there was something to the long-face club!Quote:
Originally Posted by Graham
Edit: It's interesting that my father and grandfather cluster further away from Scandinavians than i do, it should be the other way around really.
Is it possible to do one with EUtest as well, out of curiosity? I might have to try this myself if i ever work it out, looks fun.
I will :thumb001:Quote:
Originally Posted by Loki
Good idea :) yes it's possible, I think it would be even better actually.Quote:
Originally Posted by Jackson
Download xlstat for excel and follow this tutorial :)Quote:
Originally Posted by Jackson
http://www.youtube.com/watch?v=FgLn-w6ijak
Cheers! :)Quote:
Originally Posted by Mazik
Also i can include data for my grandmother, and my mother and aunt if you want as well?
Sure :)Quote:
Originally Posted by Jackson
Did you want their K36 or EUtest? I think i have them in this thread somewhere but i will dig them out.Quote:
Originally Posted by Mazik
K36 for now.Quote:
Originally Posted by Jackson
Ok am just re-running them on GEDmatch.Quote:
Originally Posted by Mazik
Amerindian -
Arabian 1.64%
Armenian 4.46%
Basque 0.98%
Central_African -
Central_Euro 8.46%
East_African 1.31%
East_Asian -
East_Balkan 2.11%
East_Central_Asian -
East_Central_Euro 4.68%
East_Med 6.16%
Eastern_Euro 5.13%
Fennoscandian 5.07%
French 7.60%
Iberian 9.59%
Indo-Chinese -
Italian 12.42%
Malayan -
Near_Eastern 5.14%
North_African 1.06%
North_Atlantic 2.68%
North_Caucasian 6.03%
North_Sea 13.25%
Northeast_African -
Oceanian -
Omotic -
Pygmy -
Siberian -
South_Asian -
South_Central_Asian -
South_Chinese -
Volga-Ural 0.35%
West_African -
West_Caucasian -
West_Med 1.87%
Grandmother:
Amerindian -
Arabian -
Armenian -
Basque 0.09%
Central_African -
Central_Euro 5.99%
East_African -
East_Asian -
East_Balkan 3.65%
East_Central_Asian -
East_Central_Euro 7.75%
East_Med -
Eastern_Euro 3.49%
Fennoscandian 4.06%
French 8.54%
Iberian 18.83%
Indo-Chinese -
Italian 7.39%
Malayan -
Near_Eastern -
North_African -
North_Atlantic 15.78%
North_Caucasian -
North_Sea 22.45%
Northeast_African -
Oceanian -
Omotic -
Pygmy -
Siberian -
South_Asian -
South_Central_Asian -
South_Chinese -
Volga-Ural 0.80%
West_African -
West_Caucasian -
West_Med 1.17%
Mother:
Amerindian -
Arabian -
Armenian -
Basque 3.98%
Central_African -
Central_Euro 6.90%
East_African -
East_Asian -
East_Balkan 5.77%
East_Central_Asian -
East_Central_Euro 10.19%
East_Med -
Eastern_Euro 5.35%
Fennoscandian 5.23%
French 5.58%
Iberian 8.55%
Indo-Chinese -
Italian 8.27%
Malayan -
Near_Eastern -
North_African -
North_Atlantic 14.27%
North_Caucasian 1.45%
North_Sea 17.07%
Northeast_African -
Oceanian -
Omotic -
Pygmy -
Siberian -
South_Asian -
South_Central_Asian 1.19%
South_Chinese -
Volga-Ural -
West_African -
West_Caucasian 4.44%
West_Med 1.76%
Aunt:
Amerindian 0.15%
Arabian -
Armenian -
Basque 2.27%
Central_African -
Central_Euro 3.90%
East_African -
East_Asian -
East_Balkan 4.59%
East_Central_Asian -
East_Central_Euro 12.56%
East_Med -
Eastern_Euro 3.65%
Fennoscandian 7.94%
French 2.96%
Iberian 12.98%
Indo-Chinese -
Italian 12.54%
Malayan -
Near_Eastern -
North_African -
North_Atlantic 14.53%
North_Caucasian -
North_Sea 18.82%
Northeast_African -
Oceanian -
Omotic -
Pygmy -
Siberian -
South_Asian -
South_Central_Asian -
South_Chinese -
Volga-Ural -
West_African -
West_Caucasian 2.36%
West_Med 0.71%
I follow the instructions and get this message:Quote:
Originally Posted by Mazik
Incompatible number of rows between the two selections. Please make sure the selections have the same number of rows. If there are missing data at the end of the selection, you should use the range selection mode instead of the columns selection mode. Please modify the selection.
Not quite sure what it means.
Edit:
Or i get this if i do it exactly how it is done on the video:
The selection contains non-numerical data, while it is expected to contain only numerical data. (first case found in cell $B$2).
- Click "Back" to go back to the dialog box and modify the options or the data selection.
- Click "Cancel" to cancel the procedure.
Cool map. If Mark was included on here, he would be close to me, I think.:thumb001:Quote:
Originally Posted by MfA_
Quote:
Originally Posted by Jackson
Do you use a "," or "." in for your numerical values? You must use "," for them.
It's ok it turned out i just forgot to put in an extra row somewhere. I made a PCA from EUtest with just my family, looks alright, but will need to look for other's results to add! :)Quote:
Originally Posted by Mazik
http://www.theapricity.com/forum/sho...=1#post1349953Quote:
Originally Posted by Jackson
:D
Shame it doesn't have all the numbers, am looking through this thread now to find the individual results. :DQuote:
Originally Posted by Mazik
I have quite a few on the list now, i'm including everybody i find, should be weird and interesting. Amerinese might be in his own camp though i think. :P
I can add Mark and others who weren't included if they provide me their results :)Quote:
Originally Posted by FairyPrincess
I think I posted mine as well, but is forgotten :(Quote:
Originally Posted by MfA_
I will get the data again.
I need Loki, Pallantides and Evon's family EUtest (the most recent one from GEDmatch) as i can't find them anywhere. I might make a plot now to see how it looks and make another with them in it later.
My Eutest:
SOUTH_BALTIC 17.22%
EAST_EURO 17.18%
NORTH-CENTRAL_EURO 27.60%
ATLANTIC 28.71%
WEST_MED 6.16%
EAST_MED -
WEST_ASIAN 2.22%
MIDDLE_EASTERN -
SOUTH_ASIAN -
EAST_AFRICAN -
EAST_ASIAN -
SIBERIAN 0.91%
WEST_AFRICAN -
Here is first run. Thanks Mazik! :). It seems to make sense:
http://i628.photobucket.com/albums/u...stPCA1Img2.jpg
^^
There's probably a more Central to West theme going on with us. The two Portuguese very close down the bottom right. You could flip it clockwise.
Ok i updated with Mark and GeistFaust
http://www.abload.de/img/k13_apricity_distancez3r4l.png
http://www.abload.de/img/apricitpca9sq5d.png
Ok i'll try that on the next run, will have a few more people too.Quote:
Originally Posted by Graham
My EUTest:Quote:
Originally Posted by Jackson
Population
SOUTH_BALTIC 10.68%
EAST_EURO 11.06%
NORTH-CENTRAL_EURO 27.05%
ATLANTIC 20.90%
WEST_MED 13.57%
EAST_MED 9.75%
WEST_ASIAN 3.53%
MIDDLE_EASTERN -
SOUTH_ASIAN 1.19%
EAST_AFRICAN 0.07%
EAST_ASIAN 0.14%
SIBERIAN -
WEST_AFRICAN 2.03%
Here is round 2, still no Evon & co, but they should be between Pallantides and Graham somewhere:
http://i628.photobucket.com/albums/u...stPCA2Img1.jpg
Lol looks like Palla has been cornered by everyone else.
I always find my own spot slightly away from others.:)
You mark the north-pole in every map after which we orientate:thumb001:Quote:
Originally Posted by Pallantides
I also end up as a loner but in contrast to you somewhere in between the clusters being a mark of central-european genetic mediocrity:rolleyes:
To give it perspective.Quote:
Originally Posted by Jackson
http://imageshack.us/a/img28/3995/eutestpca2img1.jpg
I quite like our little northwest tribe. :)Quote:
Originally Posted by Graham
Quote:
Originally Posted by Graham
King In The North!
http://www.youtube.com/watch?v=JQW9lB_KbRgQuote:
Originally Posted by Pallantides
Still waiting for Albion to give us his results. lol
Ok, my second round.
http://s8.postimg.org/764rfhuqd/euk36b.jpg
Will add more tomorrow.
Added 3 Danish samples and one north German one (people from 23&me who list their GEDmatch ID's, that i know of, anyone know any more?). Can't really see the north German one because he is bunked up with Quasimodem and my grandfather (he is actually a distant relative too lol), but the Danish ones are giving Pallantides a context:
http://i628.photobucket.com/albums/u...stPCA3Img1.png