A p chart monitors the fraction of defective units when a unit is classified once as defective or not defective. The limits depend on each subgroup size. Larger subgroups have narrower sampling margins under the same baseline. Fractions remain between zero and one. Do not use the chart for unrestricted numbers of defects per unit.
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.
Adjust the sampling margin while keeping the baseline center fixed.