I'm looking for a formula to find the correlation from one number to the next and also the next number in the sequence.
The formula should be for each independent column.
Additionally, the three columns values are from one entity just three different measurements.
<style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>
<colgroup><col style="width: 40px"><col width="40"><col width="40"></colgroup><tbody>
</tbody>
The formula should be for each independent column.
Additionally, the three columns values are from one entity just three different measurements.
<style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>
A | B | C |
1 | (1) | 1 |
(1) | (2) | 2 |
1 | 1 | (1) |
(1) | (1) | 1 |
(2) | (2) | (1) |
(3) | (3) | 1 |
(4) | 1 | (1) |
(5) | (1) | (2) |
1 | 1 | (3) |
2 | 2 | 0 |
3 | 3 | 1 |
4 | 4 | (1) |
5 | (1) | 1 |
(1) | (2) | 0 |
1 | (3) | 1 |
(1) | (4) | 2 |
1 | 1 | 3 |
(1) | (1) | (1) |
1 | 1 | (2) |
2 | 2 | 1 |
3 | 3 | (1) |
4 | 4 | 1 |
5 | 5 | 2 |
(1) | (1) | 3 |
1 | 1 | 4 |
2 | 2 | 5 |
(1) | 3 | (1) |
1 | 4 | 1 |
(1) | 5 | (1) |
(2) | 6 | (2) |
(3) | (1) | 1 |
1 | (2) | 2 |
2 | 1 | 3 |
3 | (1) | 4 |
4 | (2) | 5 |
5 | 1 | 6 |
(1) | 2 | (1) |
1 | 3 | (2) |
2 | 4 | 0 |
3 | 5 | 1 |
4 | (1) | 2 |
(1) | (2) | (1) |
(2) | (3) | 1 |
(3) | (4) | (1) |
(4) | (5) | 1 |
1 | 0 | 2 |
(1) | (1) | 0 |
(2) | 1 | (1) |
1 | (1) | 1 |
2 | 1 | 2 |
3 | 2 | 3 |
4 | 3 | (1) |
5 | 4 | 1 |
6 | 5 | (1) |
7 | 6 | 1 |
(1) | 7 | (1) |
1 | 8 | 1 |
2 | 9 | 0 |
(1) | 10 | (1) |
(2) | 11 | (2) |
1 | 12 | 1 |
(1) | (1) | (1) |
1 | (2) | 1 |
(1) | 1 | (1) |
(2) | (1) | 0 |
(3) | (2) | 1 |
1 | 1 | 2 |
(1) | (1) | 3 |
1 | 1 | 4 |
(1) | 2 | 0 |
1 | 0 | 1 |
2 | 1 | 0 |
3 | 2 | 1 |
4 | 3 | (1) |
(1) | 0 | (2) |
1 | 1 | 1 |
2 | 2 | 2 |
(1) | 3 | (1) |
1 | 4 | (2) |
2 | 5 | 1 |
(1) | 0 | (1) |
(2) | 1 | (2) |
1 | 2 | 1 |
2 | 3 | 2 |
3 | 4 | 3 |
(1) | 5 | (1) |
1 | 6 | 1 |
(1) | (1) | (1) |
1 | 1 | 1 |
2 | 2 | (1) |
(1) | (1) | (2) |
1 | (2) | 1 |
(1) | 1 | (1) |
1 | 0 | 1 |
(1) | (1) | 2 |
(2) | 1 | (1) |
1 | 2 | 1 |
(1) | 3 | (1) |
1 | 4 | (2) |
2 | (1) | 1 |
(1) | (2) | (1) |
(2) | 1 | (2) |
(3) | (1) | 1 |
(4) | (2) | (1) |
1 | 1 | (2) |
(1) | (1) | (3) |
(2) | (2) | 0 |
(3) | (3) | (1) |
1 | 1 | (2) |
(1) | (1) | (3) |
(2) | 1 | (4) |
<colgroup><col style="width: 40px"><col width="40"><col width="40"></colgroup><tbody>
</tbody>