Hi
I've recently completed a staff survey which involved asking a number of questions which required employees to tick a box on a 5 point scale ranging from Strongly Disagree to Strongly Agree (Likert Scale).
For each of the different offices, I've calculated the average for each question.
I've noticed that there are differences in the average responses for our 5 offices. For instance, the average response to one question for our Slough office was 4.3 but, for the same question, for our Oxford office it was 3.9.
I want to know if this difference is significant. What test would I use?
Is there an Excel command that would calculate this?
Thanks in advance.
Rich
I've recently completed a staff survey which involved asking a number of questions which required employees to tick a box on a 5 point scale ranging from Strongly Disagree to Strongly Agree (Likert Scale).
For each of the different offices, I've calculated the average for each question.
I've noticed that there are differences in the average responses for our 5 offices. For instance, the average response to one question for our Slough office was 4.3 but, for the same question, for our Oxford office it was 3.9.
I want to know if this difference is significant. What test would I use?
Is there an Excel command that would calculate this?
Thanks in advance.
Rich