Three variable correlation 05-28-10

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.

0
Utf
5/28/2010 10:25:01 AM
excel.misc 78881 articles. 5 followers. Follow

2 Replies
1776 Views

Similar Articles

[PageSpeed] 49

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.
> 
0
Utf
5/28/2010 11:30:03 AM
Eileen  -

How do you define "three-variable correlation"?

-  Mike
http://www.MikeMiddleton.com


"Eileen" <Eileen@discussions.microsoft.com> wrote in message 
news:677A29FE-949B-42C3-9BE7-05B0805AC8AF@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.
> 
0
Mike
5/30/2010 12:30:34 AM
Reply:

Similar Artilces:

Permissions 10-12-06
Hi Could someone please assist me with the permission that allows email to be tracked or promoted to CRM? I need to adjust the permissions to allow this and I have looked at the permissions within security roles but I am unsure which one needs to be adjusted. Thanks alot Mark ...

Desktop Icons 03-08-10
XP Pro, IE 8 - Do not really know what to ask for but my desktop icons and other icons throughtout system are one-click icons instead of the double-click icons. This is annoying and I'd like to change but do not have a clue as to how it happened and what to call it. Thanks in advance. Ken Go to the Control Panel and then to Folder Options. Change the settings from single click to double click on the "General" tab. "KenP" <KenP@discussions.microsoft.com> wrote in message news:4F4E65B2-522C-42CC-8647-F1D5EC8E777C@microsoft.com... > XP Pro, IE 8...

selecting and inserting existing and non existing rows into table parameters and variables
I need to do the following: 1. Select all rows that exist both in the TVP @Headlines and in the table [Headlines].[Headlines] and insert them into a table variable @ExistingHeadlines. 2. Select the rows that exist only in the TVP @Headlines and not in [Headlines].[Headlines] and insert them into a table variable @NonexistentHeadlines. How would you do this? The stored procedure takes 2 totally different paths depending on whether or not the items in @Headlines already exist in the main Headlines table. 1. If they exist already, return an error telling the client that thes...

