I needed a project to re-teach myself Excel.? ?I used to be pretty good at Excel but that was 15 years ago and I have not really touched it for the last 10 years.
For my re-teaching "moment".....hopefully of interest to some people......
I have captured all the STRs in the U106 project.? ? I then calculated how many of each number for each of the 111 STRs (except the multicopy STRs).
example, the first STR, DYS393
Total 7240
| 11 |
2 |
| 12 |
192 |
| 13 |
6659 |
| 14 |
338 |
| 15 |
49 |
There are several Basement Subgroups at the end of the Classic or Colorized results, a few of which are not very U106ish.? ?At this point, I have kept them in the stats, as on my preliminary effort, I wanted to stay as near as possible to the original totals for each STR.
btw, the totals of each level (approximately)
Y12? ?7240
Y25? ?7151
Y37? ?7093
Y67? ?6187
Y111 4976
I also did a subset of the Blue groups, Z30 and Z8 (combined).? Groups 65 to 99.
The attached Excel files are the summaries.? They do not contain the 7000 plus rows of STR data.
