热度 27||
All: I would recommend that from now on you do not use
the PERCENTILE function in Excel because it does not follow the
traditional statistical definition. Microsoft has corrected this
deficiency by including two new functions in Excel 2010: PERCENTILE.EXC
and PERCENTILE.INC. PERCENTILE.INC is identical to the PERCENTILE
function, which leads me to believe that the PERCENTILE function is on
the way out and is presently included as a legacy function.
PERCENTILE.EXC more accurately determines the kth
percentile and agrees with percentiles calculated with other statistical packages (e.g., SYSTAT, SAS, MINITAB, ANAYZE-IT, etc).
GMT+8, 2024-11-22 17:29 , Processed in 0.028203 second(s), 19 queries , Gzip On.
Powered by Discuz! X3.2
© 2001-2013 Comsenz Inc.