Formula / Stats help!!!!!

**avs** · 10-30-2014, 11:05 PM

Hi there,

I need to answer the following questions but I'm not sure which formulas to use to achieve this:

- proportion of doctors admitting 50% of all patients
- proportion of patients admitted by the upper 50% of doctors
- proportion of patient admitted by the lower 10% of doctors

Doctor names are in Column A and number of patients in Column B. I have ordered the data by Column B descending (largest to smallest).

Thank you in advance for your help!

**Loganeb** · 10-30-2014, 11:07 PM

Hello avs,

If you could post a sample workbook with random data (please remove any private data), it would help to visualize what you want and to design it for you.

**avs** · 10-30-2014, 11:22 PM

Hi Loganeb,

Thanks for your response! There are restrictions on my end preventign me from uploading the files. The data is like so:

Doctor Name Number of Patients
Doctor 1 3090
Doctor 2 3031
Doctor 3 2552
Doctor 4 2387
Doctor 5 2220
Doctor 6 1645
Doctor 7 1611
Doctor 8 1609
Doctor 9 1419
Doctor 10 1335
Doctor 11 1278
Doctor 12 1234
Doctor 13 1116
Doctor 14 1050
Doctor 15 936
Doctor 16 886
Doctor 17 878
Doctor 18 868
Doctor 19 847
Doctor 20 836

Thanks for your help!!