Grouping Answers for Measures in Advanced Exploration

by Phil A.

This use case examines how to group answers for a Measure variable in Advanced Exploration in order to simplify your analysis.  

A common example for this use case includes creating "Top Box" and "Bottom Box" groupings to analyze your Overall Experience data

 

For this use case, we'll address the following request: 

 

I want to group those who answered 8, 9 or 10 to my Overall Experience question.

 

Step 1: Right-click the Overall Experience question in the Measures menu, and select “Create Calculated Field”

 

A new window will appear within which you can provide a name for this new variable, as well as specify how this variable will be calculated.

 

Step 2: Give a score to those who answered 8, 9 or 10 to the Overall Experience question

You can use an IF / ELSEIF statement to identify those who answered 8 or greater to the Overall Experience question. First, identify those who answered 8 or greater to this question, and assign them a score of 100:

IF ([Q Overall Experience(Score) (QID-1)] > 7) THEN 100

 

Step 3: Give a score to those who answered 7 or lower to the Overall Experience question

Since the analysis will be focused on solely those who answered 8 or greater to the Overall Experience question, then an ELSEIF statement can be used to exclude those who answered 7 or lower to the Overall Experience question by assigning them a score of 0:

ELSEIF ([Q Overall Experience(Score) (QID-1)] < 8) THEN 0

 

Step 4: Close the if / elseif statement

Once you have completed entering your conditions, make sure to include END at the end of these conditions:

IF ([Q Overall Experience(Score) (QID-1)] > 7) THEN 100

ELSEIF ([Q Overall Experience(Score) (QID-1)] < 8) THEN 0

END

 

When your calculation is considered valid, click “OK” to save your new variable.

 

This new calculated field will now be shown in the Measures menu.  

When analyzing this new variable above in your analysis, you must ensure that you are evaluating it as an average. The score you would be shown is the percentage of those in the Top 3 Box for Overall Experience (e.g. 0.00, 50.00, 75.74, 100.00).

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments

Powered by Zendesk