Alphadi Tab - Tool overview

t-Test

The t-test is used to determine whether the means of two groups differ statistically significantly.
It is used to assess whether an observed difference between two groups goes beyond random fluctuations.

The decision is made by comparing the p-value with the predetermined significance level (usually α = 0.05):

  • p ≤ α → accept H₁ (reject H₀)
  • p > α → retain H₀

Download You can download the data here: Entwicklung_Rezeptur_entstapelt.xlsx

In product development, a new recipe for tomato sauce is being tested. The goal is to check whether the viscosity of the new recipe differs on average from the previous recipe. For this purpose, viscosity measurements are carried out on samples of the old and new recipe.

t-Test Viscosity

Interpretation of the results:

The determined p-value is significantly above the significance level of 0.05, so the null hypothesis is retained. There is no evidence that the average viscosity of the new recipe differs from the previous one.

Explanations of the graphic:

  • The points mark the mean values of viscosity for the old and new recipe.
  • The error bars represent the 95% confidence interval of the mean.
  • The significant overlap of the confidence intervals shows that there is no statistically significant difference.

Preparation

  1. Select a continuous measurement (e.g., viscosity).
  2. Define two groups whose means are to be compared.
  3. Set the significance level (usually α = 0.05).
  4. Check if the data shows no strong deviations from the normal distribution.
  5. Ensure that the measurements were collected independently.

AlphadiTab Use in AlphadiTab

  1. Select the 2-sample t tool in the Analyze phase.
  2. Select the first group for sample 1.
  3. Select the second group for sample 2.
  4. Conduct the analysis by Create New.

Interpretation

  1. Check if the p-value is less than or equal to the significance level.
  2. p ≤ α → statistically significant difference in means.
  3. p > α → no statistically significant difference in means.
  4. The interpretation refers exclusively to the mean.

The t-test offers two main settings: the type of data input and the direction of the hypothesis.

Data

Manual input: The comparison is based on manually entered standard deviations and sample sizes of two samples.

t-Test Viscosity

Non-manual input (dataset): The comparison is based on the selected data columns.

t-Test Viscosity

Direction: Two-sided

H₀: μ₁ − μ₂ = Δ₀  |  H₁: μ₁ − μ₂ ≠ Δ₀
Select two-sided if you want to test whether the means of the two samples differ without specifying a particular direction. Useful when there is no specific expectation about the direction of the difference. Example: Do the average test scores of Group A and Group B differ?

Direction: Greater

H₀: μ₁ − μ₂ = Δ₀  |  H₁: μ₁ − μ₂ > Δ₀
Select greater if you want to test whether the mean of the first sample is greater than that of the second. It only tests if sample 1 has significantly higher values. Example: Is the average revenue after an advertising campaign higher than before?

Direction: Smaller

H₀: μ₁ − μ₂ = Δ₀  |  H₁: μ₁ − μ₂ < Δ₀
Select smaller if you want to test whether the mean of the first sample is smaller than that of the second. It only tests if sample 1 has significantly lower values. Example: Is the average processing time after an optimization lower than before?

Two Groups
There must be exactly two groups whose means are to be compared.
Why is this important? The t-test is a method for comparing two means.
Independent Samples
The measurements of the two groups must not influence each other (no pairing of the same parts).
Why is this important? The test assumes that the groups were collected independently of each other.
Continuous Measurement Data
The measurements must be continuous.
Why is this important? The t-test compares means of numerical measurement data.
Normally Distributed Data
The measurements should not show any indication of a significant deviation from the normal distribution.
Why is this important? The t-test is based on assumptions of normal distribution. Significant deviations can make the test results unreliable.
More than two groups should be compared
ANOVA
Data is heavily skewed or with significant outliers
Non-parametric method
The same parts or people before and after a measure
Paired t-test
Variances should be compared instead of means
F-Test / Levene's Test
Proportions should be compared instead of means
Test of proportions

Filling Quantity Tomato Sauce

In production, two filling machines are used. It should be investigated whether the average filling quantity differs between Machine A and Machine B. The measurement data for both machines are available in summarized form:

  • Machine A: n = 25, Mean = 500.2 ml, Standard Deviation = 1.1 ml
  • Machine B: n = 25, Mean = 498.9 ml, Standard Deviation = 1.0 ml

The comparison of the means is done using a t-test (2 samples).

Interpretation

The t-test shows a statistically significant difference in the average filling quantity between the two machines. The p-value is below 0.05, so the null hypothesis is rejected.

→ The machines differ in the mean filling quantity.

Response time requests

In the IT service desk, tickets are processed at multiple locations. Response times are regularly evaluated to identify differences in service quality. In the example, data from three locations is available. The t-test (2 samples) is basically only suitable for comparing two groups. For more than two locations, there are two approaches:

Pairwise comparisons with the t-test: Each location can be compared pairwise with the others (e.g., A vs. B, A vs. C, B vs. C).

Alternative – Analysis of variance (ANOVA): If all locations are to be considered simultaneously, an ANOVA is the more suitable tool. It checks whether there is at least one significant difference between the means without having to perform multiple individual tests.

Note: With multiple pairwise t-tests, the risk of random hits increases.

Download You can download the data here: IT_Tickets_Location_unstacked.xlsx

Interpretation

The t-test shows no statistically significant difference between the average processing times of the locations DLZ North and DLZ East. The p-value is above 0.05, so the null hypothesis is retained.

→ No mean difference; prefer ANOVA for more than two locations.

Sales Rate by Region

In sales, customer offers are processed by two teams. It should be investigated whether the average lead time (DLT) differs between Team A and Team B.

Download You can download the data here: Sales_DLT_Team.xlsx

Interpretation

The t-test shows no statistically significant difference in the average lead time between the two teams. The p-value is above 0.05, so the null hypothesis is retained.

→ Both teams process the offers equally fast on average.

Delivery time after logistics center

In the logistics department, customer orders are picked and shipped. To increase efficiency, new forklifts have been introduced. It should be investigated whether the average delivery time (in hours) has decreased after the introduction. The analysis is carried out as a one-sided t-test (direction “greater”).

H₀: μBefore − μAfter = 0  |  H₁: μBefore − μAfter > 0

Download You can download the data here: Delivery_Time_Before_After.xlsx

Interpretation

The one-sided t-test shows a statistically significant difference (t = 3.29; p = 0.001). The average delivery time before the introduction is significantly higher than afterwards.

→ The new forklifts have significantly reduced the average delivery time.

Supplier Comparison

In purchasing, components are sourced from two suppliers. It should be investigated whether the average rejection rate per delivery differs between Supplier A and Supplier B (measured in %).

Note: The t-test assumes approximately normally distributed, continuous data. Percentage values can be discrete; with small delivery quantities, the normal distribution assumption may be violated. With larger delivery quantities, the t-test is generally unproblematic in practice.

Download You can download the data here: Einkauf_Ausschuss_ttest.xlsx

Interpretation

The t-test shows a statistically significant difference in the average rejection rate between the suppliers (p < 0.05). The null hypothesis is rejected.

→ Supplier A has the better (lower) rejection rate.

Forecast deviation

In production planning, demand forecasts are created for different planning periods. To assess the quality of the forecast, the forecast deviation is calculated. It is examined whether the average forecast deviation differs between short- and long-term planning periods:

  • Short-term horizon: n = 30, mean = 0.0 %, standard deviation = 1.5 %
  • Long-term horizon: n = 30, mean = 0.0 %, standard deviation = 3.8 %

Interpretation

The t-test for two independent samples shows that the mean forecast deviations do not differ statistically significantly. Since the p-value is above 0.05, the null hypothesis is not rejected.

→ No difference in the mean forecast deviation between short- and long-term.

t-value: Test statistic of the t-test. Ratio of the observed mean difference to the data's variability.

p-value: Result of the hypothesis test. Basis for the decision between H₀ and H₁.

α = Significance level: Preset probability of error (usually 0.05).

H₀ (Null hypothesis): The means of the two groups are equal.

H₁ (Alternative hypothesis): The means of the two groups differ.

df = Degrees of freedom: Derived from the sample sizes of both groups.

Confidence interval: Range of values that contains the true mean difference with the chosen confidence level.

Two-tailed / one-tailed: Indicates whether a difference is tested in both or only one direction.

Standard Error of the Difference of Means

SE = √(s₁²/n₁ + s₂²/n₂)

Test Statistic (t-value)

t = ((x̄₁ − x̄₂) − Δ₀) / SE

Degrees of Freedom (Welch)

df = (s₁²/n₁ + s₂²/n₂)² / ((s₁²/n₁)²/(n₁−1) + (s₂²/n₂)²/(n₂−1))

Confidence Interval of the Mean Difference

(x̄₁ − x̄₂) ± t1−α/2,df·SE
Cart