Forum Discussion
Reverse scoring
Hi, Is there an automatic way to reverse score? I know the equation but it is slow and clumsy when you have multiple columns to reverse score. Thanks.
Sorry, very late. But fear not, as I am doing an assignment where I need to reverse the scores of a variable.
Say you have a 7-point Likert scale, in a new column add the max value (7) and the min value (1), and then subtract the original value. You type "= 8 - A2" and drag this formula down.
1 -> 7
2 -> 6
3 -> 5
4 -> 4
5 -> 3
6 -> 2
7 -> 1
This works for smaller and bigger scales. I am pretty sure some statistical programs have a function that reverses scores, but no clue on that. With this formula you can just transform the data in excel before you plug it somewhere else to conduct tests