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
Tutorial1
Tutorial2
Tutorial3
Tutorial4
- 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)
Tutorial1
- Histograms
Tutorial1
- Normality tests
Tutorial1
- Contingency Table (Two-way Table)
- Correlations and Similarity/Dissimilarity Matrix
- Multicolinearity statistics
ANALYZING DATA:
- Factor Analysis
Tutorial1
- Principal Component Analysis (PCA)
Tutorial1
- Discriminant Analysis (DA)
Tutorial1
- Correspondence Analysis (CA)
Tutorial1
- Multiple Correspondence Analysis (MCA)
Tutorial1
- Multidimensional Scaling (MDS)
Tutorial1
- Agglomerative Hierarchical Clustering (AHC)
Tutorial1
- K-means Clustering
Tutorial1
- Univariate Clustering
VISUALIZING DATA:
- AxesZoomer
- Easy Labels
- Plot transformer
- Scatter plots
Tutorial1
- Parallel Coordinates Visualization
Tutorial1
- EasyPoints
Tutorial1
- Error bars
Tutorial1
MODELING DATA AND FORECASTING:
- Distribution fitting
Tutorial1
- Linear regression
Tutorial1
Tutorial2
- ANOVA (Analysis of variance)
Tutorial1
Tutorial2
- ANCOVA (Analysis of Covariance)
Tutorial1
- Logistic regression for binary response data and polytomous variables (Logit, Probit)
Tutorial1
Tutorial2
- Nonlinear regression (Genfit)
Tutorial1
Tutorial2
- Nonparametric regression (Kernel and Lowess)
Tutorial1
- Classification and regression trees
Tutorial1
CORRELATION AND ASSOCIATION TESTS:
- Tests on contingency tables
- Correlation Tests
Tutorial1
- Mantel test
Tutorial1
- Cochran-Armitage trend test
Tutorial1
PARAMETRIC TESTS:
- One sample t and z tests
- Two sample t and z tests
- Two sample comparison of variances
- K sample comparison of variances
Tutorial1
- Comparison of one proportion
- Comparison of two proportions
- Comparison of k proportions
Tutorial1
- Multidimensional tests
Tutorial1
NON PARAMETRIC TESTS:
- Non parametric Tests on two independent samples
- Non parametric Tests on two paired samples
- Non parametric tests on k independent samples
Tutorial1
- Non parametric tests on k paired samples
Tutorial1
- Cochran's Q test
- McNemar's test
- One sample runs test