08 September 2020 5 8K Report

So i have data something like this in SPSS at the moment:

case 1: orange, bananas, mangoes

case 2: bananas, oranges, mangoes

So the first respondent ranked orange as best fruit whilst second ranked banana as the best fruit.

  • The variables i used were strings i.e. o, b and m, should this be a problem?
  • Secondly, how do i assign rank to a particular column e.g. orange should be ranked 1 as it is in left most column, when the data was imported from sogosurvey ? See ranking.png for the actual data
  • Also, is there a quick way to add replacement variable e.g. if the case has value "x" transform it to "yes" and if empty convert it to "no"? The empty cells mean not selected (=no OR 0) and M-multivariate course selected (=yes OR 1) in emptycells.png.
  • Thanks for your help.

    Similar questions and discussions