t test in Excel

One Sample t tests

A t test using one sample compares test data to a specific value. It helps determine if the sample is greater than, less than or equal to the value.

t test one sample

Two Sample t tests

In the constant quest to reduce variation and improve products, companies need to evaluate different alternatives. A t test using two samples compares two sets of test data. It helps determine if the means (i.e., averages) are the same or different from each other. The QI Macros offers several two sample t tests:

If data sets are independent of each other

• Two-Sample t test assuming equal variances
• Two-Sample t test assuming unequal variances

If data sets are dependent on each other: when natural pairs of observations exist (e.g., using the same operator on a machine while comparing two different modes of operation.)

• Paired Two-Sample t test for Means

t tests are just one of the statistical tests included in the QI Macros Statistical Process Control software. Other tests include:

• f test
• chi square
• ANOVA - Analysis of Variance
• Overvew of all hypothesis tests in Excel

Download the FREE 30-day Evaluation copy of the QI Macros Excel SPC Software for Six Sigma