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?

2
  • 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...
    – geozelot
    Dec 17, 2017 at 10:40
  • An excel pivot table will do it. myexcelonline.com/blog/show-averages-with-an-excel-pivot-table Dec 17, 2017 at 14:28

2 Answers 2

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.