37
Reverse Coding – A Step-By-Step Example to reverse-code item T2
• Find item T2 on the data Excel sheet.
• Add a blank column to the very right of the T2 column.
Right click on T3 and insert an entire column. This adds
a blank column to the right of the T2 column.
• Label the new blank column T2R.
• Place the cursor in the first cell of T2R’s column (row 2).
• Enter this formula =8-AO2 and press the enter key. You should see
reverse code of the original number (i.e., 2 is now 4). Note that
when you drag down to the rows below, Excel automatically
changes your formula (e.g., “=8-AO2” changes to “=8-AO3” in the
next cell down, and so on).
• Repeat this procedure for all variables in the codebook that need
recoding. If you see an R in the first column of the codebook, the
adjacent variable needs to be recorded.
NOTE: Do NOT delete the T2 column. Leave it be
.