Tools: Data Flagger, Min Max Search, Delete Invisible Sheets, Delete Hyperlinks, Numerical Codes.

Non parametric tests: Kolmogorov-Smirnov, Mann-Whitney, Wilcoxon's signed-ranks test and sign test, Non parametric Tests on k independent samples: Kruskal-Wallis' test, Non parametric Tests on k paired samples: Friedman's test.

Correlation and Association tests: Tests on Contingency Tables, Correlation tests, Mantel test, Parametric tests One sample t and z tests, Two sample t and z tests, Multiple comparisons tests, Two sample comparison of variances, k samples comparison of variances, Comparison of two proportions.

Modeling data and forecasting: Distribution Fitting, Linear Regression, ANOVA, ANCOVA, Logistic regression (Logit, Probit), Nonlinear regression, Nonparametric regression (Kernel and Lowess).

Visualizing data: Axes Zoomer, Easy Labels, Micro Mover, Plot transformer, Scatter plots, Parallel Coordinates.

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.

xlrd 1959 421 3 xlrd is a library for reading data and formatting information from Excel files, whether they are.

Works great for macros, UDFs, reporting, unit tests & REST API.

Describing data: Descriptive Statistics (including scatter grams), Histograms, Normality tests (including q-q plots and p-p plots), Contingency Table (Two-way Table), Correlations and Similarity/Dissimilarity Matrix. Automate Excel with Python on Win & macOS. The Kutools for Excel is a powerful Excel Add-in that unburdens us of time-consuming Excel tasks.

Preparing data: Data Sampling, Distribution Sampling, Discretization, Coding, Presence/Absence coding, Creating Dummy Variables, Coding by Ranks, Partition recoding, Transformation, Anamorphosis.

Excelmodules add in for mac