**DNA-R1B1C7-L Archives**

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

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

differences.

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.

Sandy

-----Original Message-----

From:

[mailto:] On Behalf Of

Sent: 08 January 2012 03:08

To:

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,

writes:

John, I vaguely remember that you played around with a few such

correlation

coefficients, changed a few marker scores here and there to check the

effect

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.

John

R1b1c7 Research and Links:

http://clanmaclochlainn.com/R1b1c7/

-------------------------------

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:**

- [R-M222] FW: Calculation of a correlation coeficient by "Sandy Paterson" <>
- Re: [R-M222] FW: Calculation of a correlation coeficient by
**Re: [R-M222] FW: Calculation of a correlation coeficient by "Sandy Paterson" <>**

- Re: [R-M222] FW: Calculation of a correlation coeficient by
- Re: [R-M222] FW: Calculation of a correlation coeficient by Marcus McNeely <>

- [R-M222] FW: FW: Calculation of a correlation coeficient by "Sandy Paterson" <>

- Re: [R-M222] FW: Calculation of a correlation coeficient by
- Re: [R-M222] FW: Calculation of a correlation coeficient by "Sandy Paterson" <>

- Re: [R-M222] FW: Calculation of a correlation coeficient by
- Re: [R-M222] FW: Calculation of a correlation coeficient by "Sandy Paterson" <>

- Re: [R-M222] FW: Calculation of a correlation coeficient by