I was given a data set with a Likert scale (rating 1-5). The data set has around 270 participants, and 8 questions (all with the rating of 1-5). The data has been coded (so it looks like it was taken straight out of Access- including the auto number feature on the far left). However, I need to change the data results to percentages. So, 30% answered with a "1" for a particular question. How do I do this in Excel in a simple fashion that won't give me a headache.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Likert Scale to Percentages of Particpants
etaf
Well-known Member
- Joined
- Oct 24, 2012
- Messages
- 8,322
- Office Version
- 365
- Platform
- MacOS
how is the data structured?
if a one off exercise and not something to be done regularly and you know there are 270 answers -
then you could just sort by question and sum the 1's to get a total number of 1 then divide that by 270
so assuming that range is A2 to A272 = sum(A2:A272) should give you the sum of the ones
and then divide by 270 = Sum(A2:A272)/270
otherwise we need to know a little more about the layout
A pivot table may work
if a one off exercise and not something to be done regularly and you know there are 270 answers -
then you could just sort by question and sum the 1's to get a total number of 1 then divide that by 270
so assuming that range is A2 to A272 = sum(A2:A272) should give you the sum of the ones
and then divide by 270 = Sum(A2:A272)/270
otherwise we need to know a little more about the layout
A pivot table may work
Last edited:
Upvote
0
Similar threads
- Question
- Question
