Skip to main content

Posts

Showing posts with the label reverse scoring in Excel

How to Quickly Score Negatively Worded Survey Items

You can quickly reverse score survey items using widely available spreadsheets like Excel and Google Sheets or SPSS. For example, the freely available scale to measure Valor/ Bravery/ Courage has 10 items rated on a 1 – 5 scale. High scores represent more of the trait. But 4 items are worded as negative statements so, you have to reverse the item scores on the negative items to obtain a correct total score for courage. Sometimes test and survey creators refer to items as + or – keyed. Positive items are added together and the negative items must be reverse scored before adding to the total. Survey Items Example Following are the general directions for the 5-point rating from www.ipip.org Describe yourself as you generally are now, not as you wish to be in the future. Describe yourself as you honestly see yourself, in relation to other people you know of the same sex as you are, and roughly your same age. So that you can describe yourself in an honest ma