Excel绘制准质控图教程.docVIP

利用Excel电子表格制作室内质控图 绘制室内质控图是检验科，保证检验质量必不可少的工作，为提高工作效率，现在很多工作人员都利用Excel电子表格制作来处理这些问题，现在简单介绍一下用Excel2003电子表格制作质控图的过程。 首先打开Excel2003电子表格应用程序 　　　现以“水质硫酸盐质控图”为例，制作质控图操作；利用电子表格公式计算出，求和、标准差、平均值、最大值、最小值。 1、选择数据区堿 2、点击“图表导向” ，选择折线图，下一步 3、系列产生在选择“列”，如数据是横向输入选择“行”，下一步 4、在此输入“标题”、“X轴”代表什么、“Y轴”代表什么 5、输入完成，下一步 6、点击“完成” 7、鼠标对着“横线”点击右键出现“网络线格式” 8、选择“刻度” 9、最小值输入“平均值-3SD”，最大值输入“平均值+3SD”，主要刻度单位输入“标准差”，次要刻度单位输入“标准差1/10”，分类（X）轴交叉于输入“平均值”　　“确定”完成 10、完成 11、分类（X）轴交叉于输入“0”不是平均值，则出现此图 12、数据分析： 　　　计算平均值是12.5，输入是12.5，而图表中出现的是12.4，因为12.5是四舍五入得来的。 谢谢 of support and hanger. Cable hole plugging gaps should use qualified fireproof materials, block surface should have sufficient strength, surface appearance. When cables pass through the firewall, of lax structure of local fire safety clamps. Thermoplastics production, to comply with the process, no bubbles in the thermoplastics pipes, linear nose consistent with the core wire specifications, contact is good, no cracks, break. Tinned copper nose clean solder full exterior surface is smooth without burrs. Control cable Assembly should be fastened, dense, solid, clean, and beautiful. Secondary wiring the cable terminations should be arranged by the actual location of the device line cards, the wiring from the upper to the lower, from left to right in the order. Fixed to maintain consistent spacing between lines, flat, should be around the corner in the same location, same shape, to ensure that the wiring process neater and more elegant. 5 thermal process control measures for quality problems 5.1 control thermal duct system leakage measure to ensure that the use of electric door and actuator installation quality and equipment to the site to check its seal, acceptance, in order to fundamentally solve oil spill problems. Plant for local Panel after installation, in conjunction with the quality Department to check its overall quality, poor-quality parts replacement. Supply good quality of purcha