控制图及过程能力分析

Thisspreadsheetisprovidedasiswithoutwarrantiesofanykind,eitherexpressorimplied.Whentousethisspreadsheet1)Thisspreadsheetperformsacompleteprocesscapabilityanalysis.ThedataisdisplayedusingaHistogramandSPCcharts.TheSPCchartsareevaluatedfor8stabilitycriteria.Acapabilityanalysisisperformedprovidingasummaryoftheprocessdata,valuesforCpk,Ppk,andSPClimitsforIndividualMovingRangechartsorXBarRcharts,XMedianCharts,andPre-Controlcharts.2)Thisspreadsheetisintendedtobeusedbyindividualsnewtothequalitysciencesthatareunsurehowtoperformacompletecapabilitystudy.AmorethoroughanalysiscanbeperformedmanuallyorusingasoftwarepackagesuchasMinitab.InstructionsforDataEntry1)Organizeyourdatainasinglecolumn.Ifthedataissub-grouped,orderthedatabysub-groupandsample.Forexample,ifyouhavethreesubgroupsofsamplesizeequalto5youshouldorderyourdata1,2,3,4,5,1,2,3,4,5,1,2,3,4,5.2)EnterorpasteyourdataintothecolumntitledData.Amaximumof100datapointscanbeentered.Onlywhitecellswillacceptdata.3)Enterthesub-groupsizeandtheupperandlowerspeclimits.Speclimitsarenecessarytoperformcapabilitycalculationsbutarenotrequired.ReadingtheResults1)TheSub-groupcolumnwillautomaticallyreflectthesub-groupnumberassociatedwiththedatavalue.2)ThePoint#andDatacolumnsreflectthecalculatedaverageandrange(orindividualandmovingrange)displayedonthecharts.3)TheSPCchartswillautomaticallydisplaythecorrectchartdependingonthesubgroupsize.ThemajorheaderwillidentifyIndividualschartsversusXBarCharts.4)Whenasub-groupsizeofoneisused,thespeclimitswillbeshownontheIndividualschartandthespecrangeshownontheRangeChart.X-BarChartswillnotdothis.5)Thechartswillautomaticallysizethemselvestofullydisplaydatasetslessthan100pieces.6)TheSPCruleswilldisplayPassorFailandshouldbeusedtodetermineifyourdataisstableandincontrol.7)Thehistogramwillalwaysdrawabellcurveregardlessofwhetherornotthedataisnormallydistributed.8)AsummaryoftheProcessDataisdisplayed,mostofwhichareselfexplanatory.TheUpperandLowerControlLimitsarecalculatedusingthemeanofthedataandshouldnotbeconfusedwiththeSPClimitsdiscussedbelow.ThenormalityanalysisisperformedusingguidelinesoutlinedbyJamesDeanBrown,UniversityofHawaiiatManoaasfoundintheShiken:JALTTesting&EvaluationSIGNewsletter().Astatementwillappearbasedontheseguidelinesastowhetherthedataisnormal.SkewnessandKurtosisarenotdisplayed.9)TheXbarandR(orIndividualandMovingRange)limitsareprovidedforimplementingSPConthefloor.Thelimitsareautomaticallycenteredaroundthenominalspecvalue.10)TheXMedianlimitsarealsoprovidedforimplementingSPConthefloor.XMedianlimitswillnotdisplaywhenthesub-groupsizeisequaltoone.Thelimitsareautomaticallycenteredaroundthenominalspecvalue.11)Pre-controllimitswillnotdisplayifthedataisnotstableorifthereislessthan100piecesofdata.Thelimitsareautomaticallycenteredaroundthenominalspecvalue.EndControlChartsProcessCapabilityIndividualsChartHistogramMovingRangeChartProcessDataPotential(within)CapabilityUSL1.04Cp4.07LSL0.99CpU5.89#ofSamples27CpL2.25#ofSubGroups27Cpk2.25SubGroupSize(n)1MaxValue1.0093Potential(overall)CapabilityMinValue1.0001Pp3.43Range0.0092PpU4.97XBar1.0038296PpL1.90RBar0.00Ppk1.90St.Dev.(Within)0.0020456St.Dev.(Overall)0.0024267IMRChartLimitsOneormorepointsareoutsidethecontrollimitsPassUCLX1.0099665UCLX1.02113683Morethan9pointsinarowononesideoftheavgPassLCLX0.9976928LCLX1.00886317SixpointsinarowincreasingordecreasingPassUCLR0.0075518UCLR0.007551814pointsinarowalternatingupanddownPassNormalityNormalMorethan2/3rdofptsoutside2sigmaPassXMedianChartLimitsMorethan1/3rdofptsoutside1sigmaPassPre-ControlLimitsUCLXUseIMR15ptsinarowwithin1sigmaofcenterlinePassUpperPCline1.0275LCLXUseIMR8ptsinarowmorethan1sigmafromcenterlinePassLowerPCline1.0025UCLRUseIMRTel:18602112918ProcessCapabilityStudy00.511.522.533.51.00011.000561.001021.001481.001941.00241.002861.003321.003781.004241.00471.005161.005621.006081.006541.0071.007461.007921.008381.008841.00930.960.970.980.9911.011.021.031.041.0513579111315171921232527USLLSLLCLUCLDataAvg00.010.020.030.040.050.0613579111315171921232527RangeUCLTolAvg1590226767363朱克龙[e-mail]:178371861