A two-proportion comparison asks whether independent populations have different event rates. Under an equal-rate null, pool event counts and denominators to estimate the common fraction. Do not average percentages from unequal samples. Check that the approximation is suitable. A low p-value does not give the probability that the null is true or establish causality.
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.
Pool counts correctly under an equal-rate null hypothesis.