XLSTAT - Quality
If you are looking for a substantial six sigma toolkit to analyze your data directly in Excel, XLSTAT-Quality is just what you need. Optimize a process, detect failures, compare operators, simulate costs on a production line, design experiments to explore new possibilities.
XLSTAT-Base is included in this solution!
XLSTAT-Quality
XLSTAT is a data analysis system and statistical software for Microsoft Excel. XLSTAT extends Excel to an efficient and easily accessible statistics tool that covers most of the functions needed for the analysis and modeling of data. The software automatically integrates itself into your MS Excel user interface and is always addressable from there. In more than 100 countries, beyond 25.000 engineers, statisticians, consultants and scientists are already using XLSTAT and confirm the quality of the safe, efficient, easy-to-use and at the same time most reasonably priced software.
XLSTAT make use of Excel's functionality in respect to data collection and presentation of results. However, all calculations are carried out in autonomous programs. The disposal of Excel as an interface makes the product very easy to use and effective. The quality of the calculations themselves is equivalent to that of the leading scientific packages. XLSTAT comprises the complete statistics and provides routines for dose-response curves as well as for mulitvariate statistics or PLS.
User Inteface of XLSTAT-Quality
XLSTAT-Quality - Overview
XLSTAT's Productline was completely overhauled! More information in our News-Section, click here.
The solution XLSTAT-Quality helps you creating structured experimental designs and provides high-quality functions for statistical process control (SPC). The software contains all common designs of expirements for factor analysis, like Plackett-Burman, plans for optimicing and analysing surfaces and factor plans. Furthermore the software provides you with essentiel six sigma tools, control charts and Measurement System Analysis (MSA). If you are looking for a substantial six sigma toolkit to analyze your data directly in Excel, XLSTAT-Quality is just what you need!
X-Bar chart
Dialog box for SPC functions
Output options in the dialog box
Spider Plot
Tornado Plot
Drop down menu for simulations in XLSTAT
User's of prior versions of XLSTAT will find the following old modules in XLSTAT-Quality:
- XLSTAT-Pro
Software for statistical functions and data analysis in MS excel. - XLSTAT-Pivot: a must have complement for XLSTAT users who need to quickly create pivot tables while discovering important trends and factors impacting their business.
- XLSTAT-PLS: for Partial Least Squares Regression and PCR regression.
- XLSTAT-Sim: for Monte Carlo simulations and risk analysis.
- XLSTAT-SPC: for statistical Process Control and Six Sigma.
- XLSTAT-DoE: for designs of experiments
XLSTAT grows with you - optional Modules
Software needs to fit to the user - not backwards! This is why XLSTAT's functions can be extended by optional modules. These modules are for very specific applications. The optional modules of XLSTAT can be bought seperately and are not contained in any of the solutions! The optional modules will fit into your excel interface as usual and can be addressed from there anytime. Let XLSTAT adapt to your requirements!
Optional Modules
XLSTAT-3DPlot
XLSTAT-LG
Further Information
Systemrequirements for the software XLSTAT
| Windows® | Mac | |
| Further Requirements | Microsoft Excel 2003, 2007, 2010, 2013, 2016 | Microsoft Excel 2011 |
| Operating System | Windows XP, Vista, 7, 8, 10 (32-/64-Bit) | OS X |
| Minimum CPU | 800 MHz | 800 MHz |
| Min. RAM | 128 MB | 128 MB |
| Disk Space | 150 MB | 150 MB |
Features in XLSTAT-Quality
- Subgroup charts
Use this tool to monitor production quality if you come with a group of measurements for each measurement point in the form of continuous variables. In particular they may monitor the mean and variability of the measured production quality. - X-cross
- R
- S
- S'²
- Attribute charts
Use this tool to monitor production quality if you have a measurement for each measurement point in the form of categorical variables or their sums. You can monitor the particular categorical variables of the production quality of the process. - P Chart
- NP Chart
- C Chart
- U-Chart
- Individual charts
Use this tool to monitor production quality if you have a measurement for each measurement point in the form of continuous variables. In particular they may monitor the moving average or median and its variability. - X-Individual
- MR Moving area
- Individual charts
Use this tool to monitor production quality if you each have a measurement for each measurement point in the form of continuous variables. In particular they may monitor the moving average or median and its variability. - CUSUM or CUSUM individual
- UWMA or individual UWMA
- EWMA or EWMA individual
- Pareto charts
- Gage Repeatability and Reproducibility
- Gage Repeatability and Reproducibility for Attributes
Experimental designs
- Factor Effect Plans
- Effect surfaces Plans
- Mixture experimental designs
The following features are part of XLSTAT-Base (which is included in XLSTAT-Quality):
Analyzes
- Factor analysis
- Principal component analysis (PCA)
- Discriminant
- Correspondence Analysis
- Multiple Korrespondenzanalysev
- Multidimensional scaling (MDS)
- k-means clustering
- Agglomerative hierarchical clustering
- Gaussian Mixture Model
- Univariate partitioning
- Association Rules
Using association rules can directional relations between one or more objects of a set and another set of objects are determined in a large data set.
Modeling
- Probability Distributions
- Beta
- Binomial
- Negative Binomial
- Chi-square
- Exponentially
- Fisher
- Fisher-Tippett
- Gamma
- GEV
- Gumbel
- Lognormal
- Normal
- Pareto
- Poisson
- Student
- Uniforme
- Weibull distribution
- Linear regression
- Analysis of variance (ANOVA)
- Welch and Brown-Forsythe one-way ANOVA
- Covariance (ANCOVA)
- Repeated Measures Analysis of Variance (ANOVA)
- Mixed models and Repeated Measures ANOVA
- Binary and Multinomial Logistic Regression (Lobit, Probit, ...)
- Ordinal logit model
- Log-linear regression (Poisson regression)
- Quantile
- Cupic spline
- Kernel regression
- Nonlinear regression (GENFIT)
- Two-Stage Least Squares Regression
- Classification and regression trees
- K Neares Neighbors (KNN)
Tests
Correlation and Association tests
- Correlation test
- Test on contingency tables
- RV Coefficient
- Cochran-Armitage trend test
- Mantel test
Parametric tests
- Comparison of k proportions
- Comparison of one proportion
- Comparison of two proportions
- Equivalence test (TOST)
- One-sample variance test
- Comparison of variances of two samples
- Comparison of variances k samples
- Multidimensional tests
- Multinomieller fit test
- t and z tests for one sample
- t and z for two samples
Nonparametric tests
- Comparison of two independent samples (Kolmogorov-Smirnov, Mann-Whitney)
- Comparison of two paired samples (Wilcoxon sign test, sign test)
- Comparison of k independent samples (Kruskal-Wallis test)
- Comparison of k related samples (Friedman test)
- Mood test (median test)
- Durbin-Skilling-Mack test
- Page Test
- Cochran's Q test
- McNemar's test
- Cochran-Mantel-Haenszel test
- Running tests on a sample
Outlier Tests
- Grubbs test for outliers
- Dixon test for outliers
- Cochran C test for variances ourlying
- Mandel's h and l statistics for outliers
Tools
- Export as GIF, JPG, PNG, TIF
- Data Flagger
- MinMax Search
- Distance of text values in a selection
- Configuring the menu bar (hide, show, etc.)
- Configuring Workbooks