应用EXCEL实施质量统计控制

STATISTICALQUALITYCONTROLUSINGEXCELSecondEditionAlsoavailablefromASQQualityPress:TheDeskReferenceofStatisticalQualityMethodsMarkL.CrossleyImprovingPerformancethroughStatisticalThinkingASQStatisticsDivisionTheHandbookofAppliedAcceptanceSampling:Plans,Procedures,andPrinciplesKennethS.StephensGlossaryandTablesforStatisticalQualityControl,ThirdEditionASQStatisticsDivisionInnovativeControlCharting:PracticalSPCSolutionsforToday’sManufacturingEnvironmentStephenA.WiseandDouglasC.FairSPCEssentialsandProductivityImprovement:AManufacturingApproachWilliamA.LevinsonandFrankTumbeltyTheUncertaintyofMeasurements:PhysicalandChemicalMetrologyandAnalysisS.K.KimothyZeroAcceptanceNumberSamplingPlans,FourthEditionNicholasL.SquegliaStatisticalProcessControlMethodsforLongandShortRuns,SecondEditionGaryK.GriffithTorequestacomplimentarycatalogofASQQualityPresspublications,call800-248-1946,orvisitourWebsiteat—2nded.p.cm.Includesbibliographicalreferencesandindex.ISBN0-87389-566-5(SoftCover,AutoBind:alk.paper)1.Qualitycontrol—Dataprocessing.2.MicrosoftExcel(Computerfile)I.Icenogle,Marjorie.II.Title.TS156.Z542003658.5'62—dc212002014684©2003byASQAllrightsreserved.Nopartofthisbookmaybereproducedinanyformorbyanymeans,electronic,mechanical,photocopying,recording,orotherwise,withoutthepriorwrittenpermissionofthepublisher.10987654321ISBN0-87389-566-5Publisher:WilliamA.TonyAcquisitionsEditor:AnnemiekeKoudstaalProjectEditor:PaulO’MaraProductionAdministrator:GretchenTrautmanSpecialMarketingRepresentative:DavidLuthASQMission:TheAmericanSocietyforQualityadvancesindividual,organizational,andcommunityexcellenceworldwidethroughlearning,qualityimprovement,andknowledgeexchange.AttentionBookstores,Wholesalers,Schools,andCorporations:ASQQualityPressbooks,videotapes,audiotapes,andsoftwareareavailableatquantitydiscountswithbulkpurchasesforbusiness,educational,orinstructionaluse.Forinformation,pleasecontactASQQualityPressat800-248-1946,orwritetoASQQualityPress,P.O.Box3005,Milwaukee,WI53201-3005.ToplaceordersortorequestafreecopyoftheASQQualityPressPublicationsCatalog,includingASQmembershipinformation,call800-248-1946.VisitourWebsiteat://[e-mail]e,Wisconsin53203vTomygrandchildrenSamantha,Arthur,Richard,andElizabeth—S.M.Z.TomynephewBrian,andniecesTaliaandKristin—M.L.I.ContentsPreface............................................xvWhySpreadsheets?..................................xvSelectingaSpreadsheetProgram..........................xviOrganization......................................xviiFeatures.........................................xviiiAcknowledgments...................................xviiiPartIStartingChapterOneIntroduction...............................3Introduction......................................3WhatIsStatisticalQualityControl?.........................4WhatIsStatisticalProcessControl?......................4WhatIsAcceptanceSampling?.........................6WhyUseSpreadsheets?................................6HowtoUseThisText.................................7OrganizationandFeatures..............................9Summary........................................9ChapterTwoSQCandSpreadsheetPrograms....................11Introduction......................................11HistoryofQualityControl..............................12StructureofSQCProblems..............................12StatisticalProcessControl............................12AcceptanceSampling..............................13UsingSpreadsheet(Worksheet)TemplatesAsSoftware.............16EditingtheTemplates.................................16LockingWorksheetCellsforOtherUsers......................16ExcelCapabilities...................................18Summary........................................19PartIIFundamentalsofExcelxpChapterThreeMicrosoftExcelBasics.........................23WhatAreWorksheetPrograms?...........................24viTableofContentsviiWarning.........................................26OperatingintheMicrosoftWindowsxpEnvironment..............26UsingtheMouse.................................26UnderstandingtheExcelOperatingEnvironment.................26WhyUseMicrosoftExcel?............................26StartingExcel...................................27ClosingExcel...................................27ShuttingDownYourComputer.........................29TheExcelWindow................................29UnderstandingtheDialogBoxesinExcelxp.................31Opening,Creating,Saving,andClosingWorkbo