In my research, I am using both primary and secondary data. Data on the independent variable is collected through a questionnaire, while data on the dependent variable comes from secondary sources.
I am looking for the influence of internal service quality (ISQ) on financial performance. I will collect the data on ISQ through a questionnaire from 500 Respondents. Now I will have the earnings per share (EPS) data for last 5 years from banks. How do I perform correlation/regression, since I can't have same value of EPS repeated for every respondent.
For instance, I have earnings per share data from eight banks for the last 5 years, and I have questionnaires filled from employees of eight banks. I will take mean score of the ISQ questionnaire for each of the eight banks and correlate ISQ with the average of the earnings per share of that bank. For instance, looking at the following table, I have calculated the mean of the ISQ for every bank and have the corresponding earnings per share of that bank in the next column. I will put the following table in SPSS and will perform the correlation/regression. Is this the right way to perform this analysis?
BankID Average Internal Service Quality Average Earnings Per Share for 5 years 1 3.5 2.1 2 3.6 2.2 3 4.0 3 4 2.8 2 5 3.8 2.5 6 3.9 2.45 7 4 3.1 8 4.1 3.2