Let’s say that my survey has 2 sections that I want to find the correlation between, they each have 5 questions with each question being a 5-point Likert scale. What do I do after? What are the steps to doing this in Excel? I can't seem to find any good guides on how to do correlation with Likert scale variables. I was also told that I should test for normality and check for linearity with a scatter plot before I begin with correlation, but I can't find a guide about it for Likert scale variables either.
Spearman's rho ranks values in your data based on how they compare between each-other. In order to rank them uniquely, we need unique values. A Likert scale only has 5 or 7 possible values. Therefore, you are not supposed to correlate two Likert scales with Spearman's rho.
The reason why you have not found a good guide about Spearman's rho for Likert scales is because you do not actually calculate Spearman's rho with ordinal data.
Spearman's rho takes in quantitative (metric) data, as its input, and ranks it based on N (number of responses). For example, if you have 20 respondents, that means you have 20 ranks. If you have 1200 responses you have 1200 ranks.
A Likert scale by its definition is ordinal (qualitative) data, meaning A < B < C, but A + A does not equal B. Or another example: A + B does not equal C.
Furthermore, if we ignore the rule for ordinal data for Likert scale (which many people do, apparently), and treat it as a quantitative variable you still end up with 5 unique values for your variable.
Spearman expects each value to be unique so we can rank them uniquely: 23 is rank 1; 25 is rank 2; 34 is rank 3; 55 is rank 4; 64 is rank 5; 68 is rank 6; 75 is rank 7; 99 is rank 8; 110 is rank 9; 255 is rank 10;
How do you assign unique rank to data that looks like this:? 1; 1; 1; 2; 2; 3; 3; 4; 5; 5;