query help 12-05-09
i am using sql server 2000 and i need to do the following. sql server 2005 made stuff like this easy. i have a table like this (pseudo coded) CREATE TABLE CONTRACT (CONTRACT_ID INT, CONTRACT_NUMBER VARCHAR(10), CONTRACT_REGION VARCHAR(10), STATUS VARCHAR(20), CONTRACT_DATE DATETIME) INSERT INTO CONTRACT (CONTRACT_ID, CONTRACT_NUMBER, CONTRACT_REGION, STATUS, CONTRACT_DATE) VALUES (1, '1000', 'EAST', 'IN PROGRESS', '2007-01-01') INSERT INTO CONTRACT (CONTRACT_ID, CONTRACT_NUMBER, CONTRACT_REGION, STATUS, CONTRACT_DATE) VALUES (2, '2000...

Remove three-dimensional shading (DS_3DLOOK)
I use all standard window controls owned by a subsystem version 4.0 application and want to draw them without a 3D look. I have removed the DS_3DLOOK style from .rc file and additionally erase this flag using the VC++ virtual method PreSubclassWindow but my doings is not take effect. ...

window based authentication with members defined in a distribution list. 02-18-10
I want windows based authentication for a particular folder of my web pages. This page should be accessible to only some of the managers and some other roles. I don't want to allow or deny role and persons in web.config. Rather, is it possible that a distribution list created in active directory of the domain and linked with web config? The logins that are there in the distribution list will only be able to view the pages and others will get error.aspx page. In this way, the non-technical higher position persons will also be able to grant and deny access to other membe...

test 08-13-10
test ...

Reporting 10-29-07
We have a customized report that we run every month that we export to Excel. Is there a way that we can change the query on this report each month (since it is based on a monthly date) without having to create a whole new report? There has to be a way to do this so we can maintain the same formatting in Excel that we have done for that particular report. Please help. ...

Equation Editor 05-16-10
I needing to know how to put my answer on the equation editor. Example my instructor has a work sheet and it has math problems, I have to give the answer and some I have to show the work and I don't know how to do this. Which Word version and which Equation editor? As of Word 2007 there is a new equation editor which gets used by default. It functions differently from the old one (which you can still use). Yves "vcrawl" <vcrawl@discussions.microsoft.com> wrote in message news:44D6D1F3-1FA1-4B46-93F3-60D7342D7C2E@microsoft.com... >I needing to know how...

Reinstalling XP 01-10-10
How do I wipe the hard drive clean and restore the system (Windows XP) to its bought-condition? Thank you for your help. "Erik" <reply-to-group@email.net> said this in news item news:uWtNBwckKHA.2188@TK2MSFTNGP04.phx.gbl... > How do I wipe the hard drive clean and restore the system (Windows XP) to > its bought-condition? > > Thank you for your help. > Here is what you do: 1. Reboot the machine and press the appropriate key to get into the BIOS setup. 2. Make your CD drive the primary boot device. 3. Boot the machine from your WinXP C...

Finding One Value, Matching Three Criteria
This is the table that has the values that we are looking up: Gain 1.6 1.6 1.8 1.8 2.0 2.0 Sex S H S H S H Body Weight 400 17.4 19.2 18.4 20.5 19.5 21.8 410 17.7 19.6 18.8 20.9 19.9 22.2 420 18.0 19.9 19.1 21.3 20.2 22.6 430 18.3 20.3 19.4 21.6 20.6 23.0 440 18.7 20.6 19.8 22.0 20.9 23.4 450 19.0 21.0 20.1 22.4 21.3 23.8 This the area of the spreadsheet that contains the criteria to matc for the lookup: Sex Gain Body Weight Value ? H 1.8 430 ? S 1.6 450 ? Can someone tell me how to write a formula that will find the value i ...

Windows Live Messenger has stopped working 01-07-10
Looking for some guidance. When I select Windows Live Messenger I receive the following: Windows is checking for a solution to the problem I have tried changing the compatibility settings and re-installing several times. windows 7 home premium (64-bit OS) 6GB RAM ...

email account 02-28-10
I am having trouble setting this account up. I just don't understand anything about POP3 or POP1 servers. Can you please help First, you need to have a Yahoo PLUS account - the one you pay for. Do you have that - or the free one? If you only have the free one, you can only use the webmail access, not Windows Mail. "tonya kelley" <tkelley731@yahoo.com> wrote in message news:OQ0Jm7MuKHA.4492@TK2MSFTNGP05.phx.gbl... > I am having trouble setting this account up. I just don't understand > anything about POP3 or POP1 servers. Can you please he...

Message Stuck in Outbox #10
I sent a message > 5MB which is over my mail server's limit so while it was doing the send/receive, I canceled it. Then the mail was stuck in my mailbox. I cannot open it or delete it because every time I tried to open or delete it. It won't let me to move it to deleted box. I got message that Outlook is transmitting the message and it won't do it. Because of this stucked email, all my other messages queued in the outbox. How can I get rid of this stucked message. You can use exmerge to extract the email... >-----Original Message----- >I sent a message > 5MB w...

Conditional formatting dates 05-05-10
I have a range of dates that I want to conditionally format. Eg, todays date is the 5 May 2010. I want to highlight all of the dates in the range D14 to D120 that todays date passes on a daily basis. For eg, as we click over automatically to the 6 May 2010, any fixed dates in the range for the 5 May 2010 turn red. Any help would be great. Select your dates and use Custom in CF and the formula =D4=TODAY()-1 -- Regards Dave Hawley www.ozgrid.com "Sue" <Sue@discussions.microsoft.com> wrote in message news:E87D631B-E455-4698-92A1-BE915192ECDF@microsoft.co...

Money 2004/05
I have recently purchased a new computer and installed Money onto the new computer (Money version says Copyright 2004, but I think it is 2005 version). I have then simply copied across the data files My Money Backup (Microsoft Money backup File) and my money backup2 (Microsoft Money file) to the new computer...For some reason I just cannot get Money to open the data files on the new computer. When I try to open the Money file, I receive the following message; "Money will convert your file so that you can work with it in Money. First, Money will make a copy of your original file, ...

Cannot open Windows mail 02-28-10
I have been running IE8 vista on my Dell xps 630i using CA anti virus, the problem is every now and again when i click on the Windows mail icon i get a message telling me that there is another instance of mail running shut it down and reboot, I have done this I also have done the clean boot but it keeps happening, any suggestions? It is not a Windows Mail problem. You need to figure out what program is doing that to it "pcjones" <pcjones@discussions.microsoft.com> wrote in message news:287C4A5C-85C6-4C29-A9A9-6EF9ADD79BC1@microsoft.com... >I have been ru...

MSN Money Plus dumbing down on 6/28/2006
Cal's MSN Money network status link revealed another tidbit: --- Change of service - discontinuing MSN Money Plus An important change is coming to the MSN Money service. MSN Money Plus will be replaced by the MSN Money service, starting early in July. After the transition, much of the account information you currently have stored by MSN Money Plus will be available through the MSN Money service. Why is MSN making this change? A large majority of MSN Money Plus subscribers do not use the features that are exclusive to MSN Money Plus. Most of the features and functionality of MSN Money Plus...

Windows mail setup 01-25-10
I am trying to set up Windows mail to read my Microsoft Office Live mail. Has anyone done this? All I get is that I need Outlook, but Windows mail says it replaces Outlook,, but the steps I have taken do not work per the e-mail I received from Microsft Office via an e-mail I sent from the site. Any help would be greatly appreciated. Thanks, Bob For your Yahoo account or do you mean from a Live account (or both)? You just set each of them up in Tools - Accounts. Yahoo must be a "Plus" account - see: http://help.yahoo.com/l/us/yahoo/mail/original/mailplus/po...

Spell Check #10
In Outlook 2003 - i have the Spell checker set to English (UK) which works fine on a new e-mail etc. But when you send a reply or forward a mail - it sets back to English (US) any idea??? ...

hallo 10-14-07
Test ...

Simple hack to get $500 to your home. 07-14-10
Simple hack to get $500 to your home at http://easywaytolife.tk Due to high security risks,i have hidden the cheque link in an image. in that website on top side above search box, click on image and enter your name and address where you want to receive your cheque. please don,t tell to anyone. ...

Home based Job For Indian
Want the pleasure of life, don't worry, work 1-2hours/day and earn Rs. 10,000-15,000/month online from your home/cafe/office PC. For details write # ejob1189@rediffmail.com Please write the subject of mail as: "Job Inquiry" hi iam studying B Tech chemical engineering. if any jobs are there i will be greatful to know them ...

String length of a Variable
If I assign a value to a variable (i.e. strNumber) then is there a way to know the number of characters (or text length) in VBA. i.e. strNumber = 1234, I want to be able know there is four characters (or text length). if strNumber = 12, I want to know there is 2 characters. Is there a function that will do that. Thank you. Lamar Len(strNumber) Regards Jeff Boyce Microsoft Office/Access MVP ...

making a chart including only the top 20 (or 10, or whatever)
I have a spreadsheet which shows the sales ratios (among other things of over 100 websites. Is there any way to make a chart that wil automatically update itself to show only the top 20 websites based o their sales ratio -- ayl ----------------------------------------------------------------------- ayla's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2921 View this thread: http://www.excelforum.com/showthread.php?threadid=49114 ...