how do i perform student t test

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

sara - 10 Aug 2007 11:22 GMT

how do i perform student t test for scientific experiment to compare between
control and tested groups

Reply to this Message

Stan Brown - 10 Aug 2007 11:44 GMT

Fri, 10 Aug 2007 03:22:00 -0700 from sara
<sara@discussions.microsoft.com>:

> how do i perform student t test for scientific experiment to compare between
> control and tested groups

Get your Shift key and ? key fixed, then click Tools | Data Analysis.
(There's a TTEST function, but it's for a one-population Student's t
and you seem to have vtwo populations.)

If Data Analysis doesn't appear in the menu, then install the
Analysis Toolpak. You may need to install Analysis Toolpak VBA as
well; I'm not certain, but it can't hurt.

Signature

"The Internet is famously powered by the twin engines of
bitterness and contempt." -- Nathan Rabin, /The Onion/
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com/

Reply to this Message

Jerry W. Lewis - 13 Aug 2007 01:54 GMT

You are mistaken about TTEST being limited. The three arguments for the
final argument (type) of the TTEST worksheet function choses among the three
types of t-tests that can also be done by the Analysis ToolPak. Both
approaches are documented in Help.

Jerry

> Fri, 10 Aug 2007 03:22:00 -0700 from sara
> <sara@discussions.microsoft.com>:
[quoted text clipped - 8 lines]
> Analysis Toolpak. You may need to install Analysis Toolpak VBA as
> well; I'm not certain, but it can't hurt.

Reply to this Message

Stan Brown - 14 Aug 2007 12:18 GMT

Sun, 12 Aug 2007 17:54:01 -0700 from Jerry W. Lewis
<post_a_reply@no_e-mail.com>:

> > (There's a TTEST function, but it's for a one-population Student's t
> > and you seem to have two populations.)

> You are mistaken about TTEST being limited. The three arguments for the
> final argument (type) of the TTEST worksheet function choses among the three
> types of t-tests that can also be done by the Analysis ToolPak. Both
> approaches are documented in Help.

Well, it is limited :-) but not in any way related to what I said. I
was flat wrong about it being a one-population test, and I appreciate
the correction.

Signature

"The Internet is famously powered by the twin engines of
bitterness and contempt." -- Nathan Rabin, /The Onion/
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com/

Reply to this Message