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!