# quartiles

1. ### Methods for Quartile Calculation with Multiple Criteria

I need to calculate quartiles on the assumption that 5 criteria are met but I am unable to determine which method is logically the most sound. From what I can think of, there are various ways to do this: Using the IF function or using an IFS function. (1) One way seems to be to nest IF...
2. ### How do I make this comparison to peer graph?

I need to make something like this in Excel. Four shades (I'll change the color) indicating quartiles - just four even shapes to represent. The numbers on the bottom represent the quartile value. The yellow marker is where the person is on that said scale. I've tried stacked columns and...
3. ### Quartiles by Year

I have a large dataset (almost 300K rows) with multiple years of information (2003-2016). I'm trying to assign size into a Small, Medium, and Large category by year. My first attempt was to determine the quartiles then manually assign the size to a category but I'm sure there is a more efficient...
4. ### Quartiles of filtered data not including zeros

Hi there I have read threads that show me how to find non zero, filtered averages. I want to do the same thing but for 1st, 2nd and 3rd quartiles. Can anyone help please?
5. ### Quartile Calculation Based on Category

I have read several other posts on this topic, but am still stuck. I have about 8000 rows of data with columns A-O providing data elements for each row. I'd like to calculate the quartiles for Column J, but do so based on the field that is located in Column O. Column O has 6 different...
6. ### Counting if two variables met. One of which is a calculation...

Hi. I'm hoping that someone out there will be able to help! I have c.600 rows of data with three important columns (Name, sector, valuation). I would like a formula to return the number of companies in each sector (e.g. housebuilder, Tech) that sit within each quartile of valuation. I can...
7. ### Working with Quartiles

Good Morning all. I am trying to find out if it is possible to work with data in quartiles. So, if I had a list of salary data attached to Male and Female employees I know I can find out what each of the Quartiles are, but is there a way to say in the top quartile there are 55% Male and 45%...
8. ### VBA Array - Minimum value & quartile

Hi all I'm trying to generate some box-plots of data that meets several requirements. Basically, I'm looping all data in shData, see if the value meets the conditions and if so, add the cell content to an array. Once the array is filled, I print min, max, avg... so I can make a boxplot. Now it...
9. ### retrieving value based on quartile function results

I'd like the price returned for the minimum price in the 2nd quartile, the median price, and the maximum price in the 3rd quartile. What formulas can I use to achieve this? <colgroup><col span="2"><col></colgroup><tbody> </tbody> <colgroup><col span="2"><col></colgroup><tbody> Product...
10. ### Excel Graph Help

Hello, I am currently trying to create a graph that allows me to plot a range of quartiles and then highlight individual salaries and where they sit against those quartiles. Here is an example of the table that i have: <colgroup><col><col span="4"></colgroup><tbody> Job Type Salary LQ Med...
11. ### 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...

### 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.

### Which adblocker are you using?

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

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