Butter factory line (07:04–08:17, note the milk-fat spec ≥ 80%) ↗
Today’s task: Pool the shared blind-sample data that the 5 groups produced in W2–W6 and cross-check one another, just like a proficiency test between testing laboratories.
Optional extra practice: Food Analysis Statistics site ↗ — mini-games on control charts, outliers, the uncertainty puzzle, the release officer, and ANOVA; do them and class will make more sense.
| Group ⇅ | Moisture % ⇅ | Ash % ⇅ | Protein % ⇅ | Fat % ⇅ | Carb (by diff.) % ⇅ |
|---|
Click a column header to sort. Moisture/ash/fat are each group’s triplicate mean (fat = direct Soxhlet from W6); protein is a single determination per group (n=1) because the W5 digestion block holds only 8 tubes. The high carbohydrate comes from the underestimated fat (error propagation). Illustrative data — not real measurements.
| Time | Contents |
|---|---|
| 0:00–0:30 | Explain the pooling rules: long-format input, significant figures, source of the illustrative data (W2/W3/W5/W6) |
| 0:30–1:30 | Each group uploads its data; Colab compiles the class blind-sample table and runs the Grubbs outlier check |
| 1:30–3:00 | Groups flagged as outliers or with |z| > 2 redo that item (moisture or ash); the other groups do the ANOVA and uncertainty calculation |
| 3:00–3:40 | Class discussion: which error sources are largest? Cross-check against the W1–W7 calibration and standardization records |
| 3:40–4:00 | Release-decision practice: applying the guard band rule |
Values: 2.70, 2.74, 3.30% (★ = suspected outlier)
G_crit(n=3, α=0.05) = 1.1543 (computed from the formula, not looked up in a table)
| Group | Result % | G value |
|---|---|---|
| G1 | 25.930 | 0.2982 |
| G2 | 26.170 | 0.6390 |
| G3 | 26.030 | 0.4402 |
| G4 | 24.470 | 1.7751 |
| G5 | 26.000 | 0.3976 |
G_crit(n=5, α=0.05) = 1.715; G4’s G=1.7751 exceeds the critical value, so it is judged an outlier.
G > G_crit → outlier; α=0.05 = upper limit of 5% probability of wrongly flagging a normal value. Statistics Ch05 ↗
| Within-group variance (F-test denominator, MSW) | sr = 0.0259% (repeatability) |
| Between-group variance (related to the F-test numerator, MSB) | sL = 0.0545% (between groups/laboratories) |
| Combined | sR = 0.0604% (reproducibility) |
| F = MSB / MSW | F = 14.24 (F_crit(0.05,4,10)=3.478, p=0.0004) |
Illustrative data. If σ_pt is too large, truly problematic groups get “hidden”; if too small, there are too many false flags — set it with the method’s practical precision in mind.
Control limits use the established baseline (mean=26.0%, s=0.30%, not calculated from these 12 points); run 8 exceeds +3s (13s violation (Westgard rule): a single point beyond the action limit); runs 10 and 11 are two consecutive points beyond −2s on the same side (22s violation) — illustrative data.
| Uncertainty source | Relative standard uncertainty |
|---|---|
| Weighing | 0.0115% |
| Titrant conc. | 0.3000% |
| Titration volume | 0.1155% |
| Conversion factor 6.38 | 0.2715% |
| Repeatability | 0.5875% |
| Combined u_c (RSS) | 0.7227% |
The standard uncertainty of a rectangular distribution (instrument scale/tolerance) = half-width ÷ √3; components already in standard-deviation form (such as titrant standardization) are used directly.
The repeatability term: each group digested only 1 tube of protein this time (single determination, n=1; see the 8-tube limit in W5), so s_r cannot be estimated from within-group replicates; instead we use 3 replicate determinations (25.95, 26.15, 25.85; illustrative data) that the TA ran on the same milk powder, giving s_r=0.1528%. Because each group reports exactly this one single value, s_r is used directly as the repeatability contribution, with no division by √n (division is only needed when averaging n results; it has nothing to do with the √3 of the rectangular distribution).
| Spec type | Release | Do not release | Cannot decide |
|---|---|---|---|
| Lower limit ≥L | Result−U ≥ L | Result+U < L | Otherwise |
| Upper limit ≤H | Result+U ≤ H | Result−U > H | Otherwise |
| Anomaly | Go back and check |
|---|---|
| G3 moisture outlier | W2 constant weight / desiccator cooling, W1 balance |
| G4 protein too low | W4/W5 HCl standardization (the label concentration was used) |
| Class-wide fat too low | W6 no hydrolysis (method bias) |
| Between-group ash differences | W3 crucible constant weight, W1 balance |
| Carbohydrate too high | Fat underestimate propagated through the difference method |
Colab NB08: Open NB08 in Colab ↗ · Beginner (no coding): Excel practice workbook EX08 ⬇, Orange workflow OR08 ↗. This report is also a warm-up for the W9 midterm practical — the midterm will directly test your ability to compile data, catch outliers, and calculate uncertainty.
Tap to tick — make sure you really can do it.