FTQ统计表

组别：月份：问题点不良合计12131415161718天数/子组12345678910111213141516171819202122232425262728293031不合格品数0000000000000000000000000000000样本大小缺陷10203456789101112130140150160170180总不合格:00000000000000000000000000000000总产量0PPM缺陷#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!np-barnp1+np2+…..npkwherenp=numbernonconformin,k=subgroupsk=SUM(C3:AA3)/25np-bar0UCLnpnp-bar+3sqrt(np-bar(1-np-bar/n))=#DIV/0!18LCLnpnp-bar-3sqrt(np-bar(1-np-bar/n))#DIV/0!0产品名称：0246810121416182012345678910111213141516171819202122232425262728293031NPChartingforFTQNonconformingSubgroups(hoursorDays)avg=00.20.40.60.811.212131415161718月度问题ParetoFTQ一次下线合格率统计00.20.40.60.811.2135791113151719212325272931Pareto-100.20.40.60.811.2135791113151719212325272931Pareto-200.20.40.60.811.2135791113151719212325272931Pareto-300.20.40.60.811.2135791113151719212325272931Pareto-400.20.40.60.811.2135791113151719212325272931Pareto-5不良数量不良数量不良数量不良数量不良数量日期日期日期日期日期每日不良问题趋势图