Sedang Disiapkan

Write Excel statistical ranking formula

I need to develop an Excel formula that does the following:

1. Assess spread of numbers in one column (e.g. numbers may range from 1 - 500)

2. Assign rank of 1 to 10 to each number (in next column), based upon it's value. Rank must be worked out on a volume basis. i.e. the first 10% (of total numbers listed in column) of lowest value numbers are assigned rank 1. The next 10%m, as value increases, will be ranked 2.

This tool must work for any volume of numbers listed in a column. Rank will always be from 1 - 10.

I am sure there is a statistical mathematical term for this - please let me know if you know this.

Thanks

Kemahiran: Excel, Destop Windows

Lihat lebih lanjut: statistical ranking formula, rank excel, rank formula excel, excel ranking formula, statistical ranking excel, ranking excel, excel rank formula, statistical ranking, excel ranking, rank excel formula, assign rank excel, excel statistical ranking, assign ranking excel, write statistic excel, excel statistical formulas, ranking formula excel, assign rankings excel, excel rank, outsourcing writing excel formulas, excel formula ranking, statistical rank formula, ranking 500 excel, formula statistical ranking, must write, me excel

Tentang Majikan:
( 42 ulasan ) London, United Kingdom

ID Projek: #291754

Dianugerahkan kepada:

HussienSharaf

HI, i m expert in MS Excel. i can do it using VBA thanks

$70 USD dalam sehari
(22 Ulasan)
6.1

9 freelancers are bidding on average $50 for this job

ioanaprof

Ready to start

$40 USD dalam sehari
(19 Ulasan)
4.8
excelinnovation

Hi, please see PMB. Regards

$50 USD dalam sehari
(8 Ulasan)
2.7
lakshmidhanam

Dear Sir, I am ready to work on this project with you.

$30 USD dalam 2 hari
(1 Ulasan)
2.2
latifoglu80

I have it already. Can share with you.

$30 USD dalam 0 hari
(0 Ulasan)
0.0
koolonlove

If I understand correctly, you need to assign a rank figures in the table based on sum of total, would that be correct?

$75 USD dalam sehari
(0 Ulasan)
0.0
RFadera

>>> I can help you this. Please see PMB for details of assistance.

$45 USD dalam sehari
(0 Ulasan)
2.9
MehwishFatima

Hello i m interested in project and i can work in excel with a great ease.

$60 USD dalam sehari
(0 Ulasan)
0.0
fitar

i can all these just in 2 days . i have knowledge in Statistics,

$50 USD dalam 2 hari
(0 Ulasan)
0.0