Become a MacRumors Supporter for $50/year with no ads, ability to filter front page stories, and private forums.

qubex

macrumors 6502
Original poster
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?
 
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
 
Register on MacRumors! This sidebar will go away, and you'll see fewer ads.