You are at: Software - Download

Software-Tools (statistical tests, sample size):
Download of free-of-charge MS Excel tools

For statistical consulting and seminars, I have programmed few tools in MS Excel. You can download them here free of charge. They should work with all MS Excel-Versions. The files contain a short description of methodology, and an example.

Please notice: I try to program the tools to deliver valid results. They were checked to be free of viruses etc. However, I cannot guarantee validity and free-of-virus status. There is no liability in terms of validity of results and free-of-virus state of the tools.

Unfortunalely, most of tools are described etc. in German. I try to translate the tools step by step. If you need an English version, please send me an E-mail. I will use your request to setup an English version :-)

• Excel-Tool Sensitivity, specificity, predictive values, (NEW:) diagnostic likelihood ratios (DLR+, DLR-) for 2x2-table, with exact confidence intervals. Use predictive values only in case of cohort study. The tool calculates confidence intervals for predictive values in dependence whether study is case control study or not.(in English)

• Passing-Bablok-Regression

• Chi-Quadrat-Test (2x2-table) (in German)

• Correlation (Pearson): R, R2, significance (in German)

• Exact Test of FISHER (2x2 table, one-sided) (in German)

• exact confidence interval for a probabilty (ratio) (in German)

• reliability, agreement (kappa), consistency (McNemar-Test) for paired data with binary outcome (2x2 table) (in English)

• sample size for McNemar-Test (in German)

• sample size for t-test (in German)

• equivalence test for comparison of two means (in German)