dear Assumers,
the spreadsheet function percentiles in XL2K uses the formula p(n-1)+1
instead of the more common p(n+1) to find the ranked value. I have been
unable to find a reference to this formula.
[other than to XL itself, like
http://www.itl.nist.gov/div898/handbook/prc/section2/prc252.htm]
any suggestions welcome
thanks in advance
Sandro Leidi
|