I have data from a satisfaction survey and want to see how much responses differed between two questions, the responses ranging from 1(Lowest) to 5(Highest). i.e. If the responses are very close, one will be omitted in future surveys.
I think it would be the Covariance between the two, but am not sure. I entered the data into Excel and calculated the Covariance between the two columns, which was 0.92.
Is this the correct way to go about it, or is there a more appropriate calculation?