1

I have a spreadsheet with two columns: Zipcode and Housing Price. Is it possible to calculate the average Housing Price per zipcode without manually using Excel commands per zip code?

closed as off-topic by nmtoken, xunilk, BBG_GIS, ahmadhanb, Midavalo Dec 17 '17 at 16:21

This question appears to be off-topic. The users who voted to close gave this specific reason:

If this question can be reworded to fit the rules in the help center, please edit the question.

  • e.g. python, R, name any scripting language as well as a couple of methods in excel itself I guess. I know zip codes are tempting to be thought of as spatial, but in this case, it seems to be a 'simple' table analysis, not strictly related to spatial data and therefor would be better suited for an other board... – ThingumaBob Dec 17 '17 at 10:40
  • An excel pivot table will do it. myexcelonline.com/blog/show-averages-with-an-excel-pivot-table – Emil Brundage Dec 17 '17 at 14:28
1

The easiest way is with an excel pivot table. Here’s a link to a blog.

If you want to do it do it in ArcGIS use Summary Statistics. Use your housing price field as the input field and choose MEAN as your statistics type. Use your zip code field as your case field.

1

In ArcGIS you could do a resume statistics so you can calculate the mean of an attribute for each case of zip code. Just an idea.

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