Software Comparison Table

Overview

 Quantum XLMinitabQuality CompanionCrystal BallSPC XLDOE Pro
Single license price$549$1,595$995$995 w/o Optimization
$1,995 with Optimization
$249$249
Design of ExperimentsCheck   Check
General Statistical ToolsCheckCheck  Check 
Companion ToolsCheck Check   
Monte Carlo SimulationCheck  Check  

Design of Experiments (DOE)

Unique Features

 Quantum XLMinitabQuality CompanionCrystal BallSPC XLDOE Pro
Regression AdvisorCheck     
Automatic S-hat ModelingCheck    Check
Mixed Response ModelingCheck     

Regression Type

 Quantum XLMinitabQuality CompanionCrystal BallSPC XLDOE Pro
Ordinary Least SquaresCheck    Check
Weighted RegressionCheck     
Binary Logistic RegressionCheckCheck    
Nominal Logistic RegressionCheckCheck    
Ordinal Logistic Regression Check    

Independent Variable Types

 Quantum XLMinitabQuality CompanionCrystal BallSPC XLDOE Pro
Optimize Least Squares ModelsCheckCheck   Check
Optimize Binary Logistic ModelsCheck     
Optimize Nominal Logistic ModelsCheck     
Optimize Mixed (Least Squares, Binary, and Nominal) ModelsCheck     
Optimize with constraintsCheck     

Prediction

 Quantum XLMinitabQuality CompanionCrystal BallSPC XLDOE Pro
Predict Least Squares ModelsCheckCheck   Check
Predict Binary Logistic ModelsCheckCheck    
Predict Nominal Logistic ModelsCheckCheck    
Predict Mixed (Least Squares, Binary, and Nominal) ModelsCheck     
Quality Measures (Cp, Cpk, dpm, etc.)Check     

Charts

 Quantum XLMinitabQuality CompanionCrystal BallSPC XLDOE Pro
Pareto of Regression CoefficientsCheckCheck   Check
Interaction PlotCheckCheck   Check
Main Effect PlotCheckCheck   Check
Thumbnail PlotCheckCheck   Check
Surface and Contour PlotCheckCheck   Check
Residual PlotsCheckCheck   Check

Design Types

 Quantum XLMinitabQuality CompanionCrystal BallSPC XLDOE Pro
Design WizardCheck    Check
2-Level Full/Fractional FactorialCheckCheck   Check
3-Level Full FactorialCheck   Check
N-Level (mixed) FactorialCheckCheck    
Central Composite (CCD)CheckCheck   Check
Box-BehnkenCheckCheck   Check
Plackett-BurmanCheckCheck   Check
TaguchiCheckCheck   Check
CustomCheck    Check
D-OptimalCheckCheck    
Mixture Check    

Design Features

 Quantum XLMinitabQuality CompanionCrystal BallSPC XLDOE Pro
BlockingCheckCheck    
FoldingCheckCheck    
Automatic S-hat modelCheck    Check
Table FormatCheck    Check
Stacked FormatCheckCheck    
RandomizationCheckCheck   Random string only
Add Center PointsCheckCheck    

General Statistics Tools

Data template

 Quantum XLMinitabQuality CompanionCrystal BallSPC XLDOE Pro
One factorCheck     
Two factorsCheck     
Specification limitsCheck     
X-Axis columnCheck     
Random dataCheck     
Select multiple analysis on sheetCheck     
Analyze templateCheck     

Control Charts

 Quantum XLMinitabQuality CompanionCrystal BallSPC XLDOE Pro
XbarR ChartCheckCheck  Check 
XbarS ChartCheckCheck  Check 
IMR ChartCheckCheck  Check 
p ChartCheckCheck  Check 
c ChartCheckCheck  Check 
np ChartCheckCheck  Check 
u ChartCheckCheck  Check 
Ability to add points to existing chartsCheckCheck  Check 
Assign labels to X Axis of control chartCheckCheck  Check 
Custom out-of-control checkingCheckCheck  Check 
Custom Control LimitsCheckCheck  Check 
On-sheet scrolling controlsCheck     
StDev estimate optionsCheckCheck    
Scroll control chartsCheckCheck  Check 
Split limitsCheckCheck  Check 
OutliersCheckCheck  Check 

Cpk

 Quantum XLMinitabQuality CompanionCrystal BallSPC XLDOE Pro
Spec limitsCheckCheck  Check 
Spec limits linked to cellCheck     
Spec limits are boundariesCheckCheck    
Plot target valueCheckCheck    
Ppk curveCheckCheck  Check 
Cpk curveCheckCheck    
Both curvesCheckCheck    
Multiple chartsCheckCheck    
Overlaid chartsCheckCheck    
StDev estimate optionsCheckCheck    
CpCheckCheck    
Lower CI bound for CpCheckCheck    
Upper CI bound for CpCheckCheck    
CplCheckCheck    
CpuCheckCheck    
CpkCheckCheck    
Lower CI bound for CpkCheckCheck    
Upper CI bound for CpkCheckCheck    
PpCheckCheck  Check 
PplCheckCheck    
PpuCheckCheck    
PpkCheckCheck  Check 
Observed Defects ( < LSL)CheckCheck    
Observed Defects ( > LSL)CheckCheck    
Observed Defects ( Total )CheckCheck    
Short Term Defects ( < LSL)CheckCheck    
Short Term Defects ( > LSL)CheckCheck    
Short Term Defects ( Total )CheckCheck    
Long Term Defects ( < LSL)CheckCheck    
Long Term Defects ( > LSL)CheckCheck    
Long Term Defects ( Total )CheckCheck  Check 
Sample sizeCheckCheck  Check 
Mean OverallCheckCheck  Check 
Stdev OverallCheckCheck  Check 
Stdev WithinCheckCheck    
MinCheckCheck    
MaxCheckCheck    
UpdatableCheckCheck    

Histogram

 Quantum XLMinitabQuality CompanionCrystal BallSPC XLDOE Pro
Distributions fit: NormalCheckCheck  Check 
Distributions fit: ExponentialCheckCheck    
Distributions fit: 2-Parameter WeibullCheckCheck  Check 
Distributions fit: 2-Parameter ExponentialCheckCheck  Check 
Distributions fit: 2-Parameter GammaCheckCheck    
Distributions fit: 2-Parameter LogisticCheckCheck    
Distributions fit: 2-Parameter LogLogisticCheckCheck    
Distributions fit: 2-Parameter LogNormalCheckCheck    
Distributions fit: 3-Parameter GammaCheckCheck    
Distributions fit: 3-Parameter LogNormalCheckCheck    
Distributions fit: 3-Parameter WeibullCheckCheck    
Overlaid chartsCheck     
Spec limitsCheckCheck    
Spec limits linked to cellCheck     
UpdatableCheckCheck    

Scatter Plot

 Quantum XLMinitabQuality CompanionCrystal BallSPC XLDOE Pro
Overlaid chartsCheckCheck    
Selectable X and Y columnsCheckCheck    
Linear regression lineCheckCheck  Check 
Logarithmic regression lineCheckCheck  Check 
Polynomial regression lineCheckCheck  Check 
Power regression lineCheckCheck  Check 
Exponential regression lineCheckCheck  Check 
Extrapolate ModelCheckCheck  Check 
Regression analysisCheckCheck    
On-sheet predictionCheck     
UpdatableCheckCheck    

Pareto

 Quantum XLMinitabQuality CompanionCrystal BallSPC XLDOE Pro
2D columnsCheckCheck  Check 
2D columns with cum. lineCheckCheck  Check 
3D columnsCheckCheck  Check 
Pareto reportCheckCheck  Check 
Maximum number of barsCheckCheck  Check 
‘Others’ groupCheckCheck  Check 
‘Custom ‘Others’ group captionCheckCheck  Check 
Sort barsCheckCheck  Check 
Sort datasetsCheckCheck    
Multiple pareto chartsCheck     
Grid of pareto chartsCheckCheck    
UpdatableCheckCheck    

Dot Plot

 Quantum XLMinitabQuality CompanionCrystal BallSPC XLDOE Pro
Multiple datasetsCheckCheck  Check 
Two dimensional plotCheckCheck    
Summary stats Check  Check 
UpdatableCheckCheck    

Box Plots

 Quantum XLMinitabQuality CompanionCrystal BallSPC XLDOE Pro
MinimumCheckCheck  Check 
MaximumCheckCheck  Check 
MeanCheck   Check 
OutliersCheckCheck    
Suspected OutliersCheckCheck    
Gap between barsCheckCheck    
Box height: Interquartile rangeCheckCheck  Check 
Box height: CustomCheckCheck    
Custom Whiskers typeCheckCheck    
UpdatableCheckCheck    

Distribution Fit

 Quantum XLMinitabQuality CompanionCrystal BallSPC XLDOE Pro
NormalCheckCheck    
ExponentialCheckCheck    
2-Parameter WeibullCheckCheck    
2-Parameter ExponentialCheckCheck    
2-Parameter GammaCheckCheck    
2-Parameter LogisticCheckCheck    
2-Parameter LogLogisticCheckCheck    
2-Parameter LogNormalCheckCheck    
3-Parameter GammaCheckCheck    
3-Parameter LogNormalCheckCheck    
UpdatableCheckCheck    

Multi-Vari Charts

 Quantum XLMinitabQuality CompanionCrystal BallSPC XLDOE Pro
MeanCheckCheck    
MedianCheckCheck    
MinimumCheckCheck    
MaximumCheckCheck    
Show range lineCheckCheck    
Connect meansCheckCheck    
Group meanCheckCheck    
Grand meanCheckCheck    
Standard deviationCheckCheck    
UpdatableCheckCheck    

Hypothesis tests

 Quantum XLMinitabQuality CompanionCrystal BallSPC XLDOE Pro
Advisor WizardCheckCheck    
Auto TestCheck     
One sample t-TestCheckCheck  Check 
Two samples t-testCheckCheck  Check 
Paired t-testCheckCheck  Check 
One-way ANOVACheckCheck  Check 
Two-way ANOVA (Crossed)CheckCheck    
Two-way ANOVA (Nested)CheckCheck    
F-testCheckCheck  Check 
Levene’s testCheckCheck    
Bartlett’s testCheckCheck    
1-Sample SignCheckCheck    
1-Sample WilcoxonCheckCheck    
FriedmanCheckCheck    
Mood’s MedianCheckCheck    
Kruskal-WallisCheckCheck    
Mann-WhitneyCheckCheck    
One proportion testCheckCheck    
Two proportions testCheckCheck  Check 
Contingency TableCheckCheck  Check 
Multiple response regression Check  Check 
Correlation matrixCheckCheck  Check 
Power test for one sample t-TestCheckCheck    
Power test for one sample t-testCheckCheck    
Power test for two samples t-testCheckCheck    
Power test for paired t-testCheckCheck    
Power test for one-way ANOVACheckCheck    
Power test for varianceCheckCheck    
Power test for one proportion testCheckCheck    
Power test for two proportions testCheckCheck    
Confidence IntervalsCheckCheck  Check 
Custom alpha levelCheckCheck    
Custom confidence levelCheckCheck    
Show box plotCheckCheck    
Show dot plotCheckCheck    
UpdatableCheckCheck    

Measurement System Analysis

 Quantum XLMinitabQuality CompanionCrystal BallSPC XLDOE Pro
ANOVACheckCheck  Check 
XbarRCheckCheck  Check 
Nested ANOVACheckCheck  Check 
Attribute: CrosstabulationCheckCheck  Check 
Attribute: Analytic methodCheckCheck    
Gage Performance CurveCheckCheck    
Gage LinearityCheckCheck    
BiasCheckCheck  Check 
Stats AdvisorCheck     
UpdatableCheckCheck    

Decision Trees

 Quantum XLMinitabQuality CompanionCrystal BallSPC XLDOE Pro
 Check     

DSM

 Quantum XLMinitabQuality CompanionCrystal BallSPC XLDOE Pro
Create matrixCheck     
Edit matrixCheck     
DSM NavigatorCheck     
SequenceCheck     
ALAP and AEAPCheck     

Component swapping

 Quantum XLMinitabQuality CompanionCrystal BallSPC XLDOE Pro
 Check     

Stack Columns

 Quantum XLMinitabQuality CompanionCrystal BallSPC XLDOE Pro
 CheckCheck  Check 

Unstack columns

 Quantum XLMinitabQuality CompanionCrystal BallSPC XLDOE Pro
 CheckCheck  Check 

Random Numbers

 Quantum XLMinitabQuality CompanionCrystal BallSPC XLDOE Pro
NormalCheckCheck  Check 
ExponentialCheck   Check 
UniformCheckCheck  Check 
TriangularCheckCheck    
Log-NormalCheckCheck    
WeibullCheckCheck  Check 
GammaCheckCheck    
LogisticCheckCheck    
Log-LogisticCheckCheck    
Uniform DiscreteCheckCheck  Check 
PoissonCheckCheck    
BinomialCheckCheck    
BinaryCheckCheck    
Table formatCheckCheck    
Group By formatCheckCheck    
Generator per columnCheckCheck    
Chi-SquareCheck     
FCheck     
tCheck     
GeometricCheck     
HypergeometricCheck     
IntegerCheck     
BetaCheck     
CauchyCheck     
LaplaceCheck     
Largest Extreme ValueCheck     
Smallest Extreme ValueCheck     

Other features

 Quantum XLMinitabQuality CompanionCrystal BallSPC XLDOE Pro
Excel data sourceCheck   Check 
‘Group by’ data sourceCheckCheck    
SQL data sourceCheck     
SmartSelectCheck   Check 
CNX Template and diagram    Check 
Discrete distribution calculatorBinomialCheck  Check 
Continuous distribution calculatorNormal, WeibullCheck  Check 
Main Effects Plot Check  Check 
Run Chart Check  Check 
Cumulative Sum Chart (CUSUM) Check  Check 
Product Capability Report    Check 
Xbar +/- 3s Chart    Check 

Reliability Tools

 Quantum XLMinitabQuality CompanionCrystal BallSPC XLDOE Pro
Uncensored Parametric AnalysisCheckCheck    
Exact, Left, Right, Interval Cencored AnalysisCheckCheck    
Maximum Likelihood EstimationCheckCheck    
Goodness of Fit MeasuresCheckCheck    
Reliability Plots: hazard, survival, pdfCheckCheck    
MTBF and Percentile AnalysisCheckCheck    

Companion Tools (FMEA, QFD, and Pugh Concept Selection)

QFD

 Quantum XLMinitabQuality CompanionCrystal BallSPC XLDOE Pro
QFD WizardCheck Check   
Create PCM matrixCheck     
Edit PCM matrixCheck     
Sort PCMCheck     
Pareto PCMCheck     
Create House of QualityCheck Check   
Edit HOQCheck Check   
Sort HOQCheck Check   
Sort HOQCheck Check   
Pareto HOQCheck Check   

Pugh matrix

 Quantum XLMinitabQuality CompanionCrystal BallSPC XLDOE Pro
CreateCheck Check   
EditCheck Check   
SortCheck Check   
Create chartCheck Check   

FMEA

 Quantum XLMinitabQuality CompanionCrystal BallSPC XLDOE Pro
Create matrixCheck Check Check 
Current process controlsCheck Check Check 
Recommended actionsCheck Check   
Action resultsCheck Check Check 
Add/Remove groupCheck Check   
Add/Remove failure modeCheck Check   
Add/Remove failure causeCheck Check   
Top 20 paretoCheck Check   
Custom paretoCheck Check    
Show/Hide columnsCheck Check   

Monte Carlo Simulation

Model Building

 Quantum XLMinitabQuality CompanionCrystal BallSPC XLDOE Pro
IPO SheetsCheck     
Import from DOE ProCheck     
Any cell can be input/outputCheck  Check  
Merge and Visual MergeCheck     

Speed

 Quantum XLMinitabQuality CompanionCrystal BallSPC XLDOE Pro
Monte Carlo Simulations 1Rocket Mode  Extreme Speed  
Benchmark 2

1.09 Seconds

(Quantum XL is up to 9X faster than Crystal Ball)

  9.73 Seconds  

1Both Quantum XL and Crystal Ball use external calculation engines to speed up simulations in Excel. Quantum XL’s is called “Rocket Mode” while Crystal Ball’s is called “Extreme Speed”.

2Test platform: Vista, Excel 2007 SP2, 1GB RAM, CPU Intel 3.00GHz

Tested Model: Crystal Ball Examples Guide > ‘Cell Phone’

Number of simulations run: 1,000,000

Monte Carlo Statistics

 Quantum XLMinitabQuality CompanionCrystal BallSPC XLDOE Pro
Normal Distribution StatsCheck  Check  
Count out of specCheck  Check  
Percentile StatsCheck  Check  
Export EVA Raw DataCheck  Check  

Monte Carlo Features

 Quantum XLMinitabQuality CompanionCrystal BallSPC XLDOE Pro
N=10K to 1 Million SimulationsCheck  Check  
Tolerance Allocation TableCheck     
Sensitivity AnalysisCheck  Check  
Latitude PlotCheck     
Option for Embedded HistogramsCheck  Check  
Percent ContributionCheck  Check  
Descriptive Sampling SupportCheck  Check  
Native Mode Monte CarloCheck  Check  
Input/Output ManagerCheck  Check  

Optimization

 Quantum XLMinitabQuality CompanionCrystal BallSPC XLDOE Pro
Optimize single outputCheck  Additional $1,000  
Reduce dpm across multiple outputsCheck  Additional $1,000  
Optimize on Cp, Cpk, Median, dpm, etc.Check  Additional $1,000  
Optimize with constraintsCheck  Additional $1,000  
Advanced Optimization TechnologyCheck  Additional $1,000  

Supported Distributions

 Quantum XLMinitabQuality CompanionCrystal BallSPC XLDOE Pro
NormalCheck  Check  
ExponentialCheck  Check  
Uniform ContinuousCheck  Check  
TriangularCheck  Check  
Log-NormalCheck  Check  
LogisticCheck  Check  
Log-LogisticCheck  Check  
Weibull (3 Parameter)Check  Check  
Uniform DiscreteCheck  Check  
PoissonCheck  Check  
BinaryCheck  Check  
BinomialCheck  Check  
Empirical DistributionCheck  Check  
Custom Continuous DistributionCheck  Check  
Custom Discrete DistributionCheck  Check  

Sampling Matrices

 Quantum XLMinitabQuality CompanionCrystal BallSPC XLDOE Pro
Latin Hypercube Sampling (LHS)Check     
Descriptive SamplingCheck     

Note:

* Minitab version v18 used for comparison

* Quality Companion v3 used for comparison

* Quantum XL 2016 used for comparison