ASD Peter Gwozdz Click sheet "ASD Doc" for instructions In this TRANSPOSE array, the "Years" are figured with ASD, copied from row 7, treating compound markers as individuals
Column A is input data But the "Mutations" are figured using "Infinite Alleles",  copied from row 42;  for compound markers the mutations are totaled in the "a" marker only
25 < Years per generation;  may be changed DYS 393 390 19 391 385a 385b 426 388 439 389-1 392 389-2 458 459a 459b 455 454 447 437 448 449 464a 464b 464c 464d 460 GATA YCa YCb 456 607 576 570 CDa CDb 442 438 531 578 395a 395b 590 537 641 472 406 511 425 413a 413b 557 594 436 490 534 450 444 481 520 446 617 568 487 572 640 492 565 DYS Copy this array over to the right;  use Paste, Special, Values The copy over here can be sorted by Rank
ASD 0,00000 0,34349 0,10526 0,13296 0,15512 0,00000 0,00000 0,00000 0,04986 0,00000 0,00000 0,24931 0,23823 0,00000 0,13296 0,00000 0,00000 0,04986 0,00000 0,04986 0,61496 0,10526 0,09418 0,04986 0,09418 0,04986 0,32133 0,00000 0,26039 0,45429 0,15512 1,81163 0,65374 0,36565 2,55956 0,37673 0,00000 0,04986 0,00000 0,00000 0,00000 0,04986 0,19391 0,00000 0,00000 0,19945 0,04986 0,00000 0,00000 0,00000 0,04986 0,00000 0,04986 0,04986 0,19945 0,00000 0,19391 0,04986 0,00000 0,04986 0,00000 0,00000 0,00000 0,04986 0,00000 0,00000 0,13296 ASD Do not sort this "TRANSPOSE" array Sort by Sequence to get back to standard order
Mutation Rates >>> Chandler Mutation Rates 0,00076 0,00311 0,00151 0,00265 0,00226 0,00226 0,00009 0,00022 0,00477 0,00186 0,00052 0,00242 0,00814 0,00132 0,00132 0,00016 0,00016 0,00264 0,00099 0,00135 0,00838 0,00566 0,00566 0,00566 0,00566 0,00402 0,00208 0,00123 0,00123 0,00735 0,00411 0,01022 0,00790 0,03531 0,03531 0,00324 0,00055 0,00037 0,00008 0,00031 0,00031 0,00054 0,00057 0,00018 0,00001 0,00154 0,00128 0,00018 0,00202 0,00202 0,00321 0,00029 0,00018 0,00019 0,00832 0,00020 0,00321 0,00544 0,00245 0,00365 0,00042 0,00053 0,00097 0,00212 0,00034 0,00042 0,00087 Chandler Mutation Rates Rank DYS Sequence Mutations Years Rank DYS Sequence Mutations Years Mask Notes
Age in generations = ASD divided by rate 0 110 70 50 69 0 0 0 10 0 0 103 29 0 101 0 0 19 0 37 73 19 17 9 17 12 154 0 212 62 38 177 83 10 72 116 0 135 0 0 0 92 340 0 0 130 39 0 0 0 16 0 277 262 24 0 60 9 0 14 0 0 0 24 0 0 153 Age in generations = ASD divided by rate 40 393 1 0 0 1 537 43 5 8 505 Bimodal Marker
Years 0 2 761 1 743 1 254 1 716 0 0 0 261 0 0 2 575 732 0 2 518 0 0 472 0 923 1 835 465 416 220 416 310 3 862 0 5 292 1 545 944 4 432 2 069 259 1 812 2 907 0 3 369 0 0 0 2 308 8 505 0 0 3 238 974 0 0 0 388 0 6 925 6 561 599 0 1 510 229 0 342 0 0 0 588 0 0 3 821 Years 11 390 2 4 2 761 2 436 53 1 6 925 One mutation out of 19 samples in this slow mutating marker provides a very old age estimate
Averages by various sets of markers: Average of first 12 markers Average of first 25 markers Average of first 37 markers Average of all 67 markers 18 19 3 2 1 743 3 490 54 1 6 561 One mutation out of 19 samples in this slow mutating marker provides a very old age estimate
Average ASD;  all 67 markers 0,16182 0,08633 0,09861 0,25605 0,16182 Average ASD 22 391 4 16 1 254 4 YCb 29 0 5 292
Chandler Mutation Rates Average 0,00335 0,00187 0,00278 0,00492 0,00335 Chandler Mutation Rates Average 19 385a 5 17 1 716 5 576 32 11 4 432
Age in generations = ASD divided by rate 48 46 Generations 35 52 48 Age in generations = ASD divided by rate 40 385b 6 0 0 6 GATA 27 12 3 862
Age in years 1 208 1 155 886 1 301 1 208 Years 40 426 7 0 0 7 565 67 3 3 821
Thomas: 1 2 3 4 5 Average of markers 13-25 Average of markers 26-37 Average of markers 38-67 40 388 8 0 0 8 531 38 1 3 369
Average ASD with the 5 Thomas markers 0,11634 (Compare to Thomas average = 0.2226) 0,10995 0,58403 0,04561 Average ASD 36 439 9 1 261 9 406 46 16 3 238
Thomas Rate 0,00210 0,00362 0,00938 0,00141 Chandler Mutation Rates Average 40 389-1 10 0 0 10 442 36 16 2 907
Age in generations = ASD divided by rate 55 30 62 32 Age in generations = ASD divided by rate 40 392 11 0 0 11 390 2 4 2 761
Age in years 1 385 (Compare to Thomas 2,650) 759 1 557 810 Years 12 389-2 12 9 2 575 12 389-2 12 9 2 575
Mask: 26 458 13 18 732 13 459b 15 0 2 518
Masks are explained in the Documentation Compound Markers;  Infinite Alleles 40 459a 14 3 0 14 590 42 1 2 308
To specify which markers to use for ASD: Modal 0 = Not mutated;  1 - Mutated 13 459b 15 0 2 518 15 570 33 9 2 069
Mask >>> Type or copy a mask into this row >> 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 Count 2 16 0 17 0 19 19 40 455 16 0 0 16 449 21 17 1 835
Count 1 1 1 1 - - 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 - - - - 1 1 1 1 1 1 1 1 - - 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 385 459 464 YC CD 395 413 40 454 17 0 0 17 CDb 35 0 1 812
Number of Markers 59 1 0 1 0 1 0 0 29 447 18 18 472 18 19 3 2 1 743
ASD 0 0,34349 0,10526 0,13296 0 0 0,04986 0 0 0,24931 0,23823 0 0,13296 0 0 0,04986 0 0,04986 0,61496 0,04986 0,32133 0 0,26039 0,45429 0,15512 1,81163 0,65374 0,37673 0 0,04986 0 0 0 0,04986 0,19391 0 0 0,19945 0,04986 0 0 0 0,04986 0 0,04986 0,04986 0,19945 0 0,19391 0,04986 0 0,04986 0 0 0 0,04986 0 0 0,13296 1 0 1 0 1 0 0 40 437 19 0 0 19 385a 5 17 1 716
Rate 0,00076 0,00311 0,00151 0,00265 0,00009 0,00022 0,00477 0,00186 0,00052 0,00242 0,00814 0,00132 0,00132 0,00016 0,00016 0,00264 0,00099 0,00135 0,00838 0,00402 0,00208 0,00123 0,00123 0,00735 0,00411 0,01022 0,0079 0,00324 0,00055 0,00037 0,00008 0,00031 0,00031 0,00054 0,00057 0,00018 0,00001 0,00154 0,00128 0,00018 0,00202 0,00202 0,00321 0,00029 0,00018 0,00019 0,00832 0,0002 0,00321 0,00544 0,00245 0,00365 0,00042 0,00053 0,00097 0,00212 0,00034 0,00042 0,00087 1 0 1 0 1 0 0 25 448 20 1 923 20 456 30 12 1 545
Average ASD;  selected markers 0,12573 1 0 1 0 1 0 0 16 449 21 17 1 835 21 444 57 5 1 510
Average rate 0,00214 1 0 1 0 1 0 0 30 464a 22 19 465 22 391 4 16 1 254
Generations 59 1 0 1 0 1 0 0 31 464b 23 0 416 23 511 47 1 974
Years 1 466 1 1 1 0 1 0 0 39 464c 24 0 220 24 607 31 3 944
0 0 1 0 1 0 0 31 464d 25 0 416 25 448 20 1 923
Mask Tool: Be sure to use "Paste Special, Values" when copying a mask to another location 0 0 1 0 1 0 0 35 460 26 1 310 26 458 13 18 732
5 000 < Set the limit for the number of years in the mask 1 1 1 1 1 0 0 6 GATA 27 12 3 862 27 534 55 4 599
Years Limit 1 0 1 0 1 0 0 40 YCa 28 2 0 28 572 64 18 588
Rank;  oldest = 1, 2, 3 … 40 11 18 22 19 40 40 40 36 40 40 12 26 40 13 40 40 29 40 25 16 30 31 39 31 35 6 40 4 20 24 5 15 37 17 10 40 8 40 40 40 14 1 40 40 9 23 40 40 40 33 40 2 3 27 40 21 38 40 34 40 40 40 28 40 40 7 1 0 1 0 1 0 0 4 YCb 29 0 5 292 29 447 18 18 472
Highlight > Limit - - - - - - - - - - - - - - - - - - - - - - - - - - - - 5 292 - - - - - - - - - - - - - 8 505 - - - - - - - - - 6 925 6 561 - - - - - - - - - - - - - 1 0 1 0 1 0 0 20 456 30 12 1 545 30 464a 22 19 465
Mask for all markers below the "Years Limit" 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 0 4 4 4 4 4 4 4 4 4 4 4 4 4 0 4 4 4 4 4 4 4 4 4 0 0 4 4 4 4 4 4 4 4 4 4 4 4 4 1 0 1 0 1 0 0 24 607 31 3 944 31 464b 23 0 416
1 0 1 0 1 0 0 5 576 32 11 4 432 31 464d 25 0 416
DYS 393 390 19 391 385a 385b 426 388 439 389-1 392 389-2 458 459a 459b 455 454 447 437 448 449 464a 464b 464c 464d 460 GATA YCa YCb 456 607 576 570 CDa CDb 442 438 531 578 395a 395b 590 537 641 472 406 511 425 413a 413b 557 594 436 490 534 450 444 481 520 446 617 568 487 572 640 492 565 DYS 1 0 1 0 1 0 0 15 570 33 9 2 069 33 557 51 1 388
Infinite Alleles: 1 0 1 0 1 0 0 37 CDa 34 19 259 34 446 60 1 342
10% < Limit for Fraction Mutated Set the limit in the red cell to the left  for the percent of samples mutated (not the modal value) 1 1 1 1 1 0 0 17 CDb 35 0 1 812 35 460 26 1 310
Number of Samples 19 19 19 19 19 19 19 19 19 19 19 19 19 19 19 19 19 19 19 19 19 19 19 19 19 19 19 19 19 19 19 19 19 19 19 19 19 19 19 19 19 19 19 19 19 19 19 19 19 19 19 19 19 19 19 19 19 19 1 0 1 0 1 0 0 10 442 36 16 2 907 36 439 9 1 261
Number Mutated (not modal value) 0 4 2 16 17 0 0 1 0 0 9 18 3 0 0 18 0 1 17 19 1 12 2 12 3 11 9 19 16 0 1 19 0 1 5 0 0 16 1 0 0 1 0 1 1 4 0 5 19 0 1 0 0 0 18 0 0 3 40 438 37 0 0 37 CDa 34 19 259
Fraction Mutated 0,00000 0,21053 0,10526 0,84211 0,89474 0,00000 0,00000 0,05263 0,00000 0,00000 0,47368 0,94737 0,00000 0,00000 0,00000 0,94737 0,00000 0,05263 0,89474 0,94737 0,05263 0,63158 0,00000 0,63158 0,15789 0,57895 0,47368 0,84211 0,84211 0,00000 0,05263 1,00000 0,00000 0,05263 0,26316 0,00000 0,00000 0,84211 0,05263 0,00000 0,00000 0,05263 0,00000 0,05263 0,05263 0,21053 0,00000 0,26316 1,00000 0,00000 0,05263 0,00000 0,00000 0,00000 0,94737 0,00000 0,00000 0,15789 8 531 38 1 3 369 38 481 58 19 229
Generations 0 68 70 318 198 0 0 11 0 0 196 116 0 0 0 359 0 39 107 42 13 304 0 86 38 57 60 12 260 0 142 12500 0 97 462 0 0 547 41 0 0 16 0 292 277 25 0 82 184 0 14 0 0 0 447 0 0 181 40 578 39 19 0 39 464c 24 0 220
Years 0 1692 1743 7944 4949 0 0 276 0 0 4893 2910 0 0 0 8971 0 975 2669 1046 327 7591 0 2148 960 1416 1499 298 6498 0 3556 312500 0 2437 11542 0 0 13671 1028 0 0 410 0 7310 6925 633 0 2050 4596 0 360 0 0 0 11172 0 0 4537 40 395a 40 0 0 40 393 1 0 0
Infinite Alleles / ASD 1,00 0,61 1,00 6,33 2,88 1,00 1,00 1,06 1,00 1,00 1,90 3,98 1,00 1,00 1,00 19,00 1,00 1,06 1,45 2,25 1,06 1,97 1,00 1,39 1,02 0,32 0,72 1,15 2,24 1,00 1,06 1,00 1,00 1,06 1,36 1,00 1,00 4,22 1,06 1,00 1,00 1,06 1,00 1,06 1,06 1,06 1,00 1,36 20,06 1,00 1,06 1,00 1,00 1,00 19,00 1,00 1,00 1,19 40 395b 41 0 0 40 385b 6 0 0
Markers Less Than Limit 1 - - - - 1 1 1 1 1 - - 1 1 1 - 1 1 - - 1 - 1 - - - - - - 1 1 - 1 1 - 1 1 - 1 1 1 1 1 1 1 - 1 - - 1 1 1 1 1 - 1 1 - 14 590 42 1 2 308 40 426 7 0 0
Mask >>> Enter 1 to Exclude a Marker 1 537 43 5 8 505 40 388 8 0 0
Mask >>> Enter 1 to Add a Marker 40 641 44 0 0 40 389-1 10 0 0
Net Mask 1 0 0 0 0 1 1 1 1 1 0 0 1 1 1 0 1 1 0 0 1 0 1 0 0 0 0 0 0 1 1 0 1 1 0 1 1 0 1 1 1 1 1 1 1 0 1 0 0 1 1 1 1 1 0 1 1 0 40 472 45 0 0 40 392 11 0 0
Mutations 0 0 0 0 0 0 0 1 0 0 0 0 3 0 0 0 0 1 0 0 1 0 2 0 0 0 0 0 0 0 1 0 0 1 0 0 0 0 1 0 0 1 0 1 1 0 0 0 0 0 1 0 0 0 0 0 0 0 9 406 46 16 3 238 40 459a 14 3 0
Total Mutations (values not modal) 15 23 511 47 1 974 40 455 16 0 0
Number of Markers 34 40 425 48 0 0 40 454 17 0 0
Fraction 0,00000 0,00000 0,00000 0,00000 0,00000 0,00000 0,00000 0,05263 0,00000 0,00000 0,00000 0,00000 0,00000 0,00000 0,00000 0,00000 0,00000 0,05263 0,00000 0,00000 0,05263 0,00000 0,00000 0,00000 0,00000 0,00000 0,00000 0,00000 0,00000 0,00000 0,05263 0,00000 0,00000 0,05263 0,00000 0,00000 0,00000 0,00000 0,05263 0,00000 0,00000 0,05263 0,00000 0,05263 0,05263 0,00000 0,00000 0,00000 0,00000 0,00000 0,05263 0,00000 0,00000 0,00000 0,00000 0,00000 0,00000 0,00000 40 413a 49 0 0 40 437 19 0 0
Average Fraction 0,01548 40 413b 50 0 0 40 YCa 28 2 0 Ysearch step count combines this with Yca
Rate 0,00076 0,00000 0,00000 0,00000 0,00000 0,00009 0,00022 0,00477 0,00186 0,00052 0,00000 0,00000 0,00132 0,00016 0,00016 0,00000 0,00099 0,00135 0,00000 0,00000 0,00402 0,00000 0,00123 0,00000 0,00000 0,00000 0,00000 0,00000 0,00000 0,00055 0,00037 0,00000 0,00031 0,00054 0,00000 0,00018 0,00001 0,00000 0,00128 0,00018 0,00202 0,00321 0,00029 0,00018 0,00019 0,00000 0,00020 0,00000 0,00000 0,00245 0,00365 0,00042 0,00053 0,00097 0,00000 0,00034 0,00042 0,00000 33 557 51 1 388 40 438 37 0 0
Average Rate 0,00105 40 594 52 0 0 40 578 39 19 0
Generations 15 2 436 53 1 6 925 40 395a 40 0 0
Years 368 3 490 54 1 6 561 40 395b 41 0 0
27 534 55 4 599 40 641 44 0 0
40 450 56 0 0 40 472 45 0 0
21 444 57 5 1 510 40 425 48 0 0
38 481 58 19 229 40 413a 49 0 0
40 520 59 0 0 40 413b 50 0 0
34 446 60 1 342 40 594 52 0 0
40 617 61 0 0 40 450 56 0 0
40 568 62 0 0 40 520 59 0 0
40 487 63 0 0 40 617 61 0 0
28 572 64 18 588 40 568 62 0 0
40 640 65 0 0 40 487 63 0 0
40 492 66 0 0 40 640 65 0 0
7 565 67 3 3 821 40 492 66 0 0