MikeW had originally created a nice TMRCA Estimator using Ken Nordtvedt's Gen7 Age calculator. I took the liberty to integrated the new Nordtvedt Gen111T engine into Mike's Gen 7.1 Estimator and upgraded the long hand calculations to internal excel functions that provide more precision in Excel 2003 or later. The Var/VarP type functions use a two-pass process that finds the sample mean on the first pass and computes the sum of squared deviations on the second pass. Added intraclade Var & SD and a Pooled SD calculation for Interclade sigma number and variance data, added new Age info in a new Dashboard with Interclade auto iteration feature and adjustable Generation age setting. Haplotype datasets of one length can be stepped down to smaller length by selection.

I have posted a Zipped copy of the beta spreadsheet on my google documents storage.

This is probably a noobish question, who how does one download it? I tried save as, but when I tried to open it on excel it said there was some missing file. Clicking download just sent me to a redirect loop screen.

This is probably a noobish question, who how does one download it? I tried save as, but when I tried to open it on excel it said there was some missing file. Clicking download just sent me to a redirect loop screen.

Ah, this is a Zipped (compressed) file. Once downloaded, click to open and it will show you the contents inside. Either, 1) click extract button and it will save the file to your computer, or 2) just double click and it will open in Excel leaving the file in compressed folder.

Updated my modified version of the Age Estimate spreadsheet revised Filtering option inside of both Clades. If Filtering is active, then a required 'Filtering' macro has to be run to re-calculate SD/VARs for Interclade use, after which the 'Interclade Age' macro needs run next. (The individual STR Variance issue is fixed as well)

Added a optional Confidence Calculator to investigate a difference standard deviation distribution range. Loaded MikeW's P312xL21 67 marker data set in Clade B for those who wish to calculate some ages on those subclades.

This is my latest beta version of MikeW Estimator modified with KenN's Gen111Tengine and my additional mods using prefilled 67 marker U106 and P313xL21Haplotypes. Filtering is possible in either of the Clade(X)_Hts sheet foranalysis. Please read the processing steps needed and the remaining notes anduse "as is". Stored in my Google Documents.

Modified the Interclade Pooled SD formula allowing two equal datasets to pool correctly. I loaded MikeW's L21 111 marker data set in Clade A and B for those who wish to calculate some Interclade ages between L21 SNP clades and their subclades.

Small differences can be statistically ‘‘significant’’ simply because of a large sample size. Some critics of significance testing argue that confidence intervals and measures of effect size should be the focal point of research findings.

What is the best method of the two when considering variance and standard deviations of haplotypes?

Small differences can be statistically ‘‘significant’’ simply because of a large sample size. Some critics of significance testing argue that confidence intervals and measures of effect size should be the focal point of research findings.

What is the best method of the two when considering variance and standard deviations of haplotypes?

Run some Native American haplotypes through your calculator and if the TMRCA is not 12,000 ybp then bin it.

12K would probably require a change in STRs used. I will look forward to you modifying the Gen111T to reflect that factand you can run the NA Hts and see what happens before and after the changes and see what occurs.