Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Calculating Deciles in Excel
1,273 views
Skip to first unread message
Phil
Jun 24, 2000, 3:00:00 AM6/24/00
to
I want Excel to calculate decile values for a column of data. I've
used the quartile function to calculate quartiles, but I don't know
how to have Excel calculate deciles.
used the quartile function to calculate quartiles, but I don't know
how to have Excel calculate deciles.
I'll appreciate any help.
Phil
Myrna Larson
Jun 24, 2000, 3:00:00 AM6/24/00
to
On Sat, 24 Jun 2000 19:34:27 GMT, phi...@yahoo.com (Phil) wrote:
>I want Excel to calculate decile values for a column of data. I've
>used the quartile function to calculate quartiles, but I don't know
>how to have Excel calculate deciles.
Try using the PERCENTILE function and specifying 10, 20, .... 90, etc.
as the 2nd argument.
0 new messages