topic Re: Calculating averages with point data: Deperate for assistance!!!! in Data Management Questions

Calculating averages with point data: Deperate for assistance!!!!

TravMoore — Wed, 21 Nov 2012 00:24:50 GMT

Hi,

I currently have a global map shapefile, superimposed by 8192 data points that show temperature changes (per degree Celsius of global warming) and degrees of latitude/longitude at those locations on the globe. So, for instance, an individual data point would say (when using the "Identify" function) at 180 West, 45 degrees North, the temperature change per degree Celsius global warming is 0.8 Celsius. Each of the 8192 points contain this sort of data.

What I am attempting to do is simply calculate various averages for different regions by somehow combining the necessary points over those regions. For example, if I would like to calculate the average temperature change in the United States, how could I do this using the point data that covers the United States?

Any assistance would be greatly appreciated!

Patiently awaiting your response(s),

~Trav.~

Re: Calculating averages with point data: Deperate for assistance!!!!

DanLee — Wed, 21 Nov 2012 14:49:48 GMT

You can use the Select Layer By Location tool to select points that INTERSECT the US country bounday polygons, and then use the Summary Statistics to get MEAN or other statistical values.

Re: Calculating averages with point data: Deperate for assistance!!!!

TravMoore — Wed, 21 Nov 2012 19:11:05 GMT

Thank you for your response, Dan!

With the function that you had specified, "Select Layer by Location", this can be used to calculate statistics for individual regions on a global map layer, correct?

Thanks again,

~Trav.~

Re: Calculating averages with point data: Deperate for assistance!!!!

DanLee — Tue, 27 Nov 2012 15:07:29 GMT

Yes, if you do one region at a time, you use the two tools, Select Layer By Location with INTERSECT option, followed by Summary Statistics.

If you need to do more regions at once, you can do this:
1. Run Intersect tool to intersect points with regions (or country boundaries).
2. Run Summary Statistics tool using the region/country ID as the Case Field to calculate statistics.