1. H

    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...
  2. P

    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?
  3. T

    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...
  4. M

    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...
  5. A

    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%...
  6. S

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

    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...
  8. E

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

Some videos you may like

This Week's Hot Topics