#1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default correlation

Im trying to find the correlation between multiple variables using alpha to
numerics.

I need to find if there is a correlation bewteen multiple users based off of
their hr profile #, security profile, location, cost center, supervisor, etc.



Im not sure how to present all of these correlations as one string
graphically. Can correlation only be used between 2 variables at a time?
Would i do 2 variables at a time and graph multiple series of correlations?
What are dependant or independant variables how do i go about chosing the
correct one for this situation?

I would of course have to convert all of the alpha, but still dont know the
correct way of approaching this. I've been told that using
frequency/correlation would ultimatley be the solution, but frequency doesnt
really seem to help. Its really only counting the info.

Thanks,

James

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Correlation of data The Rook[_2_] Excel Discussion (Misc queries) 1 March 1st 07 03:33 AM
correlation p values becd Excel Worksheet Functions 3 June 30th 06 09:05 AM
Correlation Matrix katie Excel Worksheet Functions 5 May 16th 06 07:21 PM
Correlation-Coefficient daniel chen Excel Discussion (Misc queries) 3 January 31st 06 07:59 AM
Correlation between 2 or more variables [email protected] Excel Discussion (Misc queries) 2 November 25th 05 11:52 PM


All times are GMT +1. The time now is 12:00 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"