Download - Minitab Tutorial - University of Michigan
Minitab Tutorial
University of Michigan: Six Sigma, P. Hammett 1
Minitab Tutorial
Basic Commands and Data EntryGraphical Tools
Descriptive Statistics
Outline
Minitab Basics Basic Commands, Data Entry, and Organizationy g
Minitab Project Files (*.mpj) vs. Worksheet Files (*.mtw) Data Entry (entering data, copying/pasting from Excel) Numerical Data vs. Categorical (Text) vs. Time/Date Data
Statistical Analysis (‘STAT MENU’) Tally Individual Values Pareto Chart Descriptive Statistics/Graphical Summary
Graphical Analysis (‘GRAPH’ MENU)Hi t /B Pl t/M lti l B Pl t
2
Histogram/Box Plot/Multiple Box Plot Time Series Plot Edit Graphical Output
Data Set Manipulation Subset and stratify data (Descriptive statistics by group)
Other Useful Tools: See Appendix
Minitab Tutorial
University of Michigan: Six Sigma, P. Hammett 2
Minitab Project (Example: Loan)
Session Window‘Analysis Output’
MainTools:
STAT
3
Worksheet‘Data’
GRAPH
Loan Data Set
Key Output Variable:y p Total Loan Time
Selected Input (X) Variables: UW-Staff (Underwriter Staff) Loan Value (Amount of Loan) Issues-Loan (# of Issues/Defects per Loan)
4
Issues Loan (# of Issues/Defects per Loan) Process Steps (See Excel File) Issues by Defect Categories (See Excel)
Minitab Tutorial
University of Michigan: Six Sigma, P. Hammett 3
Appendix Minitab TipsAppendix Minitab Tips
Quick and Easy Functions of Minitab
5
Run LastTool
ProjectManager
Worksheet Window
C l TitlColumn Title
T = Text
D = Date
6
Data Direction
Minitab Tutorial
University of Michigan: Six Sigma, P. Hammett 4
Last Dialog Box
Hit Ctrl + E and you will get your last Dialog Box openy g y g p
Or Click on icon located on the top bar
7
Save time!
Top Icons
Scroll = Session Window
Worksheet
Information
Report Pad
8
Graphs
Minitab Tutorial
University of Michigan: Six Sigma, P. Hammett 5
Information on Data
Click on Information icon
9
Calculator
Write the title “Loan Time *2” under column C3 Go to Calc / Calculator
10
Minitab Tutorial
University of Michigan: Six Sigma, P. Hammett 6
Calculator
Minitab has calculated the Loan Time X 2 and has put it on C3 Column
11
Session Folder
Go to Session Go to Session Window/Project Manager
Right click on the output
Select Append to R t
12
Report
Minitab Tutorial
University of Michigan: Six Sigma, P. Hammett 7
Report Pad
Click on R tReport Pad icon
13
Report Pad Export
To export the preport pad to Word Right click
on the left menu on “Report Pad”
14
p Select “Copy
to Word Processor”
Minitab Tutorial
University of Michigan: Six Sigma, P. Hammett 8
Tile Tool – Graph Folder
Suppose you want to see two or more graphs at the same time
Go to Graph Folder Select the graphs you want
to use Right click on them
15
Right click on them Select “Tile”
Tile Tool
16
Minitab Tutorial
University of Michigan: Six Sigma, P. Hammett 9
Tile Tool
Let’s do it again but select “Tile with Worksheet”
17
Layout Tool
What if I want to have 2What if I want to have 2 or 3 or 4 graphs on just one image?
Select the graphs you want to have together
Right Click on themS l t “L t T l”
18
Select “Layout Tool”
Minitab Tutorial
University of Michigan: Six Sigma, P. Hammett 10
Layout Tool
Y l You may also: Re-arrange the
order of the graphs Take graphs out Put graphs in Select how many
columns or rows
19
Once you have what you want click Finish
Change Data Type
Go to Data / Change Data / gType / Numeric to Text
20
Try typing “DC” on the next row
Minitab Tutorial
University of Michigan: Six Sigma, P. Hammett 11
Brush Tool
On a graph you see some outliers and you want to know which On a graph you see some outliers and you want to know which data point they represent
Confirm that your graph has the green symbol on the top
On the top icon section, select icon Brush Select the outliers
21
Brush Tool
On the Data Worksheet you will see them highlighted with a Dot
22
Minitab Tutorial
University of Michigan: Six Sigma, P. Hammett 12
Minitab Assistant
For many tools, may use the yMinitab Assistant for pre-formatted Analysis
23
Minitab Assistant
Minitab A i t tAssistant Scatter Plot
Example
24