@article {Goedhart073999, author = {Joachim Goedhart}, title = {Calculation of a distribution free estimate of effect size and confidence intervals using VBA/Excel}, elocation-id = {073999}, year = {2016}, doi = {10.1101/073999}, publisher = {Cold Spring Harbor Laboratory}, abstract = {Reporting effect sizes aids the transparent presentation and independent interpretation of scientific data. However, calculation and reporting of effect sizes for data obtained in basic research is rare. A standardized effect size was reported by Norman Cliff, known as Cliff{\textquoteright}s delta. It has several advantageous features, as (i) it makes no assumption on the shape of the underlying distribution, (ii) it works well for small to moderate samples (n\>10), (iii) it is easy to calculate, and (iv) its basis is readily understood by non statisticians. Here, a VBA macro, implemented in Excel, is presented. The macro takes two independent samples as input and calculates Cliff{\textquoteright}s delta with 95\% confidence intervals. The macro will reduce the barrier for calculating the effect size and can be a valuable tool for research and teaching.}, URL = {https://www.biorxiv.org/content/early/2016/09/08/073999}, eprint = {https://www.biorxiv.org/content/early/2016/09/08/073999.full.pdf}, journal = {bioRxiv} }