cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
JMP is taking Discovery online, April 16 and 18. Register today and join us for interactive sessions featuring popular presentation topics, networking, and discussions with the experts.
Choose Language Hide Translation Bar

Calculating average of zonal data in contour map

Hi Guys,

I have this contour map which is divided into several square zones (4x4). I wanted to calculate the average of all the data points in all the zones (e.g. say Average of Z1 = , Average of Z2 = , )on the contour map. The number of points in a zone varies at the edge of the circular countor map.
Is there an easier way of doing this other than manually selecting data points from each zone, labeling them into a different column (where it assigns a 1 or a 0) and then take the average?
Thanks.
12 REPLIES 12

Re: Calculating average of zonal data in contour map

Anybody? Sorry for the push but I would appreciate any help asap..
mpb
mpb
Level VII

Re: Calculating average of zonal data in contour map

I'm not sure I understand exactly what you have said about your zones. If you can identify which zone each point (row) is in by some algorithm then you can make a new column called Zone that identifies each point (row) as being in Zone z1 or z2 or z3 etc. Then you can use Tables>Summary to find the mean of whatever columns you want by Zone.

Re: Calculating average of zonal data in contour map

So how do I get the data values from each zone in a different table?

I can select the data points on my contour map with the lasso tool and then see the data values highlighted in the data table. Do I have to copy all the selected rows and make a new table for each zone?

Re: Calculating average of zonal data in contour map

"then you can make a new column called Zone that identifies each point (row) as being in Zone z1 or z2 or z3 etc"


In other words, how can I do this easily?
ms
Super User (Alumni) ms
Super User (Alumni)

Re: Calculating average of zonal data in contour map

I am not sure of how you came up with the zones. Have you specified the grid by your self or did JMP do that automatically? In any case you may have to set up an conditional statement to decide in what zone each point reside, e.g.

Re: Calculating average of zonal data in contour map

Thanks for your response, MS.

Yes, I am using a script to generate a grid which I superimpose on top of my contour plot, so my zones are predetermined and do not change. Now when I select the data points inside each zone (say zone Z1)with the lasso tool, I can see that the data points (i.e. corresponding rows for all columns) for that zone (Z1) are highlighted in my data table. Now what I want is something like this:

Zone Average of data in zone for a particular column
Z1 X
Z2 XX
Z3 XX
Z4 XX
Z5 XX

and so on.

How do I get the Zone column and the Average column?
ms
Super User (Alumni) ms
Super User (Alumni)

Re: Calculating average of zonal data in contour map

Using my first suggestion you assign the zone to each row by applying the appropriate conditional formula. This can be done by script or by a column formula in the data table. Then, once you have given each row its zone label (Z1 etc.) you can use the Summary command in the Tables menu get the mean for each zone, as suggested above.

If your zones equally sized and defined exactly by the ranges of your x and y data, then my second suggestion would work fine (i just tested with a small data set). Just choose the save/generate grid (present in JMP 8 at least) and specify 4x4 grid. And you will get a data table with 16 rows, 1 for each zone, and a column with the mean of all data within each zone. The zones are of course not named Z1 etc but rather defined by the grid cell borders.

Re: Calculating average of zonal data in contour map

Ok I am trying to use your first suggestion. So I went on the contour map, and used Customize and added a script and then entered the following:

Zone=If(And(1<=X<2,1<=Y<2), "Z1", And(2<=:X<3,1<=:Y<2), "Z2"))

I then hit Apply and Ok but it did nothing, no errors too. Where am I supposed to see the rows with zones? Would they be in the raw data table?

Re: Calculating average of zonal data in contour map

Don't know why it didn't take all my feedback.

Anyway, I went on the contour map, and used Customize and added a script and then entered the following:

Zone = If(
And( 1 <= X < 10, 1 <= Y < 20 ), "Z1",
And( 20 <= :X < 45, 21 <= :Y < 67 ), "Z2"))

When I hit OK, it did something but I did not get any error in the log window.
So,where am I supposed to see the newly assigned zones? Will those be in the data table?