10 - How to create averages in categorical grid questions in cross tables

Research Studio Analyzer also enables you to create numeric values from semantic, categorical scales. This will most often be a single grid question and can be exemplified with the following:

1. “On a scale from 1 = Totally disagree, 2 = somewhat disagree, 3 = neither nor..”
2. “How often do you….”Every day, 3-5 times a week, once a week, 2-3 times a month…”

If you want to create numeric values based on these categories, you should use the following steps:

1. Select the question(s) you want to edit.

2. Click “Edit“

3. Next to the "Response rows" you have the option "Response columns"

4. To the right of the text labels of the "Response Columns" you may enter the categories "Weight value" in two ways.

4a. For a typical question like “On a scale from 1 = Totally disagree, 2 = somewhat disagree, 3 = neither nor.." type, you might want to set weight values to code values. Just click on "Actions" and select "Set weight values".

4b. For a typical question like "How often do you….”Every day, 3-5 times a week, once a week, 2-3 times a month…" type, you will probably want to enter your own weight values. This can be done very easily by simply entering the respective weight values manually.

The result will be a table where the average (or other numeric values that has been derived from the categories) will be shown below the categories