Student's T-test

Question

Level 1

0 points

Student's T-test

Dear,

I would like to compare two biological distributions (like numbers from wild type and mutant) using the Student's T-test. I can not find it in the formulas, neither in the help book. Maybe I missed it. Could you help me?
Thanks in advance.

MacBook Pro, Mac OS X (10.5.5)

Posted on Nov 6, 2008 3:30 AM

Reply

Answer 1

Nov 6, 2008 5:16 AM in response to lnro

Numbers is not a full-featured spreadsheet like Excel is, and my understanding is that this extends to not doing these kinds of advanced statistical tests. You could probably manually program in the math to do it via formulas, but you're not going to find it in the built-in ones.

(My solution: Use Numbers until I absolutely have to do that kind of crunching, then export and do the hard core stats in Open Office.)

Reply

Answer 2

WWJD

Level 6

15,830 points

Nov 8, 2008 2:39 PM in response to lnro

I posted a work-around for this some time ago. You can do the test by the old-school method in the spreadsheet. I'll have to find the file...

Regards,

Reply

Answer 3

samgross

Level 1

0 points

Jan 4, 2009 11:30 AM in response to lnro

There actually is a method for doing a T-Test in Numbers '08. In the Functions>More Functions>Statistics menu, look for "Confidence". This looks to be a T-Test.

Reply

Answer 4

GBH

Level 1

73 points

Jan 4, 2009 4:42 PM in response to lnro

If what Numbers does is not enough for this specific need, download NeoOffice (or OpenOffice) for free and then go to the following site which has a number of Excel macros for simple or sophisticated stat analysis which will work in NeoOffice.

http://www.coventry.ac.uk/ec/~nhunt/oatbran/

Reply