Student T Test Chart. T test in excel example 2. The t test formula in excel used is as follows.
One tail 0 250 0 100 0 050 0 025 0 010 0 005. Feel free to use and share the above images of t table as long as youcontinue reading. In this formula t is the t value x 1 and x 2 are the means of the two groups being compared s 2 is the pooled standard error of the two groups and n 1 and n 2 are the number of observations in each of the groups.
T distribution is the distribution of any random variable t.
A marketing research firm tests the effectiveness of a new flavoring for a leading beverage using a sample of 21 people half of whom taste the beverage with the old flavoring and the other half who taste the beverage with the new flavoring. One tail 0 250 0 100 0 050 0 025 0 010 0 005. How to use this table this table contains critical values of the student s t distribution computed using the cumulative distribution function the t distribution is symmetric so that. The t table can be used for both one sided lower and upper and two sided tests using the appropriate value of α.
