I gang

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

Færdigheder: Excel, Windows Skrivebord

Se mere: 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

Om arbejdsgiveren:
( 42 bedømmelser ) London, United Kingdom

Projekt-ID: #291754

Tildelt til:

HussienSharaf

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

$70 USD på 1 dag
(22 bedømmelser)
6.1

9 freelancere byder i gennemsnit $50 for dette job

ioanaprof

Ready to start

$40 USD på 1 dag
(19 bedømmelser)
4.8
excelinnovation

Hi, please see PMB. Regards

$50 USD på 1 dag
(8 bedømmelser)
2.7
lakshmidhanam

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

$30 USD in 2 dage
(1 bedømmelse)
2.2
latifoglu80

I have it already. Can share with you.

$30 USD in 0 dage
(0 bedømmelser)
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 på 1 dag
(0 bedømmelser)
0.0
RFadera

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

$45 USD på 1 dag
(0 bedømmelser)
2.9
MehwishFatima

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

$60 USD på 1 dag
(0 bedømmelser)
0.0
fitar

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

$50 USD in 2 dage
(0 bedømmelser)
0.0