XLStat Tools and Analyses

Preparing data	Data Sampling Distribution Sampling Discretization Coding Presence/Absence coding Full Disjunctive Coding Coding by Ranks Partition recoding Transformation Anamorphosis
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
Analyzing data	Factor Analysis Principal Component Analysis (PCA) Gabriel Biplot 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 Data Flagger Easy Labels MicroMover Plot transformer Scatter plots Parallel Coordinates
Modeling data and forecasting	Distribution Fitting Linear Regression ANOVA ANCOVA Logistic regression (Logit, Probit) Non-linear regression (Genfit) Kernel regression Classification and regression trees
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
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 Cochran's Q test McNemar's test
Tools	DataFlagger MinMax Search Delete Invisible Sheets Delete Hyperlinks Categories -> Numerical Codes Numerical Codes -> Categories

Last modified 25 January, 2008