3

I would like to calculate the average, max and min of each trips that I have. Each trips are also predefined (e.g. Trip 1, Trip 2) in the attribute table. (As below). I have more than 2000 trips.

The question I have is - how do I calculate the average, max and min speed for each trips? Do I use the field calculator? If so, how do I type my command?

enter image description here

0

Just do a dissolve on Trip, then in the Statistics Field(s) just add the fields and the statistic type you want to be added to the attribute table.

http://pro.arcgis.com/en/pro-app/tool-reference/data-management/dissolve.htm

This has the added benefit of keeping the geometries for your data.

  • I'm glad it worked for you! – crld Apr 14 '16 at 16:42
0

Use the Summary Statistics tool:

enter image description here

This is the output:

enter image description here

0

You can use the summarize tool on the field Trip, and in the summary statistics, select the relevant fields to calculate statistics for, like ave, min, max etc.

enter image description here

The result is a table with a row for each trip, and a column for each statistic.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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