Excel help: sorting data in Quartiles

PH4T

What is the best way to get excel to sort a data into quartiles? I have lists of performance figures that I need to rank in quartiles and I only know how to do it manually.

I want my data in the first column and the quartiles 1-4 in the second column

Thanks

xebec

Not sure if it's the exact answer you're looking for but hope this helps!

Take a look at the QUARTILE function in EXCEL help, this function can return 5 values as it explains, from these you should be able to get some idea of the quartiles and set up a simple if loop in the second column to tell you which quartile each piece of data is in.

Also, there's a macro for creating boxplots in EXCEL on this page, don't know if it works and don't know how secure it is. Be warned that macros may contain viruses and I don't condone anyone downloading them from an unreliable source, do it at your own risk! That said it is from and educational institution so should be ok