Numbers.app - need advanced help!

Discussion in 'Mac Apps and Mac App Store' started by qubex, Sep 12, 2009.

  1. qubex macrumors 6502

    qubex

    Joined:
    May 12, 2004
    Location:
    045°042'21.99"N, 009°005'056.57"E
    #1
    Hello.

    I'm looking for help with (fairly) advanced Numbers.app '09 help.

    In order to calculate a statistic (the Gini coefficient) I must ensure a certain column is arranged in decreasing order.

    That's very simple to do with the "Reorganize" function on a one-by-one basis, but I want to do this automatically... basically so it's immediate and there's no chance for user error.

    How do I do this?
     
  2. mysterytramp macrumors 65816

    mysterytramp

    Joined:
    Jul 17, 2008
    Location:
    Maryland
    #2
    Your best bet might be to input the numbers with AppleScript, have AppleScript sort the numbers, then add them to the spreadsheet, which can calculate your coefficient.

    mt
     

Share This Page