Reverse Scoring Calculator
Reverse-code negatively worded questionnaire items before you add them up. Enter your scale's lowest and highest points, then convert a single score, read off the full conversion table, or paste a table and reverse only the columns you tick — ready to paste back into your spreadsheet. Free, no sign-up, and nothing leaves your browser.
Results
Enter a score to see it reversed.
Conversion table for a 1–5 scale
| Original score | Reversed score |
|---|---|
| 1 | 5 |
| 2 | 4 |
| 3 | 3 |
| 4 | 2 |
| 5 | 1 |
How to Use the Reverse Scoring Calculator
- 1. Set the scale. Enter the lowest and highest possible scores, or click a common scale such as 1–5 or 0–4. The conversion table below updates straight away.
- 2. Reverse one score. Choose One score and type a value to see it reversed, with the arithmetic written out.
- 3. Or reverse a whole table. Choose A pasted table, paste your responses with one column per item, and tick the negatively worded items. Only those columns change; blanks, text and the ID column pass through untouched.
- 4. Take the result back. Copy the reversed table straight into a spreadsheet or download it as CSV. Reversed columns get _R added to their names unless you untick that option.
The Reverse Scoring Formula
For a scale whose points run from a minimum to a maximum in equal steps, reversed score = (min + max) − original score. The sum of the two ends is the total every pair of opposite answers shares: on a 1–5 scale, 1 + 5 = 6, so 1 becomes 5, 2 becomes 4 and the midpoint 3 stays 3. The constant changes with the scale, which is the mistake people most often make.
| Scale | Formula | Examples |
|---|---|---|
| 1–4 | 5 − score | 1 → 4, 2 → 3 |
| 1–5 | 6 − score | 1 → 5, 2 → 4, 3 → 3 |
| 1–7 | 8 − score | 2 → 6, 4 → 4 |
| 0–4 | 4 − score | 0 → 4, 1 → 3 |
| 0–10 | 10 − score | 3 → 7, 5 → 5 |
The same arithmetic works in any software. In Excel or Google Sheets, =6-B2 reverses a 1–5 answer in B2; in SPSS, COMPUTE Q2_R = 6 - Q2. or RECODE Q2 (1=5) (2=4) (3=3) (4=2) (5=1) INTO Q2_R.; in R, df$Q2_R <- 6 - df$Q2. Write the result to a new column and keep the original, so the raw data stays intact.
Why Negatively Worded Items Are Reversed
Many questionnaires mix statements such as I enjoy statistics with ones such as Statistics makes me anxious. The negatively worded items make respondents read each statement instead of agreeing all the way down the page, a habit called acquiescence. The cost is that those items point the other way: a 5 on the anxiety item means the opposite of a 5 on the enjoyment item. Added as they stand, the two would cancel out real differences between people.
Reversing puts every item on the same footing — a higher score always means more of the thing being measured — before you sum or average items, correlate them, or compute Cronbach's alpha. A reversed item that still correlates negatively with the rest of the scale is a sign that it was misread, mis-keyed or never fitted the scale.
Worked Example
Choose A pasted table and press Load example. Six respondents answered four 1–5 items, and Q2 and Q4 are negatively worded. Tick Q2 and Q4: the tool reports 12 scores reversed, and respondent R01's answers 5, 1, 4, 2 become 5, 5, 4, 4 — a total of 18 instead of 12. R05, who answered 3 to everything, is unchanged, because the midpoint of an odd scale maps to itself.
- Reversing twice. Check whether your dataset, or the scale's manual, has already reversed the items; many shared datasets include ready-made _R columns.
- Using the wrong constant. A scale coded 0–4 needs 4 − score, not 6 − score. Set the lowest and highest points to the codes in your data, not to the labels on the form.
- Reversing the wrong items. Use the scoring key published with the instrument rather than your own reading of the wording.
- Reversing missing-value codes. A code such as 9 for Don't know is outside the scale. The calculator leaves it unchanged and counts it, so you can recode it as missing instead.
Frequently Asked Questions
- How do you reverse score a Likert item?
- Subtract the answer from the sum of the scale's lowest and highest points. On a 1–5 scale that is 6 − answer, so a 1 becomes 5 and a 4 becomes 2. Do it for every negatively worded item before you total or average the scale.
- What is the reverse scoring formula for a 1–7 scale?
- Reversed = 8 − score, because 1 + 7 = 8. That maps 1 to 7, 2 to 6, 3 to 5 and leaves the midpoint 4 where it is. The conversion table in the calculator lists every point once you set the scale to 1–7.
- Should I reverse score before calculating Cronbach's alpha?
- Yes. Alpha assumes every item measures the construct in the same direction, so negatively worded items must be reversed first. If you forget, those items correlate negatively with the rest and alpha drops sharply, sometimes below zero.
- What happens to the midpoint when you reverse score?
- On a scale with an odd number of points the midpoint maps to itself: 3 stays 3 on a 1–5 scale and 4 stays 4 on a 1–7 scale. A scale with an even number of points has no single midpoint, so every answer changes.
- How do I reverse score items in Excel?
- In a new column, enter a formula such as =6-B2 for a 1–5 scale (use the sum of your own lowest and highest points) and fill it down. Keep the original column. To do several columns at once, paste the sheet into the calculator, tick the items, and paste the reversed table back.
- Does reverse scoring work for scales that start at 0?
- Yes — the formula is the same, (min + max) − score. With 0–4 coding the constant is 0 + 4 = 4, so 0 becomes 4 and 1 becomes 3. Using 6 − score on 0–4 data is a common error that shifts every reversed answer by two points.