Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Intersection, union and difference
Hi,
I have a math problem related to intersection, union, and difference among elements within groups (sometimes more than 10 groups). In all cases each element of a group has an associated standard deviation. In such way, I need that the intersection bettwen pairs of groups and among several groups could be addressed as well as the differences. In addition, if in groupo A I have a value like 600 +- 2 and in group B I have a value 599 +- 2 such values should be considered the same as their standard deviations did not allow distinguish them as distinct numbers.. Data are in columns like bellow: Group A Group A standard deviation Group B Group B standard deviation 1254 2,3 1251 2,56 2545 3,35 2354 1,23 3545 3,2 3551 3,1 5425 2,1 1214 1,1 652 1,2 1524 1,12 I this way in the other columns I would like to see The intersection, difference, and union of such groups and others. Do you have some suggestion in which could I use excel to perform such math operations in columns and display the results? best regards, Luciano |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Intersection, union and difference
paulinoluciano escreveu: Hi, I have a math problem related to intersection, union, and difference among elements within groups (sometimes more than 10 groups). In all cases each element of a group has an associated standard deviation. In such way, I need that the intersection bettwen pairs of groups and among several groups could be addressed as well as the differences. In addition, if in groupo A I have a value like 600 +- 2 and in group B I have a value 599 +- 2 such values should be considered the same as their standard deviations did not allow distinguish them as distinct numbers.. Data are in columns like bellow: Group A Group A standard deviation Group B Group B standard deviation 1254 2,3 1251 2,56 2545 3,35 2354 1,23 3545 3,2 3551 3,1 5425 2,1 1214 1,1 652 1,2 1524 1,12 I this way in the other columns I would like to see The intersection, difference, and union of such groups and others. Do you have some suggestion in which could I use excel to perform such math operations in columns and display the results? best regards, Luciano |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Intersection, union and difference
-
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|