Example of recoding ranges of numbers

A professor wants to recode numeric grade averages (from 0-100) to letter grades. The professor wants to recode all averages that are 90 and above to the letter A, averages that are at least 80, but less than 90 to the letter B, and so on.

  1. In the column name cell, enter Average.
  2. Copy and paste, or type the following data into the Average column:
    90.1
    90.0
    89.9
    73.1
    95.3
    70.0
    68.5
    85.5
    80.0
    88.5
  3. Open the Recode to Text dialog box.
    • Mac: Data > Recode > To Text
    • PC: DATA > To Text
  4. In Recode values in the following columns, enter Average.
  5. From Method, select Recode ranges of values.
  6. In the table, enter the following:
    Lower endpoint Upper endpoint Recoded value
    90 101 A
    80 90 B
    70 80 C
    60 70 D
    0 60 F
  7. For Each range shall include its, deselect Upper endpoint.
  8. Click OK.

Results

The recoded values are in a column of the worksheet.

C1 C2
Average Recoded Sample from Average
90.1 A
90.0 A
89.9 B
73.1 C
95.3 A
70.0 C
68.5 D
85.5 B
80.0 B
88.5 B
By using this site you agree to the use of cookies for analytics and personalized content.  Read our policy