quartiles

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

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

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

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?

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

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

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

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

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

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

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