How to rank based on sum and break tie with standard deviation?

[gpks00]

Can anyone help me with how to break a ranking tie using standard deviation?
10 people rank their choices from 1-10 (10 being best), so I started with a plain basic rank based on the sum of all 10 people's choices. Highest overall number represents the groups most favorite choice.

I would like to break ties using the standard deviation function (or variance is okay too), where... when there is a tie.. a lower SD or Var means that the group agrees with one another more closely than with a higher SD/Var.
So there is a general consensus of which choice is best, also by saying this group of 10 is only a sample of a larger population.

Thank you

 

[DRSteele]

I probably haven't deciphered your meaning accurately, but here goes. When you wish to break ties in a ranking using more variables, you can often add the variables together and rank the results. Sometimes, you'll have to multiply one variable by ten or divide by ten in order to make it all work.

For your data, I assume it would look like this, which includes a helper column I called "Grade":

Excel 2012
	A	B	C	D
1	Choice	st.dev.	Grade	RANK
2	9	0.005	8.995	4
3	6	0.090	5.910	10
4	3	0.100	2.900	16
5	10	0.040	9.960	1
6	1	0.090	0.910	20
7	7	0.080	6.920	9
8	10	0.041	9.959	2
9	1	0.010	0.990	19
10	9	0.010	8.990	5
11	10	0.050	9.950	3
12	2	0.080	1.920	17
13	3	0.080	2.920	14
14	8	0.040	7.960	8
15	4	0.090	3.910	13
16	2	0.100	1.900	18
17	5	0.050	4.950	11
18	3	0.090	2.910	15
19	9	0.020	8.980	6
20	1	0.010	0.098	21
21	5	0.070	4.930	12
22	9	0.040	8.960	7
Sheet8

Cell Formulas
Range	Formula
C2	=A2-B2
C3	=A3-B3
C4	=A4-B4
C5	=A5-B5
C6	=A6-B6
C7	=A7-B7
C8	=A8-B8
C9	=A9-B9
C10	=A10-B10
C11	=A11-B11
C12	=A12-B12
C13	=A13-B13
C14	=A14-B14
C15	=A15-B15
C16	=A16-B16
C17	=A17-B17
C18	=A18-B18
C19	=A19-B19
C21	=A21-B21
C22	=A22-B22
D2	=RANK.EQ(C2,$C$2:$C$22)
D3	=RANK.EQ(C3,$C$2:$C$22)
D4	=RANK.EQ(C4,$C$2:$C$22)
D5	=RANK.EQ(C5,$C$2:$C$22)
D6	=RANK.EQ(C6,$C$2:$C$22)
D7	=RANK.EQ(C7,$C$2:$C$22)
D8	=RANK.EQ(C8,$C$2:$C$22)
D9	=RANK.EQ(C9,$C$2:$C$22)
D10	=RANK.EQ(C10,$C$2:$C$22)
D11	=RANK.EQ(C11,$C$2:$C$22)
D12	=RANK.EQ(C12,$C$2:$C$22)
D13	=RANK.EQ(C13,$C$2:$C$22)
D14	=RANK.EQ(C14,$C$2:$C$22)
D15	=RANK.EQ(C15,$C$2:$C$22)
D16	=RANK.EQ(C16,$C$2:$C$22)
D17	=RANK.EQ(C17,$C$2:$C$22)
D18	=RANK.EQ(C18,$C$2:$C$22)
D19	=RANK.EQ(C19,$C$2:$C$22)
D20	=RANK.EQ(C20,$C$2:$C$22)
D21	=RANK.EQ(C21,$C$2:$C$22)
D22	=RANK.EQ(C22,$C$2:$C$22)