Buy Now
QuantumXl 2013

Analysis Tools

features

Download Excel 2007 Workbook with Instructions

Download Excel 2003 Workbook with Instructions

See all Examples

See all Features

 

 

 

 

 

 

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).

CpkCapability 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.

HistogramHistogram

  • 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.

ParetoPareto

  • 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 PlotBox 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 PlotDot 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 PlotScatter 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 fields. 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-VariMulti-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.

Summary StatsSummary Stats

  • Calculate summary statistics from one or multiple data sets.

Capability ScorecardCapability Scorecard

  • Capability analysis on binomial data.

 

Run ChartRun Chart

  • Simple run chart plotting data vs. time.