SPC控制图表格(自动判别异常点)

Sheet1 产品编号 ABC123 产品名称 ABC 客户 AAA 过程数据 生产部门 CNC 工序名称 1夹 机台/人员 123#机张三 规格上限 100.1 规格值 100 上公差 0.1 下公差 -0.1 规格下限 99.9 子组样本数 5 描述 试产300套 样本均值 99.998896 样本N 125 标准差（整体） 0.0457836469 标准差（组内） 0.0443508169 整体能力 Pp 0.73 PPL 0.72 PPU 0.74 PpK 0.72 潜在（组内）能力 Cp 0.75 CPL 0.74 CPU 0.76 CpK 0.74 Xbar控制图数据 CL 99.998896 UCL 100.05841932 LCL 99.93937268 R控制图数据 CL 0.10316 UCL 0.21808024 LCL 0 Xbar控制图检验 1.任意1点超出3σ以外 0 2.连续9点落在中心线同一侧 0 3.连续6点递增或递减 0 4.连续14点中相邻点交替上下 0 5.连续3点中有2点落在中心线同侧2σ以外 0 6.连续5点中有4点落在中心线同侧1σ以外 0 7.连续15点落在中心线±1σ以内 0 8.连续8点落在中心线两侧且无一落在±1σ以内 0 分析 定性数据统计分析pdf销售业绩分析模板建筑结构震害分析销售进度分析表京东商城竞争战略分析 说明：均值图和极差图无异常点， 表 关于同志近三年现实表现材料材料类招标技术评分表图表与交易pdf视力表打印pdf用图表说话 pdf 明过程处于控制状态； 子组 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 时间 8:00 9:00 10:00 1 99.988 100.03 100.003 100.026 100.104 100.005 99.977 100.046 99.985 99.993 99.948 99.919 99.998 99.975 99.934 100.099 100.047 100.109 99.977 99.972 99.992 100.014 100.038 100.038 100.063 2 100.074 100.028 99.968 99.986 99.981 100.027 99.947 99.998 100.085 99.951 100.014 99.982 100.052 100.038 100.009 100.035 100.021 99.982 99.985 99.99 100.021 100.075 100.041 100.016 100.112 3 99.993 99.926 99.864 100.012 100.043 100.037 100.04 100.047 99.946 99.968 100.023 100.017 99.971 99.979 99.949 99.937 100.08 99.986 99.995 99.863 100.031 100.021 100.088 99.97 99.988 4 99.983 99.985 100.004 99.913 99.946 100.038 100.002 99.901 99.995 99.983 100.008 99.948 100.017 99.993 99.949 99.949 100.009 99.966 99.951 99.982 99.985 100.002 100.059 99.96 100.015 5 100.018 99.996 100.034 99.929 100.024 99.944 100.039 99.995 100.016 99.961 99.991 99.956 100.009 99.997 100.033 99.928 100.028 99.976 100.029 99.994 99.967 100.015 100.039 99.971 99.958 均值 100.0112 99.993 99.9746 99.9732 100.0196 100.0102 100.001 99.9974 100.0054 99.9712 99.9968 99.9644 100.0094 99.9964 99.9748 99.9896 100.037 100.0038 99.9874 99.9602 99.9992 100.0254 100.053 99.991 100.0272 极差 0.091 0.104 0.17 0.113 0.158 0.094 0.093 0.146 0.139 0.042 0.075 0.098 0.081 0.063 0.099 0.171 0.071 0.143 0.078 0.131 0.064 0.073 0.05 0.078 0.154 备注： 批准： 审核： 编制： 以下内容请勿改动 系数表 2 3 4 5 6 7 8 9 10 11 12 13 14 A2*R= 0.05952332 n A A2 A3 B3 B4 B5 B6 D1 D2 D3 D4 C4 d2 D3*R= 0 2 2.121 1.88 2.659 0 3.267 0 2.606 0 3.686 0 3.267 0.7979 1.128 D4*R= 0.21808024 3 1.732 1.023 1.954 0 2.568 0 2.276 0 4.358 0 2.574 0.8862 1.693 4 1.5 0.729 1.628 0 2.266 0 2.088 0 4.698 0 2.282 0.9213 2.059 5 1.342 0.577 1.427 0 2.089 0 1.964 0 4.918 0 2.114 0.94 2.326 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 count 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 CL 99.998896 99.998896 99.998896 99.998896 99.998896 99.998896 99.998896 99.998896 99.998896 99.998896 99.998896 99.998896 99.998896 99.998896 99.998896 99.998896 99.998896 99.998896 99.998896 99.998896 99.998896 99.998896 99.998896 99.998896 99.998896 UCL 100.05841932 100.05841932 100.05841932 100.05841932 100.05841932 100.05841932 100.05841932 100.05841932 100.05841932 100.05841932 100.05841932 100.05841932 100.05841932 100.05841932 100.05841932 100.05841932 100.05841932 100.05841932 100.05841932 100.05841932 100.05841932 100.05841932 100.05841932 100.05841932 100.05841932 +2σ 100.0385782133 100.0385782133 100.0385782133 100.0385782133 100.0385782133 100.0385782133 100.0385782133 100.0385782133 100.0385782133 100.0385782133 100.0385782133 100.0385782133 100.0385782133 100.0385782133 100.0385782133 100.0385782133 100.0385782133 100.0385782133 100.0385782133 100.0385782133 100.0385782133 100.0385782133 100.0385782133 100.0385782133 100.0385782133 +1σ 100.0187371067 100.0187371067 100.0187371067 100.0187371067 100.0187371067 100.0187371067 100.0187371067 100.0187371067 100.0187371067 100.0187371067 100.0187371067 100.0187371067 100.0187371067 100.0187371067 100.0187371067 100.0187371067 100.0187371067 100.0187371067 100.0187371067 100.0187371067 100.0187371067 100.0187371067 100.0187371067 100.0187371067 100.0187371067 -1σ 99.9790548933 99.9790548933 99.9790548933 99.9790548933 99.9790548933 99.9790548933 99.9790548933 99.9790548933 99.9790548933 99.9790548933 99.9790548933 99.9790548933 99.9790548933 99.9790548933 99.9790548933 99.9790548933 99.9790548933 99.9790548933 99.9790548933 99.9790548933 99.9790548933 99.9790548933 99.9790548933 99.9790548933 99.9790548933 -2σ 99.9592137867 99.9592137867 99.9592137867 99.9592137867 99.9592137867 99.9592137867 99.9592137867 99.9592137867 99.9592137867 99.9592137867 99.9592137867 99.9592137867 99.9592137867 99.9592137867 99.9592137867 99.9592137867 99.9592137867 99.9592137867 99.9592137867 99.9592137867 99.9592137867 99.9592137867 99.9592137867 99.9592137867 99.9592137867 LCL 99.93937268 99.93937268 99.93937268 99.93937268 99.93937268 99.93937268 99.93937268 99.93937268 99.93937268 99.93937268 99.93937268 99.93937268 99.93937268 99.93937268 99.93937268 99.93937268 99.93937268 99.93937268 99.93937268 99.93937268 99.93937268 99.93937268 99.93937268 99.93937268 99.93937268 CL 0.10316 0.10316 0.10316 0.10316 0.10316 0.10316 0.10316 0.10316 0.10316 0.10316 0.10316 0.10316 0.10316 0.10316 0.10316 0.10316 0.10316 0.10316 0.10316 0.10316 0.10316 0.10316 0.10316 0.10316 0.10316 UCL 0.21808024 0.21808024 0.21808024 0.21808024 0.21808024 0.21808024 0.21808024 0.21808024 0.21808024 0.21808024 0.21808024 0.21808024 0.21808024 0.21808024 0.21808024 0.21808024 0.21808024 0.21808024 0.21808024 0.21808024 0.21808024 0.21808024 0.21808024 0.21808024 0.21808024 LCL 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 X检验1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 X检验2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 X检验3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 X检验4 0 0 0 0 0 0 0 0 0 0 0 0 X检验5 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 X检验6 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 X检验7 0 0 0 0 0 0 0 0 0 0 0 X检验8 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 合计 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0Xbar-R控制图