ArcGIS Pro

Explore the New Calculate Composite Index Tool in ArcGIS Pro 3.1

With the release of ArcGIS Pro 3.1, you now have access to a new tool in the Spatial Statistics toolbox: Calculate Composite Index.

Screenshot of the Calculate Composite Index tool in ArcGIS Pro

What is an Index?

Composite indices are commonly used across social research, epidemiology, government programs, and more, to measure complex phenomena using a single indicator. The new Calculate Composite Index tool provides a workflow and guidance to help generate these indices.

Case Study – Mapping Severe Influenza Risk

Data Source

Understanding the problem and choosing variables

Suppose a group of public health analysts want to target their flu season health campaigns at a more local level by understanding what areas of the country are most at-risk for severe cases of influenza.

There is no single measurable variable that can tell the analysts here are the places where people are most at-risk. Being at-risk for severe cases of influenza comes from multiple attributes that each are measurable on their own and can be combined to measure the larger theme of Severe Influenza Risk. The new Calculate Composite Index tool can help achieve this goal.

One way to break up the influenza risk problem is into two parts – Risk factors and Vaccination status.

a flow chart showing how flu risk can be broken up into risk factors and vaccination

Risk factors can be further broken up into % of people over 65, and % of people reporting poor/fair health. Vaccination Status can be directly measured by % of people receiving a flu vaccination.

Map of the contiguous U.S. showing the percent of people over 65 in each county
Map of the contiguous U.S. showing the percent of people reporting poor or fair health in each county
A map of the contiguous U.S. showing the percent of people that receive a flu vaccination in each county

Each of these variables can be added as inputs to the Calculate Composite Index tool.

Screenshot of the Index tool showing the drop down to input variables

When calculating an index, it’s important to ensure that each of your variables are contributing to the phenomenon you’re measuring in the same direction. In this case, as each of our variables increases, we would like for Severe Influenza Risk to increase as well. For the Risk factors variables this is already true. As the % of People over 65 increases, so does risk. However, for the vaccination variable, we see the opposite effect. As the % of People vaccinated for influenza increases, risk decreases. To flip this relationship, we can check the Reverse Direction box next to the vaccination variable. This reverses the relationship, so as the % of People vaccinated for the flu decreases, risk will increase.

Screenshot of the index tool showing the Reverse Direction checkbox

Though each of the variables are represented as percentages, their ranges differ. When combining variables that are not in the same units or range, there are several ways to preprocess the variables before combining. A simple way to preprocess the variables is through a method called min-max scaling. This method transforms each variable so its minimum value is equal to 0 and its maximum value is equal to 1. Min-max scaling does not change the shape of the distribution, so if the distribution is skewed or has an outlier to begin with, it will also be skewed after scaling.

A graphic showing the before and after of minmax preprocessing

Once variables are preprocessed, they must be combined using a mathematical operation such as sum or multiplication. The preset methods in the tool can be used to specify a preprocessing method and a combination method. The first preset in the tool – Combine values (mean of scaled values) – applies min-max scaling to preprocess, then mean to combine.

A screenshot of the Index tool showing the preset combination method

Output Settings

To further customize the index output, a custom name can be specified, such as Severe Influenza Risk. Additional outputs can also be specified – these postprocess the output index to make the results more interpretable. In this case, if the analysts are interested in understanding what counties might have much higher than average risk the Standard deviation class could be selected as additional output, since standard deviations are measured in relation to the average.

Screenshot of the index tool showing the output settings, including the check box for Standard deviation selected.

Once all the settings have been specified, the tool can be run.

Results and Interpretation

The Calculate Composite Index tool outputs the Severe Influenza Risk Index as an average of each of the preprocessed variables. Counties in purple have higher risk, and counties in light blue / white have lower risk.

Map of the contiguous U.S. showing the raw flu risk Index as a mean of the preprocessed inputs

The second output is the Standard Deviation classes. The darker purple areas can tell us which areas have risk much higher than average since their values are at least one standard deviation above the mean. Public health analysts could prioritize the purple areas for their influenza vaccination and education campaigns.

Map of the contiguous U.S. showing severe influenza risk in standard deviation classes.

Investigating an individual feature’s results can help reveal more about what leads to a higher or lower risk index value. The feature below in New Mexico appears as dark purple in the standard deviation classes map.

Map that shows the county in New Mexico that will be chosen for the pop-up

In the pop-up, you can see the variables’ original values, as well as their preprocessed values. While, in this county, there is not a particularly high percent of people reporting poor health (the min-max value is ~0.3 in a possible range of 0 to 1), the percent of people over 65 is relatively high, and the percent of people receiving flu vaccinations is relatively low. The variables driving this county’s risk to be over three standard deviations higher than the average are the age of its citizens and the low vaccination rates.

A pop-up showing the original inputs and preprocessed inputs for a selected feature.

The tool also creates several useful charts, including the distribution of the index, the distributions of the input variables, and the relationships and correlations between variables.

A histogram showing the distribution of the index

Conclusion

The Calculate Composite Index tool can help researchers, policy makers, and analysts create an index to quantify immeasurable phenomena by combining together the measurable components of the problem. See the links below to learn more about how the Calculate Composite Index tool works, and best practices when creating a composite index.

Resources

Calculate Composite Index Documentation

How Calculate Composite Index Works

Calculate Composite Index Best Practices Technical Paper

Organisation for Economic Co-operation and Development Handbook on Constructing Composite Indicators: Methodology and User Guide

 

About the author

Catherine McSorley

Catherine McSorley is a Product Engineer on the Spatial Statistics Team at Esri.

Connect:
Subscribe
Notify of
0 Comments
Inline Feedbacks
View all comments

Next Article

Introducing Create Spatial Sampling Locations tool in ArcGIS Pro 3.3

Read this article