DNA-R1B1C7-L Archives

Archiver > DNA-R1B1C7 > 2012-01 > 1326021385

From: "Sandy Paterson" <>
Subject: Re: [R-M222] FW: Calculation of a correlation coeficient
Date: Sun, 8 Jan 2012 11:16:25 -0000
References: <8281.50cb1967.3c3a6289@aol.com>
In-Reply-To: <8281.50cb1967.3c3a6289@aol.com>


Yes, it's pretty easy. Let's start with a comparison between two 37-marker
haplotypes. I've attached a file with one haplotype in column A and one in
column B. I think one is a Burns and the other a Ryall.

It would be best I think if you were to calculate the correlation
coefficient and then the RCC without my help, to ensure that I don't
influence the result. If we get different answers, we can discuss the

I've attached two identical files, one in an old Excel format (.xls) and one
in the format for Excel 2007 (.xlsx). I don't know what version of Excel you
are using.


-----Original Message-----
[mailto:] On Behalf Of
Sent: 08 January 2012 03:08
Subject: Re: [R-M222] FW: Calculation of a correlation coeficient

In a message dated 1/7/2012 4:39:15 A.M. Central Standard Time,

John, I vaguely remember that you played around with a few such
coefficients, changed a few marker scores here and there to check the
of a single mutations at various markers.

Are you happy to do this again?

I'd have to review a little but it was pretty easy to do in Excel. It's
easy to get Excel to produce a half-matrix with all the Correlation
coefficients. Bill then constructs a full matrix which takes a little
work. I
never found an easy way to convert them into his RCC but the conversion is

simple enough. His charts are then produced through a software program
called Mathmatica which no one I know has.

If it helps I can play with it again. It might be a way to resolve the
huge discrepancy in TMRCA dates. Or I can tell Steve how to do it.


R1b1c7 Research and Links:

To unsubscribe from the list, please send an email to
with the word 'unsubscribe' without the
quotes in the subject and the body of the message

This thread: