Applying weights may work.
shop
unit/month
CSI
weight
weighted CSI
rank
1
100
51
10/370=0.27
51+(51*0.27)=64.77
3
2
20
87
20/370=0.05
87+(87*0.05)=91.35
2
3
50
60
50/370=0.14
60+(60*0.14)=68.40
4
4
200
63
200/370=0.54
63+(63*0.54)=97.02
1
Total volume=370
Kind regards
Simon
>-----Original Message-----
>From: A UK-based worldwide e-mail broadcast system mailing list
>[mailto:[log in to unmask]] On Behalf Of Ali Akbar Bromideh
>Sent: 01 August 2011 11:52
>To: [log in to unmask]
>Subject: Query on Ranking.
>
>Dear Sir/Madam,
>
> I have been asked to submit this question to the list. Consider a
>company has n after sales outlets (repair shops), namely X_1, X_2, ...,
>X_n. Monthly reception by each repair shop are recorded as V_1, V_2, ...
>V_n and their monthly customer satisfaction index (CSI) are I_1, I_2,
>..., I_n. Now the question is how to rank the repair shops?
>
>For an instance, consider the simplified case:
>
> Repair shops reception(unit/month) CSI (%)
> X_1 100 51
> X_2 20 87
> X_3 50 60
> X_4 200 63
>
>Note that ignoring the reception volume, the ranks are: X_2, X_4, X_3,
>X_1. What are the ranks of shops considering the monthly receptions?
>
>Kind regards,
>Ali
>
>You may leave the list at any time by sending the command
>
>SIGNOFF allstat
>
>to [log in to unmask], leaving the subject line blank.
You may leave the list at any time by sending the command
SIGNOFF allstat
to [log in to unmask], leaving the subject line blank.
|