Analysis Tools
Download Excel 2007 Workbook with Instructions
Download Excel 2003 Workbook with Instructions
Quantum XL supports a wide range of analysis tools that are updatable and support the same data sources (Excel workbook, Group By format, SQL data source, Manual data source).
Capability Analysis (Cpk)
- Create single, multiple or overlaid Cpk in Excel. Capability Analysis produces a report that includes both a graphic and numerical analysis.
- Short term and long term curves are plotted on the graph, along with out-of-spec areas, LSL, USL, and Target lines.
- Numerical analyses include computations of basic statistics (Mean, Standard deviation, …), Capability Statistics (Cp, Cpk, Pp, Ppk, Confidence Intervals), defects per million, Box-Cox transformation, and goodness of fit.
- Different methods of estimating standard deviation are also supported.
Histogram
- Create single or overlaid histograms. Supports distribution fit from 11 continuous distributions.
- Histogram produces a report that includes both a graphic and numerical analysis. Histogram bars are plotted on the graph, along with out-of-spec areas, LSL, and USL lines.
- Numerical analyses include computations of basic statistics (Mean, Standard deviation, …), Capability Statistics (Cp, Cpk, Pp, Ppk, Confidence Intervals), and defects per million.
Distribution Fit
- Distributions Fit is a process of finding the distribution that best fits the provided dataset. The results are reported in a table displaying the p-value and distribution parameters. The larger the p-value, the more likely the data fits the distribution. The table is sorted in descending order, with the best candidates at the top of the table.
Pareto
- Create a column chart where the height of each column represents frequency. Columns are usually sorted in descending order.
- Pareto report is included along with a chart. You can create single pareto, multiple paretos or a grid of pareto charts.
Box Plot
- Create a graphical representation of the distribution of a set of data (also known as a box and whisker diagram).
- Box plot chart includes a box (represents interquartile range – IQR), whiskers, outliers, suspected outliers, and dataset mean, min and max. You can customize the box height and whiskers type.
Dot Plot
- The Dot Plot graphically represents individual observations of a dataset. Each observation is represented by a circular dot. Dots that are plotted vertically represent the frequency of a data point.
- Dot Plots are suitable for small datasets, and they are useful for displaying data clusters, gaps, and outliers.
Scatter Plot
- Displays graphically the relationship between two variables. The data is displayed as a collection of points. Each point is determined by the values of two variables, one representing horizontal axis values, and the second representing vertical axis values.
- Scatter plot supports linear, logarithmic, polynomial, power and exponential regression lines (a 'best fit' line for two datasets). You can also 'Extrapolate model'. This will draw a dotted line that goes beyond the existing data.
- The report also includes regression equitation, regression statistics and expected values field. Enter the X value in the cell on the report, and Quantum XL will calculate the expected Y value. The expected data point will be displayed on the graph.
Multi-Vari
- Multi-Vari analysis graphically represents positional (within a subgroup), cyclical (between groups), and Temporal (over time) sources of process variation.
- You can choose to display the dataset minimum, maximum, range line, display the markers for the Mean and connect the Mean markers with a dash line. You can also display the group mean, grand mean, and all data points.





