Data manipulation in a spreadsheet can only get you so far. You could resort to a programming language like Python, but when it comes to some basic analysis then you will need statistics software.
The Mac has some excellent statistics software packages available and many are free. Check out MacStats.org for an excellent run down of what is available.