Academic Webinar – Survey Analysis Fundamentals

@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.