XLStat Tools and Analyses

XLSTAT Tools and Analyses

The following tools and analyses are contained in the base XLStat-Pro module. Other optional analyses are available in the various advanced modules.

Preparing data	Data Sampling Distribution Sampling Discretization Coding Presence/Absence coding Complete Disjunctive Coding (Creating dummy variables) Coding by Ranks Variable transformations Create contingency tables Data management Raking survey data
Describing data	Descriptive Statistics (including box plots and scattergrams) Histograms Normality tests (including q-q plots and p-p plots) Contingency Table (Two-way Table) Correlations and Similarity/Dissimilarity Matrix Multicolinearity statistics Quantiles Resampling Biserial correlation
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	Histograms Scatter plots Parallel Coordinates Visualization Ternary diagrams Univariate Plots Error bars Plot a Function Plot management (AxesZoomer, Easy labels, Reposition labels, Easypoints, Orthonormal plot, Resize a chart, Merge charts)
Modeling data and forecasting	Distribution Fitting Linear Regression ANOVA ANCOVA Logistic regression (Logit, Probit) Non-linear regression (Genfit) Nonparametric regression (kernel & lowess) Ordinal logit model Classification and regression trees Mixed models Repeated Measures ANOVA Welch and Brown-Forsythe one-way 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 samples t and z tests Two samples comparison of variances k samples comparison of variances Comparison of one proportion Comparison of two proportions Comparison of k proportions Equivalence test (TOST) Multidimensional tests Multinomial goodness of fit test
Non-parametric Tests	Non-parametric tests on two independent samples:Mann-Whitney's & Kolmogorov-Smirnov's tests Non-parametric tests on two paired samples: Wilcoxon's & sign tests Non-parametric tests on k independent samples: Kruskal-Wallis' test Non-parametric tests on k paired samples: Friedman's test Mood test (Median test) Durbin and Skillings-Mack tests Page test Cochran's Q test McNemar's test One sample runs test Cochran-Mantel-Haenszel test
Tools	Manage the menu bars (Display the main bar, Hide the sub-bars) Manage workbook (Sheets management, Delete hidden sheets, Show hidden sheets) Manage data (DataFlagger, MinMaxSearch, Remove text values in a selection) Export to GIF/JPG/PNG/TIFF

Last modified 5 April, 2013