1

This question already has an answer here:

I am using ArcMap 10.6.

I have a table with country data. I am interested in Asia only, so I created a new layer (and shapefile). Several countries have missing data, which was filled with the same value (-50). One of the fields is Life Expectancy and another is Access to Drinking Water(population percent). I classified the Life Expectancy field (about 30 unique values) into 5 classes (in the symbology tab). I don't know how to group the countries by class (in the attribute table) so I can calculate various stats by class.

For example, What is the mean Access to Drinking Water, by Life Expectancy class?

marked as duplicate by PolyGeo Feb 5 at 21:23

This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.

  • 2
    Have you looked at the Summary Statistics tool? – PolyGeo Feb 4 at 20:00
  • I have looked but found nothing on the classification part. – Horia Popa Feb 4 at 22:35
  • You said that you already have the five class values from your classification for symbology so you could use the Field Calculator to update a field you then use to group by in Summary Statistics. – PolyGeo Feb 4 at 22:47
  • Create classes in new field gis.stackexchange.com/questions/177652/… and use summary statistics. – FelixIP Feb 5 at 7:24
0

If you want a ratio between the two columns, use the field calculator and divide Access to drinking water by Life expectancy and save the results in a new field.

If you want to compare the two fields go to "view -> graphs -> create Graph" and you can see the results on a line graph or a scatter plot.

you also can use the 3-dimensional graphs with 3 fields of Access to water, Life expectancy, and state names.

If you want to represent the data as classes in your map, use symbology -> multiple attributes.

Not the answer you're looking for? Browse other questions tagged or ask your own question.