| T O P I C R E V I E W |
| mattz00 |
Posted - 10/28/2005 : 10:15:18 AM
Hi
Why when I convert a xy worksheet to a matrix using 2d binning does it miss out a bin in x and y. For example:
Worksheet:
x y
1 0.1
2 0.1
3 0.1
4 0.1
1 0.4
2 0.4
3 0.4
4 0.4
1 0.2
1 0.3
4 0.2
4 0.3
Matrix:
1.5 | 2 |3.5
-------------
0.15 | 1 | 1 | 0 |
0.25 | 1 | 1 | 1 |
0.35 | 1 | 0 | 1 |
When it should be:
1.5| 2 |3.5|4.5
-----------------
0.15 | 1 | 1 | 1 | 1
0.25 | 1 | 0 | 0 | 1
0.35 | 1 | 0 | 0 | 1
0.45 | 1 | 1 | 1 | 1
Is it just a case of me adding an extra bin to the default values displayed in the 'Create Matrix' dialog or am I doing something else wrong? The default values that I get are:
X-min=1, X-max=4, X-Increment=1, Y-min=0.1, Y-max=0.4, Y-increment=0.1
When I use these values the matrix is created correctly:
X-min=1, X-max=5, X-Increment=1, Y-min=0.1, Y-max=0.5, Y-increment=0.1
Thanks for your time.
Matt
|
| 1 L A T E S T R E P L I E S (Newest First) |
| easwar |
Posted - 10/28/2005 : 10:46:06 AM
Hi Matt,
The dialog works with the min and max values of x,y rather than the bin center values which may be more intuitive/logical to specify. Also the default values do not come up correctly in the dialog - we will fix this in the next version.
Looking at your data, I would say the best parameters to specify are as in the picture below, and then when the matrix is created, go to View menu and select Show X/Y to show the bin center x,y values instead of cell x,y index (which I think you already are doing).
Of course if these values are not suitable, you can specify a different set of values in the dialog - the key is to specify the min value (center of first bin - half of width of bin) and max value (center of last bin + half of width of bin) for x and y, and desired width of bin for x, y as increment.
Easwar
OriginLab
|
|
|
