Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Three Variable Correlation
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Three Variable Correlation
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Correlation analysis | Excel Worksheet Functions | |||
correlation | Excel Worksheet Functions | |||
Correlation Matrix | Excel Worksheet Functions | |||
Two Independent Variable Correlation | Excel Discussion (Misc queries) | |||
How do I set up a correlation formula? | Excel Worksheet Functions |