KenN's Gen111T Generation Age Calculator

[Mark Jost]

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.

https://docs.google.com/file/d/0By9Y3jb2fORNeUo0eWpBeGRlYkE/edit

Please let me know if there are any issues.

MJost

[Mkk]

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.

[Mark Jost]

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.

MJost

[Mkk]

I was able to download it after clicking on files and then download.

Before I clicked on that little grey arrow to the right of the screen.

Thanks for the help anyway.

[Mark Jost]

Y_DNA_Tools-TMRCA-Gen111T_Estimator_Mod MJost-Master New Formulas Beta2  available

Found direct from my Google Documents

https://docs.google.com/file/d/0By9Y3jb2fORNX2FjVV85bmVtWWs/edit

Intergrated Filtering now available in the Clade sheets. A Filter Mean & Modal macro must be ran to recalculate Interclade Pooled SD. Conditional (color shades indicators) Formating was removed for speed issues.


MJost

[Mark Jost]

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)

https://docs.google.com/open?id=0By9Y3jb2fORNX2FjVV85bmVtWWs

MJost

[Mark Jost]

Uploaded minor update feature to unhide filtered data with a Rest button  in the two clade pages.


https://docs.google.com/open?id=0By9Y3jb2fORNX2FjVV85bmVtWWs

MJost

[stoneman]

What is your present TMRCA estimate for R1b-Z156? I cant open any of the links that you posted as I live in the sticks without broadband.I have to go to the nearest town library.

[Mark Jost]

I just loaded a older U106 dataset from Aug and checked you request with the newest Age Estimator I have.

YrsPerGen  Count
30  N=26

Founder's Age   
Generations    StdDevInGen   YBP    +-YBP    Max
109.3   30.5   3,279.4   915.7   4,195.1

MJost

[Mark Jost]

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.

https://docs.google.com/open?id=0By9Y3jb2fORNX2FjVV85bmVtWWs

MJost

[Mark Jost]

For the P312xL21 and U106 clades I have created the following:

Y_DNA_Tools-TMRCA-Gen111T_Estimator_ModMJost-10132012_U106-P312xL21_67Markers

or download directly here:
https://docs.google.com/file/d/0By9Y3jb2fORNamQtMm9kVnBLc00/edit

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

MJost

[Mark Jost]

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.

https://docs.google.com/open?id=0By9Y3jb2fORNX2FjVV85bmVtWWs

MJost

[Mark Jost]

Mike,
I am testing the  Inter and Intra Clade TMRCA's for the L513 subclade. Comments?

https://docs.google.com/open?id=0By9Y3jb2fORNM1VGWmZ6Tk1NTG8

MJost

[Mikewww]

Mike,
I am testing the  Inter and Intra Clade TMRCA's for the L513 subclade. Comments?

https://docs.google.com/open?id=0By9Y3jb2fORNM1VGWmZ6Tk1NTG8

MJost

Thanks, Mark. I'm not that familiar with Google Docs. Is there a way to easily rotate the view of the charts?

[Mark Jost]

Download then Right click and rotate to view or from the menu bar.

MJost

[Mark Jost]

Beta 4 out now going for gold.

https://docs.google.com/open?id=0By9Y3jb2fORNX2FjVV85bmVtWWs

MJost

[Mark Jost]

Out of beta. V1.2 is up.

https://docs.google.com/file/d/0By9Y3jb2fORNX2FjVV85bmVtWWs/edit

MJost

[Mark Jost]

I think I am done for now. I increased the speed of the copy process some things up in V1.3

https://docs.google.com/file/d/0By9Y3jb2fORNX2FjVV85bmVtWWs/edit

MJost

[Mark Jost]

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?

MJost

[stoneman]

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

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?

MJost

[Mark Jost]

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.

[stoneman]

The fact is that the Native Americans ancestors arrived in America 12000 ybp. I dont need a calculator to work that one out.

[Mark Jost]

The fact is that the Native Americans ancestors arrived in America 12000 ybp. I dont need a calculator to work that one out.

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

I didnt think you would try.

MJost

[Jdean]

The fact is that the Native Americans ancestors arrived in America 12000 ybp. I dont need a calculator to work that one out.

That's as maybe but it doesn't mean the MRCA is necessarily from that time, it could easily be considerably older or younger !

[stoneman]

So you think that I am not capable and that you are more intelligent.

The fact is that the Native Americans ancestors arrived in America 12000 ybp. I dont need a calculator to work that one out.

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

I didnt think you would try.

MJost