Help with Ranking

[Espinose93]

Can someone tell me how I would rank the following? I want to show who had the top agent satisfaction on their surveys.

Unit Name Agent Sat # Samples
6 A S. 100% 11
4 MF 100% 14
12 AY 100% 16
12 BB 100% 16
8 RL 95% 19
4 RM 92% 13
8 CR 92% 13
4 JV 90% 10
4 LB 90% 20

 

[Aladin Akyurek]

Can someone tell me how I would rank the following? I want to show who had the top agent satisfaction on their surveys.

Unit Name Agent Sat # Samples
6 A S. 100% 11
4 MF 100% 14
12 AY 100% 16
12 BB 100% 16
8 RL 95% 19
4 RM 92% 13
8 CR 92% 13
4 JV 90% 10
4 LB 90% 20

What are the desired results?

 

[respree]

What does samples mean?

Seems like you want to create a weighted average. For example 12 units sold with 100% satisfaction (1200%) would rank higher than 6 units sold with 100% satisfaction (600%). Then, simply sort by the weighted average (units x percentage of satisfaction).

 

[Espinose93]

Like the one below?

 

[Espinose93]

Book3
	A	B	C	D	E
1	Unit	Name	AgentSat	Samples	Rank
2	6	DS	1	11	11
3	4	MF	1	14	14
4	12	AY	1	16	16
5	12	BB	1	16	16
6	8	RL	0.95	19	18.05
7	4	RM	0.92	13	11.96
8	8	CR	0.92	13	11.96
9	4	JV	0.9	10	9
10	4	LB	0.9	20	18
Sheet1