To Accompany Business Statistics A Decision Making Approach 8th Ed Chapter 18 Introduction to Quality and Statistical Process Control By Groebner Shannon Fry amp Smith PrenticeHall Publishing Company ID: 148097
Download Presentation The PPT/PDF document "Guide to Using Excel 2007 For Basic Stat..." is the property of its rightful owner. Permission is granted to download and print the materials on this web site for personal, non-commercial use only, and to display it on your personal computer provided you do not modify the materials and that you retain all copyright notices contained in the materials. By downloading content from our website, you accept the terms of this agreement.
Slide1
Guide to Using Excel 2007 For Basic Statistical Applications
To AccompanyBusiness Statistics: A Decision Making Approach, 8th Ed.Chapter 18:Introduction to Quality and Statistical Process ControlByGroebner, Shannon, Fry, & SmithPrentice-Hall Publishing CompanyCopyright, 2011Slide2
Chapter 18 Excel ExamplesX-bar and R-Charts
Cattlemen’s Bar and Grillp-Charts Hilder’s Publishing Companyc-Charts Chandler Tile CompanySlide3
X-Bar and R-Charts - Cattlemen’s Bar and Grill
Issue: In order to maintain its reputation for excellent food and service, the owners need to measure product and service quality on a regular basis. Objective: Use Excel 2007 to develop a procedure to visually monitor key measures of product and service quality. Data file is Cattlemen.xlsSlide4
X-Bar and R Charts – Cattlemen’s Bar and Grill
Open the file Cattlemen.xlsSlide5
X-Bar and R Charts – Cattlemen’s Bar and Grill
Note: In columns G and HMean has been computed as: =AVERAGE(B1:E1)Range has been computed as:=(MAX(B1:E1)-(MIN(B1:E1)) Slide6
X-Bar and R Charts – Cattlemen’s Bar and Grill
Select the Add-Ins tabSelect PHStatSelect Control ChartsSelect R and XBar ChartsSlide7
X-Bar and R Charts – Cattlemen’s Bar and Grill
Subgroup/Sample Size = 4Subgroup … Cell Range: H1:H31Select First cell Contains labelsSelect R and XBar ChartsSubgroup Means Cell Range: G1:G31OKSlide8
X-Bar and R Charts – Cattlemen’s Bar and Grill
R ChartSlide9
X-Bar and R Charts – Cattlemen’s Bar and Grill
X-Bar ChartSlide10
p-Charts -
Hilder’s Publishing CompanyIssue: The manager of the order entry department has decided to develop a process control chart to monitor the order entry errors. Objective: Use Excel 2007 to develop a procedure to visually monitor order entry form error percentage. Data file is Hilders.xlsSlide11
p-Charts – Hilder’s Publishing Company
Open the File Hilders.xlsSelect the Add-Ins TabSelect PHStatSelect Control ChartsSelect p ChartSlide12
p-Charts – Hilder’s Publishing Company
Non-Conformance cell range: C1:C31Select First cell contains labelSelect Size does not varySample/Subgroup Size 100Neither Excel nor the PHStat add-ins contain a Mann–Whitney U-test,Slide13
p-Charts – Hilder’s Publishing CompanySlide14
c-Charts -
Chandler Tile CompanyIssue: The company wants to develop a procedure to monitor the number of defects in its production of tiles. Objective: Use Excel 2007 to develop a procedure to visually monitor surface scratches in tile. Data file is Chandler.xlsSlide15
c-Charts – Chandler Tile Company
Open the file Chandler.xlsCompute the average of Column C as shown.Slide16
c-Charts – Chandler Tile Company
Compute the Upper Control limit using the formula shown.Copy and paste cells C1 and D1 through the bottom of the listSlide17
c-Charts – Chandler Tile Company
Compute the Lower Control Limit as C2-(3*(SQRT(C2))Since the result is negative load the value 0 into the columnSlide18
c-Charts – Chandler Tile Company
Highlight Columns B,C,D and ESelect the Insert tabClick Line Chart Slide19
c-Charts – Chandler Tile Company
Out of Control
UCL=12.86
Avg
C = 5.7
LCL = 0