Diff btw percentile and quantile
William Dunlap wrote:
<snip>
I entered the same x into Excel 2003 and used the formulae =percentile(A1:10,0), =percentile(A1:A10,.125), ..., =percentile(A1:A10,1) and got the results 1, 1.125, 2.25, 3, 4, 6.875, 8, 8.875, 10 This matches only R's type 7, the default.
hurray! in this respect, excel is as good as r ;) vQ