Minitab - QI Macros Comparison

Minitab

QI Macros

Big Differences

Price

$1,195

$199

Development History and User Interface

• Minitab - fill-in-a-form interface
  using"before mouse" technology
  
  
• QI Macros - point-and-click interface
  using "after mouse" technology

Developed by Penn State Instructors to teach students everything there is to know about statistics

Developed by a Business User to help business people to get immediate results

Data Orientation

Columns Only

Columns and Rows

Data Selection

Menus of Options

Grab it and Go

Statistics and Charts

Everything under the sun

Most commonly used

Control Chart Wizard Chooses charts automatically

N

Y

Pivot Table Wizard - Automates analyzing data

N

Y

Learning Curve

Days

Minutes

Application

Stand Alone, which means you have to import data

Excel Addin, which means you can work on data directly

Define, Measure, Analyze, Improve Control (DMAIC)

Balanced Scorecard

Y

SIPOC

Y

Flow chart

Y

Run chart

Y

Y

Pareto chart

Y

Y

Fishbone diagram

Y

Y

Failure Modes and Effects Analysis (FMEA)

Y

Scatter chart

Y

Action plan, Gantt charts

Y

Control Chart Wizard: Analyzes your data and selects the correct control chart for you!

Y

Statistical Process Control (SPC - Control)

Pre-Control Chart

Y

Control Plan (AIAG)

Y

Control charts: XBar, XBar-S, XmR, CUSUM, p, np, c, u

Y

Y

Historical/shift-in-process charts

Y

Y

Process capability

Y

Y

Process Capability SixpackTM

Y

Fivepack

Multi-Vari charts

Y

Y

Symmetry plot

Y

Y

Scatter plots, boxplots, dotplots, histograms, charts, time series plots

Y

Y

Probability plots, contour plots

Y

Y

Matrix plots, pie charts

Y

Y

Control charts: MA, EWMA, zone

Y

Y

Short Run and Median Control charts

Y

Y

Multivariate control charts: T2, generalized variance, MEWMA

Y

T2

Box-Cox transformation

Y

Y

Johnson transformation

Y

Design for Six Sigma

QFD House of Quality

Y

Pugh Concept Selection Matrix

Y

Measurement Systems Analysis

Gage R&R: ANOVA and XBar-R methods

Y

Y

Attribute Gage Study - AIAG long method

Y

Y

Gage linearity and accuracy

Y

Y

Gage run chart

Y

Y

Nested Gage R&R

Y

Attribute agreement analysis

Y

Basic Statistics

Descriptive statistics

Y

Y

Confidence intervals, one- and two-sample t-tests, paired t-tests

Y

Y

Correlation and covariance

Y

Y

Chi-square test

Y

Y

Normality test

Y

Y

Test for equal variances

Y

Y

Analysis of Variance (ANOVA)

Y

Y

Regression Analysis

Linear regression

Y

Y

Residual plots

Y

Y

Polynomial regression

Y

Logistic regression

Y

Partial least squares (PLS)

Y

Stepwise and best subsets

Y

Design of Experiments

Two-level factorial designs

Y

Y

General full factorial designs

Y

Y

Plackett-Burman designs

Y

Y

Taguchi designs

Y

Y

Analysis of variability for factorial designs

Y

Y

User-specified designs

Y

Response surface designs

Y

Mixture designs

Y

D-optimal and distanced-based designs

Y

Response prediction

Y

Botched runs

Y

Mixture plots

Y

Y

Overlaid contour plot

Y

Plots: residual, main effects, interaction, cube, contour, surface, and wireframe

Y

Response optimization

Y

Reliability/Survival Analysis

Parametric and nonparametric distribution analysis

Y

Y

Goodness-of-fit measures

Y

Y

ML and least squares estimates

Y

Exact failure, right-, left-, and interval-censored data

Y

Accelerated life testing

Y

Regression with life data

Y

Reliability test plans

Y

Threshold of parameter distributions

Y

Analysis of repairable systems

Y

Analysis of multiple failure modes

Y

Probit analysis

Y

Weibayes analysis

Y

Hypothesis tests on distribution parameters

Y

Plots: distribution, probability, hazard, and survival

Y

Confidence intervals

Y

Power and Sample Size

One-sample Z, t, and proportion

Y

Y

Two-sample t and proportion

Y

Y

One-way ANOVA, two-level factorial, and Plackett-Burman

Y

Y

Solve for number of center points

Y

Multivariate Analysis

Principal component analysis

Y

Discriminant analysis

Y

Cluster analysis

Y

Factor analysis

Y

Correspondence analysis

Y

Time Series and Forecasting

Time series plots

Y

Y

Auto-, partial auto-, and cross correlations

Y

Y ARIMA analysis

Y

Trend analysis

Y

Decomposition

Y

Exponential smoothing

Y

Y

Winter's method

Y

Moving average

Y

Y

Nonparametrics

Sign test

Y

Y

Wilcoxon test

Y

Y

Mann-Whitney test

Y

Y

Kruskal-Wallis test

Y

Y

Friedman test

Y

Y

Runs test

Y

Mood median test

Y

Tables

Cross-tabulation interface with new measures of association

Y

Pivot Table

Contingency tables

Y

Tally

Y

Fisher's exact test for 2x2 tables

Y

Simulation and Distributions

Y

Random number generator

Y

Excel

Density, distribution, and inverse cumulative distribution functions

Y

Excel

Random sampling

Y

Excel

Ease of Use

Customizable menus and toolbars

Y

Y

Online tutorials

Y

Y

Clear, comprehensive HTML Help system

Y

Y

Project Manager: logically organizes analysis

Y

Smart dialog boxes: remember recent settings

Y

Extensive preferences and user-editable profiles

Y

Y

Data and File Management

Save output and data as HTML

Y

Excel

Unlimited worksheet size

Y

Excel

Import/export: Excel, text, and other formats

Y

Excel

Import individual Microsoft Excel worksheets

Y

Unnecessary

Import currency formats

Y

Excel

ODBC querying

Y

Excel

Autofill

Y

Excel

Hide and unhide columns

Y

Excel

Data manipulation: merge, subset, sort, transpose, change data type

Y

Excel

Find and replace in Data window

Y

Excel

4000 columns per worksheet

Y

256 x 65,000

Matrix functions

Y

Excel

Double-precision worksheets

Y

Excel

New and updated sample data sets

Y

Y

Graphics

New state-of-the-art graphics engine

Y

Excel

Pictorial gallery and streamlined dialog boxes simplify graph creation

Y

Excel

Interactively edit attributes (axes, scale, etc.) and recreate custom graphs with new data

Y

Excel

Intuitive tool to place multiple graphs on one page

Y

Excel

Display data from different variables or By groups in panels on the same page

Y

Excel

Information display tools: tool tips, crosshairs, plant flags

Y

Excel

Set your own preferences for graph attribute defaults

Y

Excel

Graphs can update as data change

Y

Excel

Built-in graphs: a variety of displays available with a single click

Y

QI Macro Templates

Rotating 3D graphs

Y

Excel

Interval plots, individual value plots, area graphs

Y

Excel

Numerous special-purpose graphs

Y

Excel

OLE: edit MINITAB graphs in other applications

Y

Excel

Save as TIFF, JPEG, PNG, BMP

Y

Excel

Macros

Complete command language

Y

Excel

Powerful macro capability for automating tasks or creating new capabilities

Y

Excel

Price

$1,195

$199