Matlab - Sort into deciles each column

Question

V 2015-12-4

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/258931-matlab-sort-into-deciles-each-column

编辑： René Wijnen 2021-7-30

Suppose I have a matrix A [m x 1], where m is not necessarily even. I to create a matrix B also [m x 1] which tells me the decile of the elements in A (i.e. matrix B has numbers from 1 to 10).

I know I can use the function sort(A) to get the position of the elements in A and from there I can manually get deciles. Is there another way of doing it?

I think one possibility would be B = ceil(10 * tiedrank(A) / length(A) . What do you think? Are there any issues with this?

Also, more generally, if I have a matrix A [m x n] and I want to create a matrix B also [m x n], in which each column of B should have the decile of the corresponding column in A , is there a way of doing it without a for loop through the columns?

Hope the problem at hand is clear. So far I have been doing it using the sort function and then manually assigning the deciles, but it is very inefficient.

Thank you

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

jgg 2015-12-4

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/258931-matlab-sort-into-deciles-each-column#answer_202241

I think a way to do this is to use the ecdf command (<http://www.mathworks.com/help/stats/ecdf.html>)

If you take your data and do [F,X] = ecdf(A) then this will compute the empirical distribution of A.
You then just have to match the values in A to those in X which you can do using ismember like this [~,loc] = ismember(X,X2)
Finally, your quantiles of the values in A will be f(loc)
You can then sort them into deciles, or whatever you want at that point by rounding to the appropriate value.