DNA-R1B1C7-L ArchivesArchiver > DNA-R1B1C7 > 2012-01 > 1326041273
From: Marcus McNeely <>
Subject: Re: [R-M222] FW: Calculation of a correlation coeficient
Date: Sun, 8 Jan 2012 11:47:53 -0500
Hello to the group and many thanks to all for an amazing resource. I
suppose it's high time I joined in (as opposed to chatting with many
For what it's worth, here's the website where Bill has added the relevant
papers, along with a FAQ that addresses his methodology. Please accept my
apologies if this is redundant in any way!
On Sun, Jan 8, 2012 at 1:44 AM, <> wrote:
> In a message dated 1/7/2012 4:39:15 A.M. Central Standard Time,
> In order to illustrate, I need someone who is able to calculate, in Excel,
> what Bill believes are correlation coefficients.
> 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.
> I checked my old notes. It's really pretty simple. There are two ways
> to do it, the first is to use the CORREL function in Excel.
> The syntax is:
> CORREL(array1, array2)
> You can compare any two marker strings of any length using this.
> =CORREL(C1:AM1, C2:AM2)
> Just enter the above formula with the appropriate column and row numbers
> for each marker string.
> Then you can change the markers and watch the correlation coefficient
> Bill does a conversion to RCC (revised correlation coefficient)
> 1/correlation efficient -1 X 10,000
> That results in something more usable like 15.5
> You can also use the data analysis toolkit in Excel to compare more than
> two strings at the same time. This toolkit does not come installed with
> Excel - you need to install it from the installation disks. If you run
> you'll get a half matrix of correlation coefficient numbers for every
> marker string in the spreadsheet range you specify. Bill then copies and
> the half matrix to form a full matrix which is identical to the matrix
> used by the McGee utility.
> Bill would then re-arrange the resulting full matrix to group similar
> numbers together and said he could read the junction lines in the matrix.
> don't know how he did this. Never got that far with 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
|Re: [R-M222] FW: Calculation of a correlation coeficient by Marcus McNeely <>|