Scroll

How to create a ranking average or summary from a multi-coded question?

How to create a ranking average or summary from a multi-coded question?

Follow

This article explains two methods to analyse rankings captured in an ordered responses, multi-coded question. Both methods use Analyse's 'Create loop' functionality.

Let's imagine we have collected ranking data into a multi-coded question with ordered responses selected.

mceclip0.png

Two potential methods of analysing the data will be explained:

 


 

Calculate the average ranking:

 

1. Create a 'Closed level' variable and name it something like Loop_ranking. Leave the script empty in this case.

mceclip1.png

basic2-175.png To create the item list of your loop question, you can drag and drop the responses from your multi-coded  question.

2. Add a 'Numeric by script' variable and name it something like RankingValues. Set the level of this question to be the new loop you just created, 'Loop_ranking'

mceclip3.png

Add the script

MRQ.Value.IndexOf(Loop_ranking.Value)

 You will now see your created loop in the calculated questions chapter at the bottom:

mceclip4.png 

3. Create a Tab definition: 

mceclip5.png 

Transpose the tab if needed in the General tab > Settings > Breaks

mceclip6.png

Then click on results. You can apply a simple advanced sort on the columns, as shown below, to get the mean values sorted:

mceclip0.png

 

 

Create a ranking summary table:

1. Create a 'Closed level' variable and name it something like Loop_ranking. Leave the script empty in this case.

2. Add a 'Closed by single script' variable and name it something like RankingCodes. Set the level of this question to be the new loop you just created, 'Loop_ranking'. Note that the same script is used as before in the child question of the loop:

MRQ.Value.IndexOf(Loop_ranking.Value)

3. Create a Tab definition as shown below. This time, the transpose option is not required.

mceclip1.png

The result:

mceclip2.png

 

The .qes file and portfolio used in the examples above can be downloaded here.

Have more questions? Submit a request

Comments