AddStat: Microsoft Excel-tools for statical analyses

... add statistics to your data:   Use free-of-charge MS-Excel-tools to analyse your data

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.

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 for 2x2-table, with exact confidence intervals. Use predictive values only in case of cohort study. (in English)

• Passing-Bablok-Regression

• With charges, Link to Webshop: ROC curve, Comparison of ROC curve (in English)

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

• Sample size for 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)