A total can hide differences between shifts, products or suppliers. Calculate each group rate using that group exposure. Reconcile the pooled rate from total counts. A larger defect count can come from a larger workload rather than a worse process. Stratification reveals associations that still need causal investigation.
You work with original records from fictional operations teams. Start by checking what each column means and which cases belong in the denominator. A precise calculation can still answer the wrong business question if the population or time boundary changes. Use the worksheet to leave an audit trail: preserve the inputs, record the intermediate outputs and check the stated exception. The transfer case uses new data so you must apply the method again.
Compare like populations and preserve unequal denominators.