i have two questions with respect to data analysis in SPSS.
I have One Questionnaire on which the data is collected from Employees, now i have other questionnaire on which the data is collected from Customers, now the data that is collected from Employees has 200 Respondents, and i have collected data on another questionnaire from 100 respondents, i want to correlate the variables from Employees Questionnaire and Customers Questionnaire
As i see it, i can add variables in one SPSS file and then correlate them, but in that case there are 100 less respondents for Customers, how shall i do this. suggestions needed
I have collected data on a questionnaire from Employee, the questionnaire is close ended, now i want ot see the influence of Organizational Learning Culture (i have 16 variables, 3 factors) and have 250 respondents, i have the sales figures for 10 years, how do i correlate the questionnaire data (Primary) and sales data.
Q1. I don't think you can correlate them in this way. Each row in SPSS is a respondent and they are different in your two questionnaires (one is Employees and the other is Customers) so you cannot simply copy a variable from you C questionnaire and paste it in your E questionnaire spss file and calculate correlation. Because there is no one-by-one match between them.
Q2. If you mean to correlate OLC (or each of its 3 factors) with Sales figure then you need to compute a new variable in SPSS first. So from Transform menu, choose Compute varilable. Let's say your fact A is composed of 5 questions (likert questions). You need to add the value of the 5 questions and divide them by 5. So the new variable will have the mean of your 5 questions which will be a single value for your factor A. then you can correlate factor A with your sales data.
Q1. Like Hajam wrote, correlation requires a one-to-one match between the two variables (i.e., the same person must provide both values for two separate variables). You may consider other tests which basically tell you the same thing as correlation in that they check for relationships. For example, you can use point-biserial correlation to check the relationship between group membership (0=employees, 1=customers) and a continuous variable. An equivalent analysis is the t-test comparing values of the continuous variable based on group membership.