Use Pairwise Differences to calculate and store the differences between each possible pair of values from two columns. For example, the following data set contains four pairs: {2, 1}, {2, 3}, {5, 1}, and {5, 3}. The pairwise differences equal the differences between the values in each pair. For this data set, the pairwise differences are: 1, −1, 4, and 2.
C1 | C2 |
---|---|
A | B |
2 | 1 |
5 | 3 |
You can use these differences for nonparametric tests and confidence intervals. For example, the median of the differences is equal to the point estimate of the median in the Mann-Whitney test.
To perform pairwise differences, choose
.