To calculate Percentile for a set of observations Excel has percentile()
function. R function quantile() does the same thing. Is there any
significant difference btw percentile and quantile?
Regrads,
--
View this message in context:
megh megh74 at yahoo.com writes:
To calculate Percentile for a set of observations Excel has percentile()
function. R function quantile() does the same thing. Is there any
significant difference btw percentile and quantile?
If you check the documentation of quantile, you will note that
Yes, I aware of those definitions. However I wanted to know the difference
btw the words Percentile and quantile, if any. Secondly your link
navigates to some non-english site, which I could not understand.
Dieter Menne wrote:
megh megh74 at yahoo.com writes:
To calculate
On 04-Mar-09 16:10:29, megh wrote:
Yes, I aware of those definitions. However I wanted to know the
difference btw the words Percentile and quantile, if any.
Secondly your link navigates to some non-english site, which I could
not understand.
Percentile and quantile are in effect the same
(Ted Harding) wrote:
snip
So, with reference to your original question
Excel has percentile() function. R function quantile() does the
same thing. Is there any significant difference btw percentile
and quantile?
the answer is that they in effect give the same results, though
differ
On 04-Mar-09 16:56:14, Wacek Kusnierczyk wrote:
(Ted Harding) wrote:
snip
So, with reference to your original question
Excel has percentile() function. R function quantile() does the
same thing. Is there any significant difference btw percentile
and quantile?
the answer is that they in
Excel 2003's help for percentile just says it interpolates
between the quantiles in the data:
Array is the array or range of data that defines relative standing.
K is the percentile value in the range 0..1, inclusive.
If array is empty or contains more than 8,191 data points,
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
8 matches
Mail list logo