After quite an elaborate search on the web I had to admit not to be able to find a suitable way to represent questions using the Semantic differential (a.k.a. the Osgood scale as well).
Having both SPSS and MS Excel to my disposal I cannot find an appropriate way to show the output of this kind of questions (like
http://allpsych.com/researchmethods/ima ... ential.gif on the webpage of
http://allpsych.com/researchmethods/res ... tware.html ). In short questions aks the people's opinion of certain (experiential) elements of which every aspect is put on (usually a 7-point) scale ranging from this aspect to its opposite, e.g. questions about a store where the personnel is 1) friendly - unfriendly 2) professional - amateuristic, etc., all ranging from 1 - 7.
My students pose me questions how to use this kind of questions and although it's not difficult to ask people this kind of questions in a survey (paper), the workflow of processing these data in SPSS is still a riddle to me. And after browsing several hours on the web I get the impression it is not a well-known recipe in SPSS or Excel, so I hope someone here knows how to manage this problem.