Ranking numbers in a table and manipulating by division.

Question

Macy 2023-2-12

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1911295-ranking-numbers-in-a-table-and-manipulating-by-division

评论： Macy 2023-2-13

practice3.xlsx

I am trying to manually calculate non-exceedance probabilities of each value x. How can I rank the values in this table from smallest to largest and then divide each value by the total number of values (in this case 10). So the highest value (2310) should have a rank of 10 and a non-exceedance probability of 1.

Table = readtable("practice3.xlsx");
x = Table.values
x = 10×1
         450
        1100
        1060
         700
         350
          80
        2310
        2000
         370
          50

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

请先登录，再进行评论。

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

Answer 1

Voss 2023-2-12

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1911295-ranking-numbers-in-a-table-and-manipulating-by-division#answer_1169940

编辑：Voss 2023-2-12

在 MATLAB Online 中打开

practice3.xlsx

Possibly this:

Table = readtable("practice3.xlsx");
[~,idx] = ismember(Table.values,sort(Table.values));
Table.ranks = idx;
Table.non_exceedance_prob = idx/size(Table,1)
Table = 10×3 table
    values    ranks    non_exceedance_prob
    ______    _____    ___________________

      450       5              0.5        
     1100       8              0.8        
     1060       7              0.7        
      700       6              0.6        
      350       3              0.3        
       80       2              0.2        
     2310      10                1        
     2000       9              0.9        
      370       4              0.4        
       50       1              0.1        