A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Three variable correlation



 
 
Thread Tools Display Modes
  #1  
Old May 28th, 2010, 11:25 AM posted to microsoft.public.excel.misc
Eileen
external usenet poster
 
Posts: 89
Default Three variable correlation

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.

  #2  
Old May 28th, 2010, 12:30 PM posted to microsoft.public.excel.misc
Tom-S[_2_]
external usenet poster
 
Posts: 68
Default Three variable correlation

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.

  #3  
Old May 30th, 2010, 01:30 AM posted to microsoft.public.excel.misc
Mike Middleton[_2_]
external usenet poster
 
Posts: 90
Default Three variable correlation

Eileen -

How do you define "three-variable correlation"?

- Mike
http://www.MikeMiddleton.com


"Eileen" wrote in message
...
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.

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 03:30 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.