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:

=INDEX(C$1:T$1,MATCH(MAX(C3:T3),C3:T3,0))

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)

C3:T3

The results show the majority country in the field:

Leave a Reply

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