MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Pivot Tables and Statistical Formulae


Posted by brendan Kenny on February 13, 2002 9:23 AM

I am looking to use pivot tables to calculate confidence interval points, but am unable to combine pivot table queries with a statistical query.

The currently available options 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. Normally I'd use the percentile() function.

Any help would be appreciated.


Posted by Mark W. on February 13, 2002 9:31 AM

Percentiles and Quartiles are not supported by PivotTables...

The calculation of these values is based on an
ordering of the data while none of supported
summary functions are contingent on order.

Posted by Brendan Kenny on February 14, 2002 1:13 AM

Re: Percentiles and Quartiles are not supported by PivotTables...

Thanks for the feedback, and for the information that explains why it cannot be accomplished this way.

The calculation of these values is based on an