The new release of the Real Statistics Resource Pack, Release 2.17, is now available for free download for Excel 2013, 2010, 2007, 2003 and 2002.
Most of the updates to the website have been made. The rest will occur shortly.
Unfortunately, the changes to the MAD function fixing a bug when some cells contain non-numeric data were inadvertently omitted. This fix will be made in the next bug fix release.
The following new functions are part of Release 2.17, but were not included in the release announcement:
NORM1_POWER(d, n, tails, α) = the power of a one sample normal test when d = Cohen’s effect size, n = the sample size, tails = # of tails: 1 or 2 (default) and α = alpha (default .05).
NORM1_SIZE(d, 1-β, tails, α) = the sample size required to detect an effect of size of d with power 1-β (default .80) when tails = # of tails: 1 or 2 (default) and α = alpha (default .05).
NORM2_POWER(m, s1, s2, n1, n2, tails, α) = the power of a two sample normal test when m = difference between population means, n1 and n2 are the sample sizes, s1 and s2 are the corresponding population standard deviations, tails = # of tails: 1 or 2 (default) and α = alpha (default .05).
NORM2_SIZE(m, s1, s2, 1-β, tails, α, nratio) = the sample size required to detect a difference between population means of size of m with power 1-β (default .80) where s1 and s2 are the two population standard deviations, nratio is as described below (default = 1), tails = # of tails: 1 or 2 (default) and α = alpha (default .05).
Charles