3 ms·
SPSS user here, I run a bunch of surveys in Qualtrics and SurveyMonkey, and frequently use their export to SPSS file functionality. Often, I have questions tha
by abakker 9y ago
SPSS user here, I run a bunch of surveys in Qualtrics and SurveyMonkey, and frequently use their export to SPSS file functionality.
Often, I have questions that take the format of "for each of the following categories please rank them between strongly disagree and Strongly agree". The way these questions end up in the SPSS files are typically as different variables for each row, and a 1,2,3,4, or 5 as the measurement along with the labels.
Frequently, I want to pivot those types of questions by a variable like Region or Number of Employees (categorical), and then see the resultant tables. This is never fun, and inevitably takes a lot of time.
As others have said, statistics is a careful business that doesn't necessarily warrant ease of access to all mathematical functions BUT, handling what SPSS calls "Multiple Response Sets" better would be a godsend, just for the data prep and visualization step. I still ultimately fall back on recoding these or leveraging the MRS functional in SPSS to get this done (sometimes this is better than just using pivot tables in excel).
It would be great to be able to specify this kind of thing in this program, since without it, you can't really use/trust the computed percentages in some question configurations. Take a real look at the SPSS Tables feature, the Multiple Response Sets, and then visualization of them, and consider how that data is actually coded in SPSS files (the common export of survey tools) and maybe you can improve on that feature (It shouldn't be hard, MRS is a pretty bad setup, but it gets the job done).