MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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.

Posted by Mark W. on February 13, 2002 10:11 AM

See 22348.html