The XLSTAT add-in offers a wide variety of functions to enhance the analytical capabilities of Excel, making it the ideal tool for your everyday data analysis and statistics requirements.

XLSTAT is compatible with all Excel versions from version 97 to version 2007, and is compatitble with the Windows 9x till Windows Vista systems, as well as with the PowerPC and Intel based Mac systems.

Because it is quick, reliable, easy to install and to use - and well-priced - XLSTAT is used today by more than 25,000 customers in businesses and universities, big and small, in over 100 countries throughout the world.

XLSTAT can be purchased online on a highly secured site, anytime, anywhere. Both electronic and CD-Rom versions are available.

Data analysis and statistical solution for MS Excel

Finding answers to your business or research questions has never been easier.With XLSTAT and Excel, you can take full advantage of the latest and mostperforming methods for analyzing and modeling data. XLSTAT is a completedata analysis and statistical toolbox for Microsoft Excel. All tools and functionscan be accessed quickly and simply through a set of toolbars and menusintegrated into Excel. XLSTAT uses Microsoft Excel as an interface to input the data and to outputresults tables and charts. However, XLSTAT uses it’s own mathematical and statistical functions library to avoid the lack of stability of some of the Excelfunctions. XLSTAT has been proven to be a highly reliable software.

Preparing and describing data

XLSTAT allows you to reorganize and restructure your data for easier and moreaccurate analysis. XLSTAT histograms, descriptive statistics, box plots, andcorrelation analyses help you discover the most striking characteristics of yourdata.

Analyzing and modeling data

XLSTAT offers a series of tools that can be used by students and experts alike.XLSTAT’s user-friendly interface simplifies the use of complex data analysistechniques such as Principle Component analysis (PCA), Correspondenceanalysis, linear, nonlinear, logistic and kernel regression, and ANOVA (analysis of variance). Results are displayed in Excel sheets, making it easy to re-use thedata for additional analysis or presentations.

Testing hypotheses

XLSTAT offers a wide variety of statistical tests to allow you to test hypotheses.The results of the tests include a first level conclusion to ease your interpretation.

PREPARING DATA:

    * Data Sampling
    * Distribution Sampling
    * Discretization
    * Coding
    * Presence/Absence coding
    * Complete disjuncive tables (Creating dummy variables)
    * Coding by Ranks
    * Variables transformation
    * Create contingency tables
    * Data management

DESCRIBING DATA:

    * Descriptive Statistics (includings and scattergrams)
    * Histograms
    * Normality tests
    * Contingency Table (Two-way Table)
    * Correlations and Similarity/Dissimilarity Matrix
    * Multicolinearity statistics

ANALYZING DATA:

    * Factor Analysis
    * Principal Component Analysis (PCA)
    * Discriminant Analysis (DA)
    * Correspondence Analysis (CA)
    * Multiple Correspondence Analysis (MCA)
    * Multidimensional Scaling (MDS)
    * Agglomerative Hierarchical Clustering (AHC)
    * K-means Clustering
    * Univariate Clustering

VISUALIZING DATA:

    * AxesZoomer
    * Easy Labels
    * Plot transformer
    * Scatter plots
    * Parallel Coordinates Visualization
    * EasyPoints
    * Error bars

MODELING DATA AND FORECASTING:

    * Distribution fitting
    * Linear regression
    * ANOVA (Analysis of variance)
    * ANCOVA (Analysis of Covariance)
    * Logistic regression for binary response data and polytomous variables (Logit, Probit)
    * Nonlinear regression (Genfit)
    * Nonparametric regression (Kernel and Lowess)
    * Classification and regression trees
    * Mixed models and Repeated Measures ANOVA

CORRELATION AND ASSOCIATION TESTS:

    * Tests on contingency tables
    * Correlation Tests
    * Mantel test
    * Cochran-Armitage trend test

PARAMETRIC TESTS:

    * One sample t and z tests
    * Two sample t and z tests
    * Two sample comparison of variances
    * K sample comparison of variances
    * Comparison of one proportion
    * Comparison of two proportions
    * Comparison of k proportions
    * Multidimensional tests

NON PARAMETRIC TESTS:

    * Non parametric Tests on two independent samples
    * Non parametric Tests on two paired samples
    * Non parametric tests on k independent samples
    * Non parametric tests on k paired samples
    * Cochran's Q test
    * McNemar's test
    * One sample runs test

TOOLS:

    * DataFlagger
    * MinMaxSearch
    * Delete hidden sheets
    * Sheets management
    * Show hidden sheets
    * Export to GIF/JPG/PNG/TIFF

Visualizing data Complementary modules

• XLSTAT–ADA: for Advanced Data Analysis (RDA, CCA, GPA, MFA)
• XLSTAT-3DPlot: for visualizing data in three dimensions
• XLSTAT-Time: for time series analysis
• XLSTAT-PLS: for Partial Least Squares Regression and PCR regression
• XLSTAT-MX: for Preference mapping, GPA, penalty analysis
• XLSTAT-Life: for survival data analysis (Life tables and Kaplan-Meier analysis)
• XLSTAT-Pivot: a must have complement for XLSTAT users who need toquickly create pivot tables
• XLSTAT-Dose: for dose effects analysis
• XLSTAT-PLSPM: module for PLS path modeling, an alternative to Structural Equation Modeling (SEM)
• XLSTAT-SPC: module designed for Six Sigma applications
• XLSTAT-Sim is a module that allows you to create models in Excel and use simulation methods to estimate the distribution (including confidence intervals) of some important variables.