How to Create a Custom Index Score Using R

This article describes how to use a summary grid table...

..to calculate an index score using the data from the table (e.g., an index score base on the following formula: Top 2 Box / (Top 2 Box + Bottom 2 Box) x 100):

Requirements

A table with multiple rows and columns.

Method 1 - Using column names 

1. Select your table.

2. Copy the table name from General > General > Name.

3. Click Calculation > Custom Code from the toolbar.

4. Click onto the page to place the object.

5. In the R Code editor, add a line defining the table based on the name from step 2, e.g. brand_att = table_name

6. Now paste in the below code to set and calculate the index formula:

t2b = brand_att[,"Like"] + brand_att[,"Love"]
b2b = brand_att[,"Hate"] + brand_att[,"Dislike"]
numerator = t2b
denominator = t2b + b2b
index = (numerator / denominator) * 100

Note: the above code is based on the table shown above and refers to column names "Like", "Love", "Hate", and "Dislike" which can be changed to match column names used in your table. 

Method 2 - Using the column index 

1. Select your table.

2. Copy the table name from General > General > Name.

3. Click Calculation > Custom Code from the toolbar.

4. Click on the page to place the object.

4. In the R Code editor, add a line defining the table based on the name from step 2, e.g. brand_att = table_name

6. Now paste in the below code to set and calculate the index formula:

t2b = brand_att[,4] + brand_att[,5]
b2b = brand_att[,1] + brand_att[,2]
numerator = t2b
denominator = t2b + b2b
index = (numerator / denominator) * 100

Note: instead of column names the above code referred to column index. E.g., [,4] refers to the fourth data column in our table "Like".

Next

How to Create a Custom Index in a Table