Three Variable Correlation

Discussion in 'Microsoft Excel Misc' started by Eileen, May 17, 2010.

  1. Eileen

    Eileen Guest

    Hi.

    I was wondering if it was possible to work out the correlation between three
    sets of variables in excel, and not just two.

    The data looks like this (example values):

    15,283,741,924 22,891,175,671 182,489,383
    12,450,453,827 25,604,121,237 458,039,634
    25,017,912,202 10,105,478,615 408,312,030
    15,608,597,275 27,352,700,295 71,393,406
    6,293,126,663 33,730,623,537 699,182,754
    15,665,042,562 25,952,123,256 76,238,591
    11,565,224,759 30,426,279,924 44,724,721
    8,716,353,737 33,395,986,265 135,495,541
    11,234,337,068 23,463,987,625 1,163,192,672
    16,285,868,769 21,238,873,761 1,777,205,148
    10,406,955,459 31,623,688,840 71,934,583
    5,827,079,717 38,907,282,319 964,824,980
    11,626,458,649 21,043,475,527 35,381,302
    4,081,044,992 41,239,034,015 835,902,380

    I've used the correl function to work out the two variable correlation
    between columns A/B, A/C and B/C. Now I'd like to see the three variable
    correlation between columns A/B/C.

    Is this possible?

    Thanks in advance for your help.
     
    Eileen, May 17, 2010
    #1
    1. Advertisements

  2. Eileen

    Ben Evans Guest

    Hi,

    Mathematically no such measure exists. Correlations are a measure (if you will) of relation between two variables ONLY. Measuring the three correlations separately is the typical approach. You could run PCA (principle component analysis) on your correlation matrix to understand their linear relationship somewhat more.

    If you are in interested in understanding and modelling the relationship between more than two variables OR are interested in other modelling techniques that measure the relationship between two variables then I suggest that you research the topic known as "Copulas". This will also introduce you to the next step of random variable relationships and their lovely complexities.

    Mathematically Copulas can be a substantial step so only tread there if mathematically able and willing to learn.

    Cheers,



    > On Monday, May 17, 2010 7:21 AM Eileen wrote:


    > Hi.
    >
    > I was wondering if it was possible to work out the correlation between three
    > sets of variables in excel, and not just two.
    >
    > The data looks like this (example values):
    >
    > 15,283,741,924 22,891,175,671 182,489,383
    > 12,450,453,827 25,604,121,237 458,039,634
    > 25,017,912,202 10,105,478,615 408,312,030
    > 15,608,597,275 27,352,700,295 71,393,406
    > 6,293,126,663 33,730,623,537 699,182,754
    > 15,665,042,562 25,952,123,256 76,238,591
    > 11,565,224,759 30,426,279,924 44,724,721
    > 8,716,353,737 33,395,986,265 135,495,541
    > 11,234,337,068 23,463,987,625 1,163,192,672
    > 16,285,868,769 21,238,873,761 1,777,205,148
    > 10,406,955,459 31,623,688,840 71,934,583
    > 5,827,079,717 38,907,282,319 964,824,980
    > 11,626,458,649 21,043,475,527 35,381,302
    > 4,081,044,992 41,239,034,015 835,902,380
    >
    > I have used the correl function to work out the two variable correlation
    > between columns A/B, A/C and B/C. Now I'd like to see the three variable
    > correlation between columns A/B/C.
    >
    > Is this possible?
    >
    > Thanks in advance for your help.
     
    Ben Evans, May 12, 2011
    #2
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Guest

    Correlation Slope

    Guest, Nov 25, 2003, in forum: Microsoft Excel Misc
    Replies:
    2
    Views:
    321
    Guest
    Nov 26, 2003
  2. Guest

    Two Independent Variable Correlation

    Guest, Apr 20, 2005, in forum: Microsoft Excel Misc
    Replies:
    1
    Views:
    224
    Jerry W. Lewis
    Apr 21, 2005
  3. Guest
    Replies:
    6
    Views:
    268
    Guest
    Aug 20, 2007
  4. Eileen

    Three Variable Correlation

    Eileen, May 17, 2010, in forum: Microsoft Excel Misc
    Replies:
    0
    Views:
    418
    Eileen
    May 17, 2010
  5. Eileen

    Three variable correlation

    Eileen, May 28, 2010, in forum: Microsoft Excel Misc
    Replies:
    2
    Views:
    1,383
    Mike Middleton
    May 30, 2010
Loading...

Share This Page