|
Jay Arthur
888-468-1537
303-756-9144
KnowWare
International, Inc.
DBA LifeStar
2253 S. Oneida
Ste 3D
Denver, CO 80224
We work with companies
that want to fire up their profits using
Lean Six Sigma
Copyright © 2011
|
|
This QI Macros tutorial
CD contains step-by-step instructions for creating charts, graphs, and
diagrams to support your Six Sigma and ISO needs. To maximize the benefit
of this CD, you'll need to be able to hear the instructions using a headphone
or speakers.
Required Software
To run the tutorials on this CD you will need to have Adobe's Macromedia
Flash player loaded on your computer. Download a free copy at
Here is the table of contents:
Getting Started
- How to Install the QI Macros
- Overview of the QI Macros Menu and Options
- How to Create Charts Using the QI Macros
- Preprocessing Your Data using PivotTables
- QI Macros Test Data
- Excel 2007 Ribbon
- MS Office Interfaces
The QI Macros Have Four Main Parts:
The Tools are Also Grouped Alphabetically and by Improvement Process:
Detailed Sub Menus
QI Macros Charts
- Overview
- QI Macros Test Data
- Charts
- Pareto Chart
- Run Chart
- Scatter Chart
- Matrix Plot
- Excel Charts
- Line Graph
- Bar Chart
- Pie Chart
- Spider Radar Chart
- Line - Column on 2 Axes
- Box &Whisker
- Dot Plot
- Frequency Histogram
- Histogram
- Change Spec Limits After You Run a Chart
- How Number of Bars are Calculated
- Changing Approximate # of Bars After You Run a Chart
- Changing Exact # of bars Using Class Width
- Move Text Boxes and Spec Limit Lines
- Multivari
- Cusum
- Control Chart Wizard
- Control Charts
- XmR Chart (Individuals)
- XmR Trend
- XbarR Chart (2-5 samples)
- XbarS Chart (6-25 samples)
- XMedianR Chart
- EWMA
- Moving Average
- Levey Jennings
- Hotelling T2 (Multivariate)
- c chart
- np chart
- p chart
- u chart
- Control Chart Rules
- Stability Analysis
- How to Change Control Chart Stability Rules
- How to Show / Hide Sigma Lines
- Control Chart Functions
- Add Data to an Existing Chart
- Delete a Point from a chart
- Show Process Change on a chart
- Rerun stability analysis on a chart
Fill-in-the-Blanks Templates
- Action Plan
- Affinity Diagram
- Arrow Diagram
- Balanced Scorecard
- Block Diagram
- Blue Ocean Strategy
- Box and Whisker
- c Chart template
- Check Sheet
- Control Chart Templates
- Add Data to an Existing Chart
- Delete a Point from a chart
- Show Process Change on a chart
- Rerun stability analysis on a chart
- Control Plan (AIAG)
- Cost Benefit Analysis
- Cost of Poor Quality Matrix
- Countermeasures Matrix
- Cp, Cpk Worksheet
- Cusum
- Design of Experiments
- Error Modes & Effects Analysis
- EWMA Chart
- Failure Modes & Effects Analysis
- Failure Prevention Analysis
- Fault Tree Diagram
- Flow Chart
- Force Field Analysis Matrix
- g Chart
- Gage R&R (AIAG)
- Gage R&R Attribute Study
- Gage R&R Linearity
- Gantt Chart
- Hazard Analysis
- Histogram with Cp, Cpk
- Hotelling T2 Individuals
- Ishikawa (Fishbone) Diagram
- L-, T-, X-Shaped Matrix
- Lean Scorecard
- Lean Takt Time and NVA
- Levey-Jennings QC Chart
- Measurement Matrix
- Moving Average
- Non-Parametric Tests
- np Chart Template
- p Chart Template
- Pareto Chart
- PDPC Chart
- PPAP Forms for AIAG
- PreControl Chart
- Probability Plot
- Project Charter
- Pugh Concept Selection Matrix
- QFD House of Quality
- QI Story
- Relationship/Systems Diagram
- Risk Assessment Matrix
- ROC Curve
- ROI Calculator
- Run Chart
- Sample Size Calculator
- Scatter
- SIPOC
- Speedometer Chart
- Stakeholder Analysis
- Target and Line Chart
- Target and Means Matrix
- Time Tracking Tool
- Transition Planning Matrix
- Tree Diagram
- u Chart Template
- Value Stream Mapping
- Value-Added Flow Analysis
- Voice of the Customer Matrix
- XbarR Five Pack
- XbarS Five Pack
- XmR + USL,LSL & Target
- XmR Four Pack
- Youden
Anova and Statistical Tools
- Anova: Single Factor
- Anova: Two Factor with Replication
- Anova: Two Factor without Replication
- Chi-Squared
- F-Test: Two-sample for variances
- t-Test One-sample
- t-Test: Paired two-sample for means
- z-Test: Two-sample for means
- Correlation
- Covariance
- Descriptive Statistics
- Exponential Smoothing
- Fourier Analysis
- Moving Average
- Non-Parametric
- Normality Test
- Rank and Percentile
- Regression Analysis
- Sample Size Calculator
Data Transformation Tools
- Box Cox Transformation
- Get Sample From Table
- Paste Link and Paste Link Transpose
- Stack and Restack Tables
- Word Count
- Cross Tabulation- PivotTable Wizard
Lean Production
- Lean Takt Time and NVA
- Time Tracking Tool
- Value Stream Mapping
- Value-Added Flow Analysis
DMAIC - Six Sigma
Define
- Affinity Diagram
- Balanced Scorecard
- Flow Chart
- Measurement Matrix
- Project Charter
- Voice of the Customer Matrix
Measure
- Control Charts
- Cost of Poor Quality
- Gage R&R (AIAG)
- Other Charts
- Check Sheet to collect data manually
- SIPOC
Analyze
Defects
- Control Charts - Is the process stable?
- Pareto Chart - What are the contributors to the problem?
- Ishikawa (Fishbone) Diagram - Ask Why? five times
- Countermeasures Matrix - What are the potential solutions?
- Action Plan - Who will do what to implement the countermeasures?
Variation
- Control Charts - Is the process stable?
- Histograms with Cp and Cpk - Is the process capable?
- Matrix Plot - Are there cause-effect relationships?
- Scatter
Improve
- DOE - Design of Experiments
- FMEA - Failure Modes and Effects Analysis
- Flow Chart
- Gage R&R (AIAG)
Control
- Control Plan (AIAG)
- Process Stability
- Control Charts (SPC)
- Process Capability
- Histograms with Cp and Cpk
DFSS - Design for Six Sigma
- DOE - Design of Experiments
- FMEA - Failure Modes and Effects Analysis
- Gage R&R (AIAG)
- Pugh Concept Selection Matrix
- QFD House of Quality
|
|
Try QI Macros
FREE
For 30-Days
|
view cart · contact 
view cart | contact