DIAdem cross classification of data (lambda and temperature)?

[ArtVandelay]

Hi,

I'm looking for a way to cross classify data in DIAdem. I have two rows of data, Temperature and Lambda, which I would like to cross classify in given temperature and lambda bins. IE how often (frequency) is the temperature between 400-410 degrees at the same time as lambda is between 0.91-0.92 .. and so on for all possible combinations.

My english is a bit rusty so I think an example of how the data looks and how I would solve it in Excel looks:

Indata:

lambda Temp
0,920  850
1,000  700
1,000  810
1,100  840
1,000  840
0,980  890
0,970  890
1,000  790
0,950  800
0,400  950
0,400  790
0,700  800
1,020  800

intervals:
lambda temperature
0,9   800
0,95 810
1      820
1,05   830
1,1 840
1,15 850
1,2 

Result:

In each cell in the matrix I use the SUMPRODUCT for the conditions, ex. lambda <0,9 and 820<T<=830. Also note that I want the values outside the boundaries to be counted in the lowest/highest values.

[Ingo_Schumacher]

Hello.

Did you have a look at the function "Combound Classification" in DIAdem ANALYSIS?
If I am understanding your request correctly, it can do an analysis like that.

regards

[ArtVandelay]

Hello, and thanks for your answer. I've looked a bit at the Compound Classification function, but haven't been able to get the results I'd like, but I suspect that is down to myself more than the program,. 🙂 (I am a beginner at DIAdem)

This is the result I'd expect given the listed indata and using the following intervals (see image):

http://img139.imageshack.us/my.php?image=crossclassificationsl2.png

(taken from my Excel calculations - I tried pasting the excel table directly but the forum complained that my message exceeded 10000 characters then.. ?!)

However, I think I'm chosing my intervals incorrectly in DIAdem/Compound Classification, so if anyone could use my indata and reproduce the excel results using DIAdem I'd be very happy to know how.. as it'd show me how to think. 🙂

On a related issue, is there any way to use a list of values as input for intervals as in some cases I'd like the intervals to vary and be smaller around the most interesting point. For example lambda:

(<0.7)
0.7
0.8
0.9
0.91
0.92
0.93
..
1.08
1.09
1.1
1.2
(>1.3)

Thanks in advance,
ArtVandelay