CPK控制图分析Excel-SPC计算工具

上传人：1*** IP属地：湖北上传时间：2023-09-06 格式：XLS 页数：2 大小：892.50KB 积分：6 举报 版权申诉

全文预览已结束

 下载本文档

版权说明：本文档由用户提供并上传，收益归属内容提供方，若内容存在侵权，请进行举报或认领

文档简介

过程能力研究,,,,,,,,,,,,,,,,,,,,,,,

(CPK分析报告),,,,,,,,,,,,,,,,,,,,,,,控制图

工厂,,,,部门,,一分厂,,工序,,冲孔,,计算控制限日期,,,2003/9/27,,工程规范,,,15.250,～,16.750,

机器编号,,冲床,,日期,,2003/9/27,,特性,,尺寸,16±0.2,样本容量/频率,,,5件/1H,,零件名称/编号,,,DL138GD-12400,,插接片组件,

时间,,8:20,8:40,9:00,9:20,9:40,10:00,10:20,10:40,11:00,11:20,12:10,12:30,12:50,13:10,13:30,13:50,14:10,14:30,14:50,15:10,15:30,

,1,15.700,16.200,15.900,15.900,15.900,15.800,15.900,15.800,15.900,15.900,15.800,15.900,16.100,15.800,16.100,16.200,15.900,15.900,15.800,15.900,15.900,

读,2,15.800,16.000,15.900,16.100,16.000,15.900,16.000,15.900,16.000,15.700,15.800,16.100,16.200,15.800,16.200,15.900,15.900,15.800,16.000,16.000,16.000,

,3,16.000,16.100,16.100,16.200,16.200,15.800,16.200,16.200,16.000,15.800,16.000,16.200,16.000,15.900,16.000,16.200,16.100,16.100,15.900,15.900,15.900,

数,4,16.000,15.900,16.000,15.800,16.200,16.000,16.100,16.100,16.100,15.900,16.200,16.100,16.300,16.000,15.900,15.700,16.000,15.900,15.800,16.100,16.100,

,5,16.100,16.000,15.800,15.900,15.900,15.800,16.300,16.200,16.200,16.000,16.000,16.100,16.000,16.100,16.200,15.800,16.100,15.900,16.200,16.200,16.200,

和,,79.60,80.20,79.70,79.90,80.20,79.30,80.50,80.20,80.20,79.30,79.80,80.40,80.60,79.60,80.40,79.80,80.00,79.60,79.70,80.10,80.10,

X=和/（读数数量）,,15.92,16.04,15.94,15.98,16.04,15.86,16.10,16.04,16.04,15.86,15.96,16.08,16.12,15.92,16.08,15.96,16.00,15.92,15.94,16.02,16.02,

R=最高—最低,,0.4000,0.300,0.300,0.400,0.300,0.200,0.400,0.400,0.300,0.300,0.400,0.300,0.300,0.300,0.300,0.500,0.200,0.300,0.400,0.300,0.300,

S=STDEV(C6:V10)=δs=,,,0.147214677,,,,,,,,,,,对特殊原因采取的措施的说明：,,,,,,,,,

,,,,,,,,,,d2,A2,D3,D4,*任何超出控制限的点。,,,,,,,,,

,X=,15.99,,,,R=,0.329,,2,1.13,1.88,*,3.27,*连续7点全在中心线之上或之下。,,,,,,,,,

,,,,,,,,子,3,1.69,1.02,*,2.57,*连续7点上升或下降。,,,,,,,,,

,,,,,,,,,4,2.06,0.73,*,2.28,*任何其它明显非随机的图形。,,,,,,,,,

UCLX=X+A2R=,,16.18,,,UCLR=D4R=,,0.693285714,组,5,2.33,0.58,*,2.11,,,,,,,,,,

,USL=,16.75,,Cpk1=,(USL-X)/3δs=,,1.715,,6,2.53,0.48,*,2.00,采取措施的说明：,,,,,,,,,

,,,,,,,,容,7,2.7,0.42,0.08,1.92,1。,,,,,,,,,

LCLX=XA2R=,,15.80,,,LCLR=D3R=,,0,,8,2.85,0.37,0.14,1.86,2。,,,,,,,,,

LSL=,,15.25,,Cpk2=,(X-LSL)/3δs=,,1.681,量,9,2.97,0.34,0.18,1.82,3。,,,,,,,,,

Cpk=,"min(Cpk1,Cpk2)=",,1.681,,,,,,10,3.08,0.31,0.22,1.78,4。,,,,,,,,,

*在确定过程能力之前，过程必须受控。,,,,,,,,,,,,,,5。,,,,,,,,,

*样本容量小于7时，没有极差的下控制线。,,,,,,,,,,,,,,,,,,,,,,,

UCL,,16.18,16.18,16.18,16.18,16.18,16.18,16.18,16.18,16.18,16.18,16.18,16.18,16.18,16.18,16.18,16.18,16.18,16.18,16.18,16.18,16.18,

X,,15.99,15.99,15.99,15.99,15.99,15.99,15.99,15.99,15.99,15.99,15.99,15.99,15.99,15.99,15.99,15.99,15.99,15.99,15.99,15.99,15.99,

LCL,,15.80,15.80,15.80,15.80,15.80,15.80,15.80,15.80,15.80,15.80,15.80,15.80,15.80,15.80,15.80,15.80,15.80,15.80,15.80,15.80,15.80,

UCL,,0.693285714,0.693285714,0.693285714,0.693285714,0.693285714,0.693285714,0.693285714,0.693285714,0.693,0.693285714,0.693285714,0.693285714,0.693285714,0.693285714,0.693285714,0.693285714,0.693285714,0.693285714,0.693285714,0.693285714,0.693285714,

R,,0.329,0.329,0.329,0.329,0.329,0.329,0.329,0.329,0.329,0.329,0.329,0.329,0.329,0.329,0.329,0.329,0.329,0.329,0.329,0.329,0.329,

LCL,,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,

"研究评定:由以上计算结果可知CPK=1.365>1.33,性能指数能够满足.若批准,开始生产并按照已批准的控制计划进行.",,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,

人人文库> 全部分类> 应用文书 > 研究报告

温馨提示

1. 本站所有资源如无特殊说明，都需要本地电脑安装OFFICE2007和PDF阅读器。图纸软件为CAD,CAXA,PROE,UG,SolidWorks等.压缩文件请下载最新的WinRAR软件解压。
2. 本站的文档不包含任何第三方提供的附件图纸等，如果需要附件，请联系上传者。文件的所有权益归上传用户所有。
3. 本站RAR压缩包中若带图纸，网页内容里面会有图纸预览，若没有图纸预览就没有图纸。
4. 未经权益所有人同意不得将文件中的内容挪作商业或盈利用途。
5. 人人文库网仅提供信息存储空间，仅对用户上传内容的表现方式做保护处理，对用户上传分享的文档内容本身不做任何修改或编辑，并不能对任何下载内容负责。
6. 下载文件中如有侵权或不适当内容，请与我们联系，我们立即纠正。
7. 本站不保证下载资源的准确性、安全性和完整性, 同时也不承担用户因使用这些下载资源对自己和他人造成任何形式的伤害或损失。

CPK控制图分析Excel-SPC计算工具

文档简介

温馨提示

最新文档

评论

CPK控制图分析Excel-SPC计算工具

文档简介

温馨提示

最新文档

评论

相关文档