Pivot Tables and Statistical Formulae
Posted by Brendan Kenny on February 13, 2002 10:06 AM
I am looking to use pivot tables to calculate confidence interval points, but am unable to combine pivot table queries with a statistical function.
E.g the options available in a pivot table are : Sum / Count / Max / Min / Avg / StdDev / StdDevp / Var / Varp
However I want to calculate the median (50th percentile) value and 80th percentile.
Any help or guidance would be appreciated.