topic Re: Calculate Geometric Mean in Geoprocessing Questions

Calculate Geometric Mean

AmySmith3 — Mon, 11 Feb 2013 20:31:20 GMT

Hello!

Does anyone happen to know if it's possible to calculate geometric mean as a summary statistic in ArcGIS 10.1?

Thanks,

Amy

Re: Calculate Geometric Mean

DaleHoneycutt — Tue, 12 Feb 2013 02:40:47 GMT

Try the Mean Center tool

Re: Calculate Geometric Mean

AmySmith3 — Tue, 12 Feb 2013 02:54:21 GMT

Try the Mean Center tool

Thanks for the suggestion! Do you know if I would be able to use the Mean Center tool to calculate geometric mean (as opposed to arithmetic mean) for a field that contains numeric values (such as integers or floats), rather than the shape's geographic coordinates?

Take care,

Amy

Re: Calculate Geometric Mean

DaleHoneycutt — Tue, 12 Feb 2013 02:58:14 GMT

You can input a Weight Field to the Mean Center tool -- is this what you mean?
For more information, take a look at the "how it works" doc.

Re: Calculate Geometric Mean

AmySmith3 — Tue, 12 Feb 2013 03:07:22 GMT

You can input a Weight Field to the Mean Center tool -- is this what you mean?
For more information, take a look at the "how it works" doc.

Although the data I'm working with is spatial in nature, the statistical calculation (described here: http://en.wikipedia.org/wiki/Geometric_mean) would not require using a feature's spatial information. For example, if performing a Dissolve, I would like to use the geometric mean (as opposed to arithmetic) as a merge rule.

Re: Calculate Geometric Mean

DaleHoneycutt — Tue, 12 Feb 2013 03:15:12 GMT

Ah... that geometric mean!
Not that I know of. I'll have to do some checking. For sure Dissolve doesn't have the option.

Re: Calculate Geometric Mean

AmySmith3 — Tue, 12 Feb 2013 03:30:04 GMT

Ah... that geometric mean!
Not that I know of. I'll have to do some checking. For sure Dissolve doesn't have the option.

Thanks! I'm sure it could be done with some Python scripting, but it would certainly be quicker and easier if a geoprocessing tool such as Dissolve provided that option. I thought it couldn't hurt to ask. 🙂

Re: Calculate Geometric Mean

MichaelAugust — Fri, 31 Oct 2014 18:13:51 GMT

Hi Amy - Did you ever find a way to do this in ArcMap?

Re: Calculate Geometric Mean

AmySmith3 — Fri, 31 Oct 2014 18:38:31 GMT

Hi! We ended up using Python scripting outside of ArcMap and arcpy.