Calculate T-Test

Use TTEST to determine whether two samples are likely to have come from the same two underlying populations that have the same mean.

1. Go to Formulas, select   More Functions, and choose  Statistical > T.TEST.

2. For Array1, type or select the cells for the first set of data. Do the same in Array2 to specify the second set.

3. For Tails, type 1 for a one-tailed distribution, or type 2 for a two-tailed.

4. For Type, specify the type of t-test to perform. For example, type 1 for paired, 2 for two-sample equal variance, or 3 for two-sample unequal variance. 

For more info, see T.TEST function.

Use TTEST to determine whether two samples are likely to have come from the same two underlying populations that have the same mean.

1. Go to Formulas, select   More Functions, and choose  Statistical > T.TEST.

2. For Array1, type or select the cells for the first set of data. Do the same in Array2 to specify the second set.

3. For Tails, type 1 for a one-tailed distribution, or type 2 for a two-tailed.

4. For Type, specify the type of t-test to perform. For example, type 1 for paired, 2 for two-sample equal variance, or 3 for two-sample unequal variance. 

For more info, see T.TEST function.

Use TTEST to determine whether two samples are likely to have come from the same two underlying populations that have the same mean.

1. Go to Formulas, select   More Functions, and choose  Statistical > T.TEST.

2. For Array1, type or select the cells for the first set of data. Do the same in Array2 to specify the second set.

3. For Tails, type 1 for a one-tailed distribution, or type 2 for a two-tailed.

4. For Type, specify the type of t-test to perform. For example, type 1 for paired, 2 for two-sample equal variance, or 3 for two-sample unequal variance. 

For more info, see T.TEST function.