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.
These are the cells that hold the actual data you are caclulating (ex: 10, 134)
The results show the majority country in the field: