XLStat

XLStat: Great add-on to enhance your Excel experience.

If you ever want to enhance your Microsoft Excel experience, XLStat is a great add-on that you should really use. It adds advanced statistical analysis tools and a lot of diagrams and plot generators. The add-on pack is very easy to install, even by the most novice users.

When you install XLStat, it creates an extra bar in Microsoft Excel, which enables all the powerful features (e.g. you can prepare data via data or distribution sampling, variables transformation, data management, and coding).

You can also describe the data with a lot of histograms, quantiles estimation, normality tests, biserial correlation, and resampled statistics. You can visualize data, through univariate and function plots, label repositioning, chart mergers, 2D plots for contingency tables and error bars.

The add-on has more features which allow you to analyze information (e.g. factor or discriminant analysis, k-means clustering) and you can model it with distribution fitting, linear regression, mixed models, and logistic regression. Even though you have all those features at your fingertips, you can also use models and rules of XLStat for machine learning.

You can run correlation/association, parametric and nonparametric tests (e.g. Mantel, Cochran-Armitage, K proportions, McNemar), as well as use various tools (e.g. DataFlagger, sheet management, export to graphics) and utilities regarding CJT, Time, SIM, SPC, DOE, Life, ADA, PLS PM, and Dose.

The add-on does not use a lot of CPU and RAM, so it doesn't make your computer run slower.