Message-ID: <49AEDA8C.8020608@idi.ntnu.no>
Date: 2009-03-04T19:46:20Z
From: Wacek Kusnierczyk
Subject: Diff btw percentile and quantile
In-Reply-To: <77EB52C6DD32BA4D87471DCD70C8D700D22967@NA-PA-VBE03.na.tibco.com>
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