产品质量的过程控制图.doc

《产品质量的过程控制图.doc》由会员上传分享，免费在线阅读，更多相关内容在行业资料-天天文库。

1、实验七产品质量的过程控制图实验目的：1．掌握用excel绘制产品质量的过程控制图的方法与步骤。2．通过产品质量图分析产品质量的稳定程度。实验内容：某种零件的质量特性值是零件的外径，为了控制产品的质量，从连续生产工序中每隔半小时抽检制品一次，每次抽捡5件，共抽25次，测得数据如表7.1所示，试制作控制图。表7.1实验测定值单位：mm组号测定值Rixi1xi2xi3xi4xi5176.4276.5476.4576.5776.376.460.27276.4176.3576.4476.2976.4776.390.18376.217

2、6.5476.2976.2176.2676.300.33476.4876.3976.3976.5276.6976.490.30576.3976.2276.5676.3676.4776.400.34676.4676.2176.4776.4276.4976.410.28776.2376.4276.3676.2676.4176.340.19876.276.4876.4676.5476.4276.420.34976.4776.3876.4676.3776.3176.400.161076.4176.3576.3676.5676.48

3、76.430.211176.5576.3976.5176.4276.2976.430.261276.4376.4276.3576.3676.4276.400.081376.4876.2976.2376.2576.5876.370.351476.4976.2376.4376.4776.4176.410.261576.276.5176.3476.5176.3676.380.311676.1976.4376.3476.376.4376.340.241776.4876.3976.3176.5376.5176.440.221876.

4、2376.4676.5976.376.3976.390.361976.4676.3176.476.3676.5876.420.272076.4276.2376.3976.4876.5176.410.282176.5276.6376.6276.3676.3576.500.282276.3176.3976.2676.9276.3176.440.662376.5876.3976.5276.4376.3276.450.262476.3276.4376.6576.3976.3876.430.332576.4576.5376.2676

5、.3976.3376.390.27平均值76.410.28操作步骤：1．计算各组的在Excel工作表中输入如表7.1所示的样本数据，点击主菜单中的“工具”菜单，在弹出的子菜单中点击“数据分析”，出现数据分析对话框，如图7.1所示。图7.1由excel求平均值与标准差2．选择“描述统计”，点击确定，弹出描述统计对话框，在“输入区域”选项的矩形框中，拖动鼠标选取B3:F27，分组方式选择“逐行”，并根据需要选择其它参数，如图7.2所示。图7.2由excel求平均值与标准差3．点击确定，弹出的输出结果窗口如图7.3所示。7.3由

6、excel求平均值与标准差4．选择所需要的参数值，如平均值、标准差，通过复制和粘贴，生成的数据统计表，如表7.2所示。表7.2控制图数据计算表组号测定值sixi1xi2xi3xi4xi5176.4276.5476.4576.5776.376.460.1069276.4176.3576.4476.2976.4776.390.0722376.2176.5476.2976.2176.2676.300.1374476.4876.3976.3976.5276.6976.490.1234576.3976.2276.5676.3676.

7、4776.400.1271676.4676.2176.4776.4276.4976.410.1147776.2376.4276.3676.2676.4176.340.0868876.276.4876.4676.5476.4276.420.1304976.4776.3876.4676.3776.3176.400.06691076.4176.3576.3676.5676.4876.430.08811176.5576.3976.5176.4276.2976.430.10261276.4376.4276.3576.3676.427

8、6.400.03781376.4876.2976.2376.2576.5876.370.15531476.4976.2376.4376.4776.4176.410.10331576.276.5176.3476.5176.3676.380.13051676.1976.4376.3476.376.4376.