Buy Now
QuantumXl 2013

Quantum XL Comparison Table

Overview

Quantum XLMinitabQuality CompanionCrystal BallSPC XLDOE ProDFSS Master
Single license price$549$1,395$995$995 w/o Optimization
$1,995 with Optimization
$249$249$399
Design of ExperimentsCheckCheck   Check 
General Statistical ToolsCheckCheck  Check  
Companion ToolsCheck Check    
Monte Carlo Simulation Check  Check  Check

Design of Experiments

Unique Features

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

Regression Type

Quantum XLMinitabQuality CompanionCrystal BallSPC XLDOE ProDFSS Master
Ordinary Least SquaresCheck    Check 
Weighted RegressionCheck      
Binary Logistic RegressionCheckCheck Not as part of DOE     
Nominal Logistic RegressionCheckCheck Not as part of DOE     
Ordinal Logistic Regression Check Not as part of DOE     

Independent Variable Types

Quantum XLMinitabQuality CompanionCrystal BallSPC XLDOE ProDFSS Master
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 ProDFSS Master
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 ProDFSS Master
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 ProDFSS Master
Design WizardCheck    Check 
2-Level Full/Fractional FactorialCheckCheck   Check 
3-Level Full FactorialCheckCheck   Check 
N-Level (mixed) FactorialCheckCheck     
Central Composite (CCD)CheckCheck   Check 
Box-Behnken CheckCheck   Check 
Plackett-BurmanCheckCheck   Check 
TaguchiCheckCheck   Check 
CustomCheck    Check 
D-OptimalCheckCheck     
Mixture Check     

Design Features

Quantum XLMinitabQuality CompanionCrystal BallSPC XLDOE ProDFSS Master
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 ProDFSS Master
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 ProDFSS Master
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 ProDFSS Master
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 ProDFSS Master
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 ProDFSS Master
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 ProDFSS Master
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 ProDFSS Master
Multiple datasetsCheckCheck  Check  
Two dimensional plotCheckCheck     
Summary stats Check  Check  
UpdatableCheckCheck     

Box Plots

Quantum XLMinitabQuality CompanionCrystal BallSPC XLDOE ProDFSS Master
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 ProDFSS Master
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 ProDFSS Master
MeanCheckCheck     
MedianCheckCheck     
MinimumCheckCheck     
MaximumCheckCheck     
Show range lineCheckCheck     
Connect meansCheckCheck     
Group meanCheckCheck     
Grand meanCheckCheck     
Standard deviationCheckCheck     
UpdatableCheckCheck     

Hypothesis tests

Quantum XLMinitabQuality CompanionCrystal BallSPC XLDOE ProDFSS Master
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 ProDFSS Master
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 ProDFSS Master
 Check      

DSM

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

Component swapping

Quantum XLMinitabQuality CompanionCrystal BallSPC XLDOE ProDFSS Master
 Check      

Stack Columns

Quantum XLMinitabQuality CompanionCrystal BallSPC XLDOE ProDFSS Master
 CheckCheck  Check  

Unstack columns

Quantum XLMinitabQuality CompanionCrystal BallSPC XLDOE ProDFSS Master
 CheckCheck  Check  

Random Numbers

Quantum XLMinitabQuality CompanionCrystal BallSPC XLDOE ProDFSS Master
Normal CheckCheck  Check  
Exponential Check   Check  
Uniform CheckCheck  Check  
Triangular CheckCheck     
Log-Normal CheckCheck     
Weibull CheckCheck  Check  
Gamma CheckCheck     
Logistic CheckCheck     
Log-Logistic CheckCheck     
Uniform Discrete CheckCheck  Check  
Poisson CheckCheck     
Binomial CheckCheck     
Binary CheckCheck     
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 ProDFSS Master
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  

Companion Tools

QFD

Quantum XLMinitabQuality CompanionCrystal BallSPC XLDOE ProDFSS Master
QFD WizardCheck Check    
Create PCM matrixCheck      
Edit PCM matrixCheck      
Sort PCMCheck      
Pareto PCMCheck      
Create House of Quality Check Check    
Edit HOQCheck Check    
Sort HOQCheck Check    
Sort HOQCheck Check    
Pareto HOQCheck Check    

Pugh matrix

Quantum XLMinitabQuality CompanionCrystal BallSPC XLDOE ProDFSS Master
CreateCheck Check    
EditCheck Check    
SortCheck Check    
Create chartCheck Check    

FMEA

Quantum XLMinitabQuality CompanionCrystal BallSPC XLDOE ProDFSS Master
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

Model Building

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

Speed

Quantum XLMinitabQuality CompanionCrystal BallSPC XLDOE ProDFSS Master
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   

1 Both 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".

2 Test 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 ProDFSS Master
Normal Distribution StatsCheck  Check  Check
Count out of specCheck  Check  Check
Percentile StatsCheck  Check   
Export EVA Raw DataCheck  Check   

Monte Carlo Features

Quantum XLMinitabQuality CompanionCrystal BallSPC XLDOE ProDFSS Master
N=10K to 1 Million SimulationsCheck  Check  Check
Tolerance Allocation TableCheck     Check
Sensitivity AnalysisCheck  Check  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 ProDFSS Master
Optimize single outputCheck  Additional $1,000  Check
Reduce dpm across multiple outputsCheck  Additional $1,000  Check
Optimize on Cp, Cpk Median, …Check  Additional $1,000   
Optimize with constraintsCheck  Additional $1,000   
Advanced Optimization TechnologyCheck  Additional $1,000   

Supported Distributions

Quantum XLMinitabQuality CompanionCrystal BallSPC XLDOE ProDFSS Master
NormalCheck  Check  Check
ExponentialCheck  Check  Check
Uniform ContinuousCheck  Check  Check
Triangular Check  Check   
Log-Normal Check  Check   
Logistic Check  Check   
Log-Logistic Check  Check   
Weibull (3 Parameter)Check  Check   
Uniform Discrete Check  Check   
Poisson Check  Check   
Binary Check  Check   
Binomial Check  Check   
Empirical DistributionCheck  Check  Check
Custom Continuous DistributionCheck  Check   
Custom Discrete DistributionCheck  Check   

Sampling Matrices

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

Compatibility

Quantum XLMinitabQuality CompanionCrystal BallSPC XLDOE ProDFSS Master
Windows 32 bit (Vista, 7, 8)CheckCheck CheckCheckCheckCheck
Windows 64 bit (Vista, 7,8)CheckCheck CheckCheckCheckCheck
Excel 2013 32 bitCheckNA CheckCheckCheckCheck
Excel 2013 64 bitCheckNA CheckCheckCheckCheck
Excel 2010 32 bitCheckNA CheckCheckCheckCheck
Excel 2010 64 bitCheckNA CheckCheckCheckCheck
Excel 2007 32 bitCheckNA CheckCheckCheckCheck
Excel 2003 CompatibilityCheckNA CheckCheckCheckCheck
Excel XP (2002) CompatibilityCheckNA CheckCheckCheckCheck
Excel 2000 CompatibilityCheckNA CheckCheckCheckCheck
Digitally Signed MacrosCheckNA CheckCheckCheckCheck

Note:

* Minitab version v16 used for comparison

* Quality Companion v3 used for comparison

* Quantum XL 2013 used for comparison