A collection of statistical tests written using pure Excel functions
This collection of pure Excel functions aims at students and practitioners who want to use basic statistical tests in excel.
This project aims at a macro-free set of basic functions using only Excel core features without python, extensions or VBA macros. This allows this template to be used in security sensitive environments.
- Download a release version of
empxl.xltx - Create a fresh worksheet from the empxl-template
empxl.xltx - Import your data
- Use the functions
- Matrix and vector convinience functions
- LAMBDA-safe group functions
- Cleanup and datawrangling functions
- Descriptive statistics
- Basic inference statistics for data vectors (t-Test, F-Test, ANOVA, etc.)
- Ordinal scale statistics (Wilcoxon-Test, Kruskal-Wallis-Test, Dunn-Test)
- p-Value Adjustment Function for grouped measures (used in pairwise tests)
Building manually requires the EXCEL Advanced Formula Environment (AFE) installed with the Excel Instance that is used to to build the template. When using the template, AFE is not required.
Important: Currently, the code builds on the German Naming of Excel formula. Therefore, Building the template manually requires Excel's German edition. This will change in one of the upcomin editions.
Important: It is not recommended, to use the formula in the src folder directly. Because these formula are indented, the extra whitespace cause Excel to misbehave.
- Run the
bin/compile.shscript to strip extra whitespaces from the source formulas. This creates acompile-folder with clean versions of the formula. - Open a fresh Excel workbook.
- Save the workbook as an Excel template (
.xlst) - Open AFE
- Open the Modules-Tab
- Paste the content of
empxl.afeinto the Workbook-Module. - Save the template for release.