运用Excel进行工序能力分析及控制图绘制

Application of Excel to analysis of the capacity of working procedure and protract of the control chart

文章在论述工序能力分析及控制图绘制基本原理的基础上,通过实例应用介绍了运用Excel现有功能并通过挖掘其潜在的功能,实现工序能力分析及控制绘制的方法,从而为质量管理提供了一种实用、有效的工具。

The paper discusses the basic principle of analysing the capacity of working procedureand protracting the control chart, realizes working procedures capacity analysis and control charts protracting by applying Excels existing functions and tapping the latent functions, and consequently provides quality administering with a practical and effective means.