DNA survey - please respond

My version with Wales

 

Here is my spreadsheet. The latest version is more accurate for me than the earlier one. I've annotated the English counties with the number of my 3x GG parents. The others are as follows:

3 Ireland
6 Scotland
7 unknown (probably 5 Ireland 2 Scotland)

With a whole host of direct ancestors called Williams living in Bristol I fully expected to find eventually a connection to Wales. But the figures don't seem to support that supposition.

 

I've corrected my spreadsheet for the new population figures. The results are not as good as with the 1801 populations.
My husband's was already correct. Sorry about that.
I was analyzing my tree and I have birthplaces for 1680 persons and baptisms for 2469 persons. Only 404 have both.
I have slightly more with birthplaces in Kent (419) than Essex (306) and Middlesex/London (387).
I have 1353 baptisms in Kent, 54% of the total which reflects my research and the availability of records to me.
I'm thinking that counties which are more difficult to access records from maybe throw up less matches?

 

That example makes sense - but I thought I had at least as many matches as others posting on this thread although my ancestry is Welsh. There must be other factors too?

 

I've been following this discussion and would be happy to post my results. I only got my test results five days ago though, and I'm sure it mentions in the masterclass about Ancestry's database needing a few days to sort itself out. Should I wait a while longer or do you reckon I'm ok?

 

I split them according to which part of Bristol they resided in. They moved back and forwards across the county boundary. So if I had gone back to 4xGG then the the two Gloucestershire would have become 3 Somerset and 1 Gloucestershire.

 

Apologies I had misunderstood the requirement. Attached is my amended spreadsheet.

 

After three decades working on computers I still feel uncomfortable working on a spreadsheet [I'm a writer]. So I can't guarantee mine is without flaws.

 

Revised

 

I hope I've done this right...I'm not an experienced Excel file user either. Anyway, as expected Lancashire, Kent, Yorkshire and Shropshire were the counties I thought would be the strongest...although Cheshire forebears link with the Shropshire ones in the main. I'm surprised that Sussex is as strong as it is, although that makes sense in view of Kentish forebears. Overall, though, 'tis more or less what I expected to see. Rather surprised that the border counties of Wales haven't been included as there was clearly a lot of leakage to and from both sides - that said I have only three or four pages from each of Denbighshire, Montgomeryshire and Flintshire.

Anyway, it's been an interesting exercise overall... thank you.

 

Here are my results...

Thanks, Peter, for fast-tracking me to "member" to allow me to do this.

 

Decided to give this a go using Peter's updated spreadsheet on page 6 (I hope that's correct, the first post is still pointing to the one on page 4). I'm not sure if this tells me anything meaningful though, my results seem awfully spread out and my scores for Lancashire and Yorkshire will be meaningless thanks to Ancestry's 40 page limit.

 

Here is my spreadsheet. I have joined the forum today specifically to take part, so I hope it is OK. Carmarthenshire and Pembrokeshire are at the top with Glamorgan not far behind. That is what I would have expected. I'm not sure where Breconshire came from, but it is quite possible that some of the Carmarthenshire and Glamorgan people had ancestors from there that I don't know about.