Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie
Hi there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

Excel help: sorting data in Quartiles

  • 28-11-2006 10:02pm
    #1
    PH4T
    Registered Users, Registered Users 2 Posts: 931 ✭✭✭


    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


Comments

  • #2
    xebec
    Registered Users, Registered Users 2 Posts: 3,311 ✭✭✭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 :)


Advertisement