SPC过程能力分析报告.xlsVIP

EC210BBOOMBKTCR

EC210BARMCR

1.Specification

3.EachGroupMeasurementData

Company

SPL.Quantity

25EA

Data

PartNo

ProductDate

Measurement

Data

Spec.

Average(X)

Range(R)

Sort

2.StatisticalDataSummary

4.Histogram

5.X-RChart

Defect

Probability(%)

Cpk

Cpu

Cpl

Cp

Max

Minimum

Standard

Declination(σ)

??

UCL

X

CL

LCL

R

(Notice)EraseandusehiddennumericalformulaofblueBox(□)incaseDatacountydoesnotbecomeK=25(Ex:DeletefromZ10toAD11,ifk=20)

VOLVO

ProductName

EC210BARMC/R

Model

Measurement

item

外径

Measurement

Person

肖吴

Measurement

Gage/Unit

数显千分尺

Nominal

-Tol(USL)

UCL=

CL=

LCL=

Histogram

IF(OR(G6=,G6=FALSE,C20=),,

IF(G6=BothSpec.,D6-F6,

IF(G6=SingleSpec.,

IF(E6,

IF(I10-(I14-I10)0,0,I10-(I14-I10)),

IF(F6C19-3*C20,

IF(C19-3*C200,0,C19-3*C20),

F6)

))

??

?

??

????

-Tol(LSL)

S320/S400LC-3SWIVELJOINT

(Notice)EraseandusehiddennumericalformulaofblueBox(□)incaseDatacountydoesnotbecomeK=25(Ex:DeletefromZ10toAD11,ifk=20)

????

??

Standard

Declination(σ)

?

??

Average(X)

IF(OR(G6=,G6=FALSE,C20=),,

IF(G6=BothSpec.,D6-F6,

IF(G6=SingleSpec.,

IF(E6,

IF(I10-(I14-I10)0,0,I10-(I14-I10)),

IF(F6C19-3*C20,

IF(C19-3*C200,0,C19-3*C20),

F6)

))

Histogram

Minimum

Max

CL=

UCL=

LCL=

Defect

Probability(%)

5.X-RChart

2.StatisticalDataSummary

Sort

Range(R)

-Tol(LSL)

-Tol(USL)

Nominal

Spec.

数显千分尺

Measurement

Gage/Unit

肖吴

Measurement

Person

Measurement

外径

Measurement

item

S320/S400LC-3SWIVELJOINT

Model

ProductDate

Data

EC210BBOOM/BKTC/R

ProductName

25EA

SPL.Quantity

VOLVO

Company

3.EachGroupMeasurementData

PROCESSCAPABILITYSTUDY25PIECES

PROCESSCAPABILITYSTUDY25PIECES

RArial,艏笛6Version:LGE-

?2014?/?12?/?2

1.00

2.00

3.00

4.00

5.00

6.00

7.00

8.00

9.00

10.00

11.00

12.00

13.00

14.00

15.00

16.00

1