quintiles

  1. E_DPSG

    Quintiles - based on sub groups

    I am having a brain block this morning. I am trying to break down segments of data into quintiles based on two fields: ColB and ColC. ColB has a subgroup of East, West, North, South ColC is a numeric value that the quintile will be based on. What I am seeking to do is see the quintile...
  2. S

    How can I calculate sales quintiles?

    I have a list of 2000 product skus with sales volume from last year. I would like to break the skus into 5 equal groups, quintiles, with each group having 1/5th of the total sales volume. I'd like a formula that would insert "q1" or "q2", etc, so that I can sort on the quintiles and summarize...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top