Download as PPTX, PDF, TXT or read online from Scribd
Download as pptx, pdf, or txt
You are on page 1/ 44
Introduction to
Minitab
2012 ASQ. All Rights Reserved.
What We Will Learn
Participants will be able to enter data into Minitab and perform simple analysis and create graphs. Understand the different file types Minitab uses. Use Minitabs help systems. Understand and use Minitabs different views and windows.
2012 ASQ Slide 2
Minitab Minitab is a very powerful, full feature, statistics package that integrates seamlessly with Excel, PowerPoint and iGrafx Does all the math and graphics for: Sample size selection Process capability Hypothesis testing Control Charts Design of Experiments Gage R&R Confidence intervals and much more The primary analytical software for 6
2012 ASQ Slide 3
Minitab The de facto software for statistical analysis for Lean Six Sigma projects Minitab is not difficult to learn Learning Minitab will enable you to perform sophisticated analysis without doing labor intensive manual calculations. Minitab has two independent excellent context sensitive help systems World-class call in and email support for registered users
2012 ASQ Slide 4
Minitabs Opening Screens
Sessio n Windo w
Columns C1, C2, C3, . . .
Rows 1, 2, . . .
Data Window
Cells
Multiple worksheets may be open.
However, only one is active at a time. 2012 ASQ Slide 5
Minitab Accepts Three Types of Data
D suffix indicates the column contains date/time
T suffix indicates the column contains text
No suffix indicates the column contains numeric data
Data types cannot be mixed in a column. If the column
contains one cell that has text in it, the entire column is considered to be text. 2012 ASQ Slide 6
Minitab Operations The vast majority of operations effect the entire column. For example, you can not create a graph for a portion of a column.
Only the columns that can be acted upon appear on the selection (left) panel. Double clicking on a column name moves it to the action (right) panel. 2012 ASQ Slide 7
Minitab Windows Data - just as the name implies Session - output of most tests and analysis Graphs - each graph is created in a new window. Graphs are linked to the data but updates only occur when the Window>Update All Graphs Now command is performed or by right clicking on the graph and selecting Update Graph Automatically.
Information - column by column summary information about the
data
History - record of actions, useful for creating macros
2012 ASQ Slide 8
Minitab File Types
Project contains a complete record of actions taken (session window, history window, graphs and worksheet(s). Takes more disk space. Uses the file suffix .MPJ Worksheet contains the data only. Takes very little disk space. All of the Minitab files used training are worksheet files which use the suffix .MTW 2012 ASQ Slide 9
Importing Data
Each variable must be in a single column
Title each column (less than 31 characters) Blank cells will show as * Dollar signs and , separators are OK
Note: Minitab can manipulate the data to fix most problems but it is typically easier in the native program (i.e., Excel or Access)
2012 ASQ Slide 10
Exporting Data and Graphs
Graphs - click the right mouse button on any graph to open the graph sub menu. The most efficient way to copy Minitab graphs into PowerPoint is to use the copy graph command from the graph submenu, switch to PowerPoint select the paste special command then paste as a Picture (enhanced metafile)! Text - drag across the desired text then right click to open the copy dialog box or use the standard ctrl-c. Text in the session widow is a mono-space font, therefore it will not align correctly unless a monospace font is applied to it. Courier New is the most commonly used.
2012 ASQ Slide 11
Importing Data Open the file Excel-Minitab.XLS Select and copy from A2 though M15 Jan Defective Electronic Component Defective Electronic Assembly Defective Mechanical Component Incorrect Component Assembled Wrong Hardware Soldering Defect Electrical Connection Wiring/cable Defect Finishing Defect Processing Defect Damaged Component Cleanliness Defect Procedural Defects
2012 ASQ Slide 12
3 0 103 38 222 188 17 88 64 9 372 204 254
Feb 7 1 169 72 233 359 42 217 121 21 472 139 288
Mar 40 247 58 328 337 49 137 103 24 551 81 254
Apr 13 4 334 90 250 454 38 190 124 31 703 122 235
May 16 1 290 57 185 288 44 131 70 20 505 111 157
Jun 5 2 171 87 119 300 42 91 47 8 436 71 121
Jul 16 5 246 120 137 353 59 95 65 15 464 120 139
Aug 13 0 140 72 109 315 37 95 79 11 449 50 101
Sep 14 2 155 65 99 225 41 79 63 13 427 55 112
Oct 10 0 178 59 131 211 77 76 77 15 428 49 144
Nov 5 103 88 85 176 34 71 42 10 300 68 122
Dec 11 2 158 57 138 193 19 56 76 6 444 36 124
Data in Minitab Data transferred from Excel. Note the * in row 2 of C4. This is the result of pasting an empty cell into Minitab. This will be treated as missing data, not as a zero.
desired graph type and fill in the dialog boxes. Note: the dialog boxes are not active until the cursor is in the box, so the options do not show in the selection panel until the cursor is in the box.
2012 ASQ Slide 19
Plot Units Failed vs. Units Submitted
Copy data from Excel spreadsheet cells A16:M17 into Minitab rows 16 27. Transpose the columns in Minitab Data>Transpose Columns
Note the data could also have been transposed in Excel using the Paste special command. 2012 ASQ Slide 20
Create a Scatterplot
2012 ASQ Slide 21
Scatterplot Scatterplot of Units Submitted I nsp vs Units Failed I nsp
Units Submitted I nsp
50000
40000
30000
20000
10000 600
2012 ASQ Slide 22
800
1000
1200
1400 1600 1800
Units Failed I nsp
2000
2200
2400
Enhancing the Graph
Scatterplot of Units Submitted Test vs Units Failed Test
Units Submitted Test
10000
Right click on the Y Axis
9000
8000
7000
6000 500
600
Worksheet: Worksheet 5
2012 ASQ Slide 23
700
800 900 Units Failed Test
1000
1100
1200
Edit Some Features of the Axis
2012 ASQ Slide 24
Enhanced Graph Scatterplot of Units Submitted I nsp vs Units Failed I nsp
Units Submitted I nsp
50000
40000
30000
20000
10000 600
800
1000 1200 1400 1600 1800 2000 2200 2400
Units Failed I nsp
2012 ASQ Slide 25
Formulae in Columns Right Click in the title box of column 15
2012 ASQ Slide 26
Enter the Formula
Changes in any of the
reference columns causes the formula to update the result in the target column. This does not occur when the calculator is used unless the assign as a formula check box is checked.
2012 ASQ Slide 27
Using Minitabs Help
Press F1 in a blank Minitab session to start at the beginning of the help system Press F1 for context sensitive help Click on at the bottom left of any menu
2012 ASQ Slide 28
Using Minitabs Help
At any dialog box, press F1 for context sensitive help or click on at the bottom left of any menu
2012 ASQ Slide 29
Minitabs Help
Minitab has an excellent context sensitive help systems
2012 ASQ Slide 30
Methods and Formulas are Very
Useful and Informative
2012 ASQ Slide 31
Create a Capability Analysis to Illustrate
Statguide Open the worksheet Sample Data.MTW Quality Tools > Capability Analysis > Normal
Click on any topic in the left panel to obtain a non-technical description in the right panel.
2012 ASQ Slide 35
Using the Minitab Report Function
Right click on the graph to bring up the menu on the right, and Select: Append Graph to Report This puts the graph into the Report Pad, which is behind the scenes in Minitab. The report can be saved by: File > Save Report As [save as Rich Text Format (*.RTF) or Web Page (*htm, *.html)] Process Capability of Sample Data LSL
USL
Process Data LSL 4 Target * USL 16 Sample Mean 10.0815 Sample N 750 StDev(Within) 1.98534 StDev(Overall) 2.21949
