nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Academic Webinar – Survey Analysis Fundamentals

Ross_Metusalem

Get JMP software free for academic use at jmp.com/student

Survey data is ubiquitous in social science, business, and healthcare research, and its analysis poses special considerations and challenges. This webinar reviews fundamental survey analysis techniques and how to implement them in JMP, including:

Preparing survey data for analysis (e.g., recoding response levels, handling multiple-response questions)
Creating custom cross-tabulation tables
Effectively visualizing and analyzing large groups of categorical responses
Mining information from free text responses

Comments

frankowa

Hi, please with the attached picture to this comment, it's a situation where in a survey the respondent has to rate different types of methods. But all ratings are in a cell and I want to know how to make them independent so I can convert them to continuous variables.

Screenshot 2024-09-03 011902.png

MarkovHedgehog9

can not see do not wachr

Ross_Metusalem

@frankowa, that's not an ideal data format, but you can clean it up with JMP.

First, Import the Excel sheet, select each ratings column and then go to Cols > Utilities > Text to Columns. Check the NEWLINE box and click OK. You'll now have one column per rating item, though the item text (e.g. "Traditional in-person exams") will still be there.

We'll use Recode to extract just the numerical values and get rid of the text:

Select all the new columns you just created, then go to Cols > Standardize Attributes.
Click the Recode button.
In the Recode tool, click the red triangle and go to Advanced > Extract Segment.
Enter "2" as the Start Anchor and End Anchor to extract just the numerical values.
Click OK to close Extract Segment and then Recode back in the Recode window.

Each rating item should now have all its numerical data in its own column as in the example data set I've attached.

Sheet1.jmp