SPC for MS Excel V2 - SPC for Excel

Business Process Improvement 20314 Lakeland Falls Cypress, TX 77433

281-304-9504

Instruction Manual for SPC for MS Excel V3.0

Frequency

35

30

LSL=60

25

20

15

10

5

0

57

62

Capability Analysis

Nominal=70

USL=80

67

72

77

82

Measurement

Statistics Cp=1.34 Cpk= 0.59 Cpu= 0.59 (3.84%) Cpl= 2.09 (0%) Est. Sigma= 2.49 Pp=1.31 Ppk= 0.57 Ppu= 0.57 (4.36%) Ppl= 2.04 (0%) Sigma= 2.55 Average=75.63 Count=96 No. Out of Spec=5 (5.21%) Kurtosis=0.62 Skewness=0.71

87

Thank you for selecting our software package. This program was written by Dr. William H. McNeese and is distributed by Business Process Improvement (Cypress, Texas). This program cannot be copied or used unless under license with Business Process Improvement. Business Process Improvement is not liable for any decisions made based on the use of this software package.

Requirements: This program is a Microsoft Excel? add-in. You must Microsoft Excel? for this program to work. This program supports any version of Excel from 2000 on.

Business Process Improvement 20314 Lakeland Falls Cypress, TX 77433 281-304-9504

SPC for MS Excel V3.0 Table of Contents

Instructions Manual for SPC for MS Excel V3.0 ......................................................................................... 1 Installation..................................................................................................................................................... 4 Pareto Diagrams............................................................................................................................................ 6 Histograms .................................................................................................................................................. 10 Attribute Control Charts ............................................................................................................................. 13

p Charts ................................................................................................................................................... 13 np Control Charts .................................................................................................................................... 16 c Control Charts ...................................................................................................................................... 18 u Control Charts ...................................................................................................................................... 20 Variable Control Charts .............................................................................................................................. 22

X -R Control Chart ................................................................................................................................. 22 Control Limit Option............................................................................................................................... 26

X -s Control Charts................................................................................................................................. 27 X-MR (Individuals) Control Charts ........................................................................................................ 28 Moving Average/Moving Range (MA/MR) Charts................................................................................ 30 Table X-MR (Individuals) Chart............................................................................................................. 31 Run Charts .............................................................................................................................................. 32 Subgroup Maker: Make Subgroups from Column of Numbers.............................................................. 32 Process Capability....................................................................................................................................... 33 Advanced Process Capability...................................................................................................................... 38 Scatter Diagram .......................................................................................................................................... 40 Updating Charts .......................................................................................................................................... 43 Changing Chart Options ............................................................................................................................. 43 Single Point Actions ................................................................................................................................... 44 All Points Action......................................................................................................................................... 46 Cause and Effect Diagram .......................................................................................................................... 47 Measurement Systems Analysis.................................................................................................................. 48 ANOVA Method..................................................................................................................................... 53 Range Method for Gage R&R ................................................................................................................ 55 Bias ? Independent Sample Method ....................................................................................................... 57 Bias ? Control Chart Method .................................................................................................................. 59 Linearity.................................................................................................................................................. 61 Attribute Gage R&R ............................................................................................................................... 62 Transfer Charts to PowerPoint or Word ..................................................................................................... 65 Regression................................................................................................................................................... 66 Changing the Variables in the Regression .............................................................................................. 69 Miscellaneous ............................................................................................................................................. 70 Descriptive Statistics............................................................................................................................... 70 Confidence Interval Around a Mean....................................................................................................... 71 Confidence Interval Around a Variance ................................................................................................. 73 Confidence Interval for the Difference in Two Means ........................................................................... 74 Confidence Interval for Multiple Processes............................................................................................ 76 Paired Sample Comparison..................................................................................................................... 78 Analysis of Means................................................................................................................................... 79 Correlation Coefficients.......................................................................................................................... 81 Failure Mode and Effect Analysis .......................................................................................................... 82

2

?2007 Business Process Improvement

Box and Whisker Plots............................................................................................................................ 83 Sample Size Calculator ........................................................................................................................... 85 Side by Side Histogram .......................................................................................................................... 86 Plot Multiple Y Variables Against One X Variable................................................................................ 88 Select Cells.................................................................................................................................................. 89 Frequently Asked Questions ....................................................................................................................... 90 What out of control tests does the program use? .................................................................................... 90 Do all out of control tests apply to all the charts?................................................................................... 90 How do I know if the chart has any out of control points? ..................................................................... 90 Can I remove the out of control points from the calculations? ............................................................... 90 Can I change the name of the worksheet tab containing the chart? ........................................................ 90 How come I can't see the name of one of my charts in the list of charts to be updated? ....................... 90 How can I change the title or the x and y labels on an existing chart? ................................................... 91

3

?2007 Business Process Improvement

Installation

The necessary files to run the program are installed when you run the installation program. The installation file is the .exe program you downloaded or received on the CD. Running the setup.exe file creates the following directory (there are slight differences for Excel 2007):

C:\Documents and Settings\{username}\Application Data\SPC_for_MS_Excel

The following program files are installed into this directory:

spcforexcelv3.xla spcfor2007excelv3.xlam installspcforexcelv3.exe

The installation process may leave uninstallation files such as unins001.exe and unins001.dat in this directory. During operation, the program may save user preferences and other settings in one or more text or binary files in this directory. The user is discouraged from altering any of these files and from storing any work files in this directory.

The program also creates the following directory:

C:\Documents and Settings\{username}\My Documents\SPC for MS Excel

The following sample data files and instruction manual are installed into this directory:

Gage R&R Example Workbook.xls SPC Example Data V3.xls SPC for MS Excel V3.0 Instructions.pdf

The user is encouraged to use these files to learn how SPC for MS Excel works. If you also purchased the PowerPoint training modules, they will be installed this directory as well.

The program is installed as an add-in. It will open whenever Excel is opened. In Excel 2000 to Excel 2003, SPC for Excel will appear on the Worksheet and Chart Menus next to Window. There is also a free standing toolbar that can be placed anywhere in the window. Both are shown below.

4

?2007 Business Process Improvement

In Excel 2007, SPC for Excel appears on the ribbon next to Home as shown below. The SPC Menu to the right lists all the buttons.

The menu and toolbar allows you to access the various components of the program: The data entry requirements to run each component of this program are given below. All the examples are in the workbook SPC Example Data V3.0.xls and Gage R&R V3 Example Workbook.xls. This instruction manual is intended to demonstrate how the program is used. To learn more about SPC, please refer to one of the many books on the subject. The best reference is probably Understanding Statistical Process Control by D. Wheeler and D. Chambers, SPC Inc., 1986 or any of the later books by Dr. Wheeler. You can also visit our website where many of these SPC tools are described in our past free e-zines. Go to .

5

?2007 Business Process Improvement

 ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download