Analyzing Surname Data
July 9, 2010 3:55 PM Subscribe
I need help visually and clearly showing/analyzing surname data retrieved from 23andme.com's Relative Finder feature.
I have recently signed up to 23andme.com and have been using their Relative Finder feature. I have been contacting relatives and keeping an Excel list of their surnames and using Conditional Formatting in Excel to highlight common names across surname lists.
The purpose is to find out which individuals share multiple surnames amongst each other and therefore are more likely to be related to me based on those shared names and also to show possible relationships. Unfortunately, this system is not working very well anymore because of the increasing amount of surnames. I need a better method (or program?) to help me identify relationships between individuals. If possible, it would be nice to know the probable number of generations back the person may be related to me (don’t know if this is possible based on the surname data, but may be possible based on the number of DNA segments I share with the person--which is some more data I have linked to each individual’s name). I would really appreciate some suggestions on how I can organize this information more visually and clearer, and possibly have a program tell me the likelihood of relationships amongst people.
Also, I have a good deal of experience with Excel and very minimal experience with Access (a program I considered using to run queries on individuals and to show relationships).
Maybe someone has an idea that I haven’t thought up yet. Any suggestions at all would be helpful!!!!