formula for variance in ranking

  • Thread starter Thread starter seanof30306
  • Start date Start date
S

seanof30306

i am trying to figure out how to set up a formula to quantify th
variance between two ranked lists.

column "c" is one list; column "d" is another. In column "e" i wan
the variance between columns "c" and "d". in column "f", i want th
cumulative variance, basically a running total of the variance betwee
columns "c" and "d". it would work something like this.


Column: "c" "d" "e" "f"
1 1 0 0
2 3 (1) (1)
3 5 (2) (3)
4 2 2 (1)
5 9 (4) (5)


numbers in parenthesis are negaitive.

can anyone help?

thank
 
Hi

In E1 enter:
=C1-D1
and fill down
In F1 enter:
=E1
and in F2 enter:
=F1+E2
and fill down
You can then use a custom format - something like 0;(0) - to display the
negatives in brackets
 
Back
Top