754665_en-US

liliconcom

Academic Webinar – Survey Analysis Fundamentals

 

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

Basic Data Analysis and ModelingConsumer and Market ResearchData Exploration and VisualizationRe: Academic Webinar – Survey Analysis Fundamentals

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.

Re: Academic Webinar – Survey Analysis Fundamentals

can not see     do not wachr

 

Re: 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.