ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   how do i perform student t test (https://www.excelbanter.com/new-users-excel/153732-how-do-i-perform-student-t-test.html)

sara

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

Stan Brown

how do i perform student t test
 
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.

--
"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/

Jerry W. Lewis

how do i perform student t test
 
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" wrote:

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.

--
"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/


Stan Brown

how do i perform student t test
 
Sun, 12 Aug 2007 17:54:01 -0700 from Jerry W. Lewis
:

"Stan Brown" wrote:
(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.

--
"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/


All times are GMT +1. The time now is 08:30 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com