XLSTAT-Basic
XLSTAT-Basic is a data analysis system and statistical software for Microsoft Excel. By built-in add-ins, 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.
Statistical Methods in MS Excel
XLSTAT comprises the complete statistics and provides routines for dose-response curves as well as for mulitvariate statistics or PLS. Meeting specific analytical needs, a variety of optional modules can be added to the basic program.
Arguments for XLStat:
- The XLSTAT extends Excel to a powerful and easily accessible statistics tool
- More than 100 statistical methods/functions
- Modular expandable
XLSTAT-Basic - Enable High-Quality Statistical Functions in Excel
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-Basic comprises the complete statistics and provides routines for dose-response curves as well as for mulitvariate statistics or PLS.
User Interface of XLSTAT-Base
XLSTAT-Basic - Overview
XLSTAT-Basic provides a solid foundation for statistical data analysis in Microsoft Excel. The software contains a wide area of statistical core functions. It contains more than 100 essential statistical tools for deep insight in your data. XLSTAT-Basic provides also dynamic pivot tables and several regression models.
a basic data chart in Excel...
...with the help of the dialogbox...
...the chart will be converted to a pivot table
Principal Component Regression (PCR)
Ordinary Least Squares regression (OLS)
discriminant analysis (PLS)
XLSTAT grows with you - optional Modules
Software needs to fit to the users needs - not the opposite! This is why XLSTAT's functions can be extended. 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-LatentClass
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-Base
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