3 Replies Latest reply on Jan 12, 2014 4:19 AM by Jonathan Drummey

    Need to convert string to numerical data, e.g. strongly agree converted to 5

    Leslie Henrickson

      I am working with survey lickert data and need to convert a string to numerical data.

      I've been working through the excellent resource here, http://www.datarevelations.com/2012/01, but when it gets to converting string to numerical the example is not in the format of my data, so the solution does not make sense.


      My data only lists the text values:  Poor, Fair, Neutral, Good, Excellent, or Does not apply.

      I need to convert to the number values below. 


      1 = Poor
      2 = Fair
      3 = Neutral
      4 = Good
      5 = Excellent
      6 = Does not apply

      Thanks in advance for your help.