ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   correlation (https://www.excelbanter.com/excel-worksheet-functions/140304-correlation.html)

James is Emusic

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


JE McGimpsey

correlation
 
Your question is undoubtedly clear to you, but it's rather obscure.
Perhaps if you broke the problem down and gave some more detail...

In article ,
James is Emusic <James is wrote:

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



All times are GMT +1. The time now is 09:36 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com