XLSTAT-Pro

XLSTAT-Pro is the core product of Addinsoft. It is a Microsoft Excel add-in that has been developed since 1993 to enhance the analytical capabilities of Excel. XLSTAT-Pro includes a wide range of functionalities covering most of the requirements for data analysis and statistics.

Some Excel utilities have also been included to facilitate charting and data manipulation. All tools can be accessed from the XLSTAT menu item in the Excel menu bar, or by clicking on the buttons of the XLSTAT toolbar.

Toolbars help the user to quickly access the various functionalities. Dialog boxes have been designed to be simple and intuitive. With the XLSTAT-Pro dialog boxes data selection is made easier as ever. Contextual help can be accessed from each dialog box.

All the XLSTAT-Pro functions have been abundantly tested against the best known statistical packages to guarantee that the results provided by XLSTAT are 100% reliable and compatible with what other packages would give.

Features:

Click on the method name for more details, or click on for a rial on how to use the method with XLSTAT.

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 (including Box plots and scattergrams) Tutorial 1
• Histograms Tutorial 1
• Normality tests Tutorial 1
• Contingency Table (Two-way Table)
• Correlations and Similarity/Dissimilarity Matrix
• Multicolinearity statistics
• Quantiles Tutorial 1
• Resampling Tutorial 1

Analyzing data:

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

Visualizing data:

• AxesZoomer
• Easy Labels
• Plot transformer
• Scatter plots Tutorial 1
• Parallel Coordinates Visualization Tutorial 1
• EasyPoints Tutorial 1
• Error bars Tutorial 1
• Plot a function Tutorial 1

Modeling data and forecasting:

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

Correlation and Association tests:

• Tests on contingency tables
• Correlation Tests Tutorial 1
• Mantel test Tutorial 1
• Cochran-Armitage trend test Tutorial 1

Parametric tests:

• One sample t and z tests
• Two sample t and z tests Tutorial 1
• Two sample comparison of variances
• K sample comparison of variances 2 variances using the Levene or Bartlett tests?">Tutorial 1
• Comparison of one proportion
• Comparison of two proportions
• Comparison of k proportions Tutorial 1
• Multidimensional tests Tutorial 1

Non parametric tests:

• Non parametric Tests on two independent samples
• Non parametric Tests on two paired samples
• Non parametric tests on k independent samples Tutorial 1
• Non parametric tests on k paired samples Tutorial 1
• 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