Prev: Backup Excel fileNext: INDIRECT From: Eileen on 28 May 2010 06:25 Hi. I was wondering if it was possible to work out the correlation between three variables in excel, not just two. My data looks like this (this is just an example, with random values): A B C 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 already used the correl function to work out the two-variable correlations between columns A/B, B/C and A/C. I'd now like to work out the three-variable correlation between columns A/B/C. Is this possible? Thanks, Eileen. PS I apologise if this query appears twice. I already tried to post it, but then couldn't find it, so I assumed there was a problem with the post. From: Tom-S on 28 May 2010 07:30 I don't think Excel can handle trivariate / multivariate correlation. Try a look here for a trivariate scatterplot: http://www.wessa.net/rwasp_cloud.wasp Regards, Tom "Eileen" wrote: > Hi. > > I was wondering if it was possible to work out the correlation between three > variables in excel, not just two. > > My data looks like this (this is just an example, with random values): > > A B C > 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 already used the correl function to work out the two-variable > correlations between columns A/B, B/C and A/C. I'd now like to work out the > three-variable correlation between columns A/B/C. Is this possible? > > Thanks, > Eileen. > > PS I apologise if this query appears twice. I already tried to post it, but > then couldn't find it, so I assumed there was a > problem with the post. > From: Mike Middleton on 29 May 2010 20:30 Eileen - How do you define "three-variable correlation"? - Mike http://www.MikeMiddleton.com "Eileen" wrote in message news:677A29FE-949B-42C3-9BE7-05B0805AC8AF(a)microsoft.com...> Hi. > > I was wondering if it was possible to work out the correlation between > three > variables in excel, not just two. > > My data looks like this (this is just an example, with random values): > > A B C > 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 already used the correl function to work out the two-variable > correlations between columns A/B, B/C and A/C. I'd now like to work out > the > three-variable correlation between columns A/B/C. Is this possible? > > Thanks, > Eileen. > > PS I apologise if this query appears twice. I already tried to post it, > but > then couldn't find it, so I assumed there was a > problem with the post. >  |  Pages: 1 Prev: Backup Excel fileNext: INDIRECT