Matlab Percentile function VS excel percentile function

2011 5 28
2 个回答
5 次查看（30 天）

0 个投票

Is the matlab percentile function is equal to excel percentile function. I'm getting two different answers for the same data set.

请先登录，再回答此问题。

回答（2 个）

Matt Fig
Matt Fig 2011-5-29

0 个投票

I don't see a PERCENTILE function in MATLAB. Is it a custom function you wrote?

4 个评论
显示 2更早的评论 隐藏 2更早的评论

vijay sabawat
vijay sabawat 2011-5-29
there is function matlab
Y = prctile(X,p)
Y = prctile(X,p,dim)
Matt Fig
Matt Fig 2011-5-29
Oh, the PRCTILE function. How different are the values you get?
vijay sabawat
vijay sabawat 2011-5-29
It depends on the sample size.. for a size of 10 the difference is about 1.5 and so. But if the sample size is large then results pretty close..
vijay sabawat
vijay sabawat 2011-5-29
A = [11 15 74 42 63 21]';
B = prctile(A,30:20:70)
xlswrite('H:\test.xlsx',A)
B =
16.8000 31.5000 56.7000
using excel
=PERCENTILE($A$1:$A$6,0.3) = 18
=PERCENTILE($A$1:$A$6,0.7) = 52.5

请先登录，再进行评论。

Oleg Komarov
Oleg Komarov 2011-5-29

0 个投票

I get the same results:
A = rand(1000,1);
B = prctile(A,30:20:70)
xlswrite('C:\Users\Oleg\Desktop\test.xlsx',A)
and then using PERCENTILE($A$1:$A$1000,0.3)
EDIT
Excel interpolates for values of the percentile that are not multiples of 1/(n-1). So the 25th percentile on 1:5 = 2! (online reference: percentile)
=PERCENTILE(A1:A5,0.25) where A1:A5 = 1:5 --> 2
Matlab interpolates for percentile values that are not (i -.5)/n, for i = 2, 1.5/5 = .3 which is not the 25th percentile.
prctile(1:5, .25) --> 1.7500 % Which makes more sense IMO
Hope this clarifies.

3 个评论
显示 1更早的评论 隐藏 1更早的评论

vijay sabawat
vijay sabawat 2011-5-29
instead of 1000 sample size reduce the size to 10 then you can see the difference..
vijay sabawat
vijay sabawat 2011-5-29
A = [11 15 74 42 63 21]';
B = prctile(A,30:20:70)
xlswrite('H:\test.xlsx',A)
B =
16.8000 31.5000 56.7000
using excel
=PERCENTILE($A$1:$A$6,0.3) = 18
=PERCENTILE($A$1:$A$6,0.7) = 52.5

请先登录，再进行评论。

类别

在 帮助中心 和 File Exchange 中查找有关 Descriptive Statistics 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by