AnsweredAssumed Answered

Statistical analysis

Question asked by jhansen88 on Sep 24, 2015
Latest reply on Sep 24, 2015 by oluwafemiid

Hi, I have an attribute table that has a column for rivers, each river has many rows and each row is related to a specific year.  I have another column for values, each value is related to a river and its rows.  What I need to do is group the river and its rows together and calculate the average value for each river.  Then using the symbology feature create 5 categories for the rivers using natural breaks.  Finally I need to rank each river based on the natural breaks categories. 

 

I am able to perform each of these tasks but on a manual basis. Such as highlighting each river and rows, and using the statistics feature document in a newly created column the average for that river.  I can do the same with the ranking by adding a new column and manually entering a rank based on the results of the symbology.

 

What I am wondering is if there is a simpler way to do this.

Thanks,

Jane

Outcomes