OASIS Mailing List ArchivesView the OASIS mailing list archive below
or browse/search using MarkMail.

# office-comment message

[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]

Subject: Re: [office-comment] ODFF: list of suggestions

• From: "David King" <openoffice@drking.plus.com>
• To: office-comment@lists.oasis-open.org
• Date: Sun, 21 Dec 2008 21:20:10 -0000

```Hi Eike

Nice to hear from you

> > PERCENTRANK
> > "as a percentage of the data set" - this phrase is surely
> > meaningless - needs a rigorous description.
>
> Could you provide one?

PERCENTRANK
Summary: Returns the percentage rank of a value in a sample.
Syntax:  PERCENTRANK( NumberSequenceList Data ; Number X [ ;
Integer Significance = 3 ] )
Returns: Number
Constraints:
o COUNT(Data) > 0
o MIN(Data) <= X <= MAX(Data)
o INT(Significance) = Significance; Significance >= 1
Semantics:
o Data		is the array or range of data with numeric
values.
o X		is the value whose rank is to be determined. (***I
removed/edited a bit here)
o Significance	is an  value that identifies the number of
significant digits for the returned percentage value. If omitted,
a value of 3 is used (0.xxx).

(***new bit)
For COUNT(Data) > 1, PERCENTRANK returns r / (COUNT(Data) -1),
where r is the rank of X in Data. The rank of the lowest number
in Data is 0, and of the next lowest number 1, and so on. If X is
not in Data, it is assigned a fractional rank proportionately
between the rank of the numbers on either side;  specifically, if
X lies between Xa and Xb (Xa < X < Xb), where Xa has rank ra, the
rank of X is calculated as ra + (X-Xa)/(Xb-Xa). In the special
case where COUNT(Data) == 1, the only valid value for X is the
single value in Data, in which case PERCENTRANK returns 1.
Despite its name, PERCENTRANK returns a fraction between 0 and 1
inclusive, rather than a percentage.

=========
Does that help? You'll need to subscript the suffixes for Xa, Xb,
ra of course

I'll look at the other stuff later

David

```

[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]