The United States Census Bureau tracks shifts in population by each state and region in the United States. The net migration rate is an indicator of the movement of people from one area to another. A positive net migration rate means more people moved to the area than moved away, and a negative net migration rate means more people left the area than moved to the area. Mathematically, the net migration rate N is defined as follows.

Where I = number of people moving to the area in the year under consideration E = the number of people moving away from the area in the year under consideration M = the mid-year population of the area The file netmigration contains net migration rates for four regions of the United States.

a. Create a heat map using conditional formatting with the Blue-White-Red Color Scale.

b. Which regions are losing population? Which regions are gaining population?

Transcribed Image Text:

(I-E) X1000 M