General discussion

Locked

Business Objects -- Percentile

By ssuh ·
I am developing a 5th percentile and 95th percentile using Business Objects.

The pth percentile is a value such that at least p percent of the items take this value or leass and at lease (100-p) percent of the items take this value or more.

Ifsomebody knows how to calculate percentile in the Business Objects, please answer me ASAP.

This conversation is currently closed to new comments.

3 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Business Objects -- Percentile

by Wayne M. In reply to Business Objects -- Perce ...

A simple solution would be:

1) Sort your list of values from lowest to highest.
2) Count the number of values.
3) For the 5th percentile, divide the total count by 20, go to that offset in your list, and the value at that location is the 5th percentile value.

Collapse -

Business Objects -- Percentile

by ssuh In reply to Business Objects -- Perce ...

Poster rated this answer

Collapse -

Business Objects -- Percentile

by ssuh In reply to Business Objects -- Perce ...

This question was closed by the author

Back to Desktop Forum
3 total posts (Page 1 of 1)  

Related Discussions

Related Forums