Example for calculating an index

This formula illustrates how you would calculate a “majority index” for a range of fields.¬† For example, you may have a dataset that illustrates foreign born Asians, and would like to know which country has the most foreign born’s in each census tract.

To create an index, you can add a new column, and fill in the following forumla:


These are the header values that will go into the cell (ex: Japanese, Korean).  This is specific to this dataset, so it will need to be adjusted accordingly.

C$1: T$1

These are the cells that hold the actual data you are caclulating (ex: 10, 134)


The results show the majority country in the field:

Leave a Reply

Your email address will not be published. Required fields are marked *