Home / What's New in Version 18

What's New in Version 18¶

Three ribbon tabs are new code in v18: QXL Stat Tools, QXL DOE New and QXL Monte Carlo New. This page says what each one gained.

Anything not listed here still works and still runs the previous version's code, and its help has not been rewritten for v18. That list is at the bottom.

Statistical Tools¶

Control charts, rebuilt¶

Twenty-two chart types, each with its own set of pages. Every one is launched the same way, runs through the new engine, and writes a worksheet with a task pane you can use to change the analysis afterwards instead of starting again.

Group	Charts
Variables, in subgroups	Xbar-R and Xbar-S, I-MR-R/S, Xbar, R, S
Variables, as individuals	I-MR, Individuals, Moving Range, Levey-Jennings
Short run	Z-MR
Time weighted	EWMA, CUSUM
Multivariate, new in v18	T² and Generalized Variance, which also serves the Hotelling T² and Generalized Variance commands
Attribute	p, np, Laney P', c, u, Laney U'
Rare event	G Chart, T Chart

Also new: Marking Outliers, which marks a source cell so a chart still plots it but no longer estimates its limits from it.

Analysis tools¶

Fifteen tools, covering every command on the Analysis Tools menu. Full list on Analysis Tools.

Cpk/Histogram, which is what both Capability Analysis and Histogram open
Capability Scorecard
Pareto, Bar Chart, Pie Chart
Box Plot, Dot Plot, Scatter Plot, Run Chart, Summary Statistics
Johnson Transformation, Tolerance Interval
Confidence Interval, Correlation and Covariance, Time Series

MSA¶

Three Gage R&R studies through the new engine, plus the template that collects the data for them: Create MSA Template, Crossed, Nested and Extended.

The previous version's MSA commands are still on the menu and still run its code: Type 1 Gage Study, the ANOVA and XbarR entries, and both Attribute MSA methods.

Design of Experiments¶

A whole new tab, QXL DOE New, with forty-one commands documented. See DOE.

Twelve ways to create a design, including Create Optimal Design (D, A, I), which takes the run count as an input and so reaches sizes no classical generator produces
Run Regression, picking its engine from the output's declared type: least squares, binary logistic or nominal logistic
The DOE Advisor, a block written below every regression reporting what it noticed about the fit
Optimize, which searches the fitted model for the settings that best meet one goal subject to constraints on the others
Ten charts, from Pareto of Regression Coefficients to Trellis and Cube Plot

Monte Carlo¶

A whole new tab, QXL Monte Carlo New. See Monte Carlo.

Mark Input and Mark Output, with fourteen built-in distributions, your own custom distributions, and Create Empirical for building one from data you already have
Create Monte Carlo Design Sheet, a worksheet laid out as a model with every row already marked
Import Model from Quantum XL DOE, which turns a fitted DOE model into a Monte Carlo model
Validate Model, which reports whether the model will run in the fast engine and, if not, which formula stopped it
Run Model, with a fast engine that parses your formulas and a native mode that recalculates the worksheet, and Sobol sampling beside ordinary Monte Carlo sampling
Percent Contribution, ranking the inputs by how much of the output's variation each is responsible for
Optimize, Latitude Plot, Surface and Contour Plot and Tolerance Allocation
Sampling Matrices, Scorecard and Linear Tolerancing

Things that apply everywhere¶

Data Selection, the one window every analysis opens with
Data Types, and what Continuous, Nominal, Count, Integer and DateTime mean to the engine
Update Analysis and Modify Analysis, which now handle both a v18 sheet and a sheet built by the previous version, deciding which by reading the sheet
Starting Quantum XL with Excel: v18 is a COM add-in, so it is switched on from Excel's COM Add-ins dialog and installs no .xla file

Still the previous version's code¶

These all work and none of them has been rewritten for v18, so their help is not part of this help system: Hypothesis Tests, Distribution Fit and the Distribution Calculator, Reliability, QFD, FMEA, Pugh, Decision Trees, DSM, Problem Solving, Stack/Unstack Data, Random numbers, Data Template, the Control Chart Wizard's underlying code, Type 1 Gage Study and the legacy MSA commands.