# Thread: How to compare two different surveys in order to look for a correlation?

1. ## Re: How to compare two different surveys in order to look for a correlation?

It still don't work? Hm..

2. ## Re: How to compare two different surveys in order to look for a correlation?

I just want to say that I really appreciate your responses on my posts! I am really stuck, and it really helps to get others perspective on it, especially when I am not the biggest number/statistics person. And it seems like you have a pretty good control in this field

I might be asking for to much, but say no if it is: is it possible for you to send me a print screen of how to put it in SPSS?

I assume I need separate files for all my managers and their subordinates?

Regarding the EQ questionnaire, do I just summarize their answers in order to get their scores (giving the reverse answers high scores)?

Regarding the org.com I have divided the questionnaire in to 3 categories and put the respective question under each category. Is it use for me to sum up? (Do I calculate the average for each team in each category?)

Im sorry for all the simple questions, but for a person who has never done it before they are hard

Please let me know if I am asking for too much!

3. ## Re: How to compare two different surveys in order to look for a correlation?

I just want to say that I really appreciate your responses on my posts! I am really stuck, and it really helps to get others perspective on it, especially when I am not the biggest number/statistics person. And it seems like you have a pretty good control in this field

I might be asking for to much, but say no if it is: is it possible for you to send me a print screen of how to put it in SPSS?

I assume I need separate files for all my managers and their subordinates?

Regarding the EQ questionnaire, do I just summarize their answers in order to get their scores (giving the reverse answers high scores)?

Regarding the org.com I have divided the questionnaire in to 3 categories and put the respective question under each category. Is it use for me to sum up? (Do I calculate the average for each team in each category?)

Im sorry for all the simple questions, but for a person who has never done it before they are hard

Please let me know if I am asking for too much

4. ## Re: How to compare two different surveys in order to look for a correlation?

You are so wellcome

is it possible for you to send me a print screen of how to put it in SPSS?
Well, you simply open your SPSS and select the "new file" option. Then assign the names of your questions to the column headers. Assign each participant (represented by a number) to the row headers. Then type in the scores into the cells.

I assume I need separate files for all my managers and their subordinates?
Yes you have to create two SPSS files, one for managers, and one for subordinates. You can use one of the two methods mentioned in my recent post to merge yur two files, into one file in which each row simultaneously represent a manager and a subordinate. Or, each row represents a department (a manager, the average value of all his subordinates).

Regarding the EQ questionnaire, do I just summarize their answers in order to get their scores (giving the reverse answers high scores)?
I don't know how exactly EQ tests work. Maybe you have a questionnaire with a key which shows you how to give the full score and the zero score to each question. Based on your key, you can convert the responses of the managers into numerical scores. Then you can sum up the total scores of each EQ questionnaire, which is the EQ score.

Regarding the org.com I have divided the questionnaire in to 3 categories and put the respective question under each category.
That seems fine.

Is it use for me to sum up? (Do I calculate the average for each team in each category?)
After you converted the true/false answers into numerical scores, you can do the followings:

1. You can involve the numerical score of each question into your statistical analysis. Each question score will have a separate column in your file.
2. You can sum up the scores of each of these categories into one score. Now each category will have a column.

For summing up the scores in each category you can either simply "sum up" the numerical scores of all the questions in that category, or calculate the average score of the questions in that category. I personally prefer the former, because when you are dealing with ordinal data, it is better to use integers without decimal places. But using average values is also correct (but a little problematic).