how do i perform student t test

[Guest]

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

 

[Stan Brown]

Fri, 10 Aug 2007 03:22:00 -0700 from sara

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.

 

[Guest]

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

 

[Stan Brown]

Sun, 12 Aug 2007 17:54:01 -0700 from Jerry W. Lewis

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.