Percentile of a value based on array of data

Question

Maximzzz 2015-3-8

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/182131-percentile-of-a-value-based-on-array-of-data

评论： Thomas Possidente 2021-12-1

Hello!

I have an array with historical data and would like to know where an exogenous variable fits in this array using percentile.

Let's assume a vector with 1:1000 and 950 as a given, the function should return 95%.

It would be possible to create a function to do the task, but maybe matlab has a built-in function to do this ?

Thanks a lot, Max.

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

请先登录，再进行评论。

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

Answer 1

David Young 2015-3-8

2
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/182131-percentile-of-a-value-based-on-array-of-data#answer_170548

编辑：David Young 2015-3-8

在 MATLAB Online 中打开

% Test data
historicalData = rand(1000, 1);
exogenousVariable = 0.7;
% Compute centile
nless = sum(historicalData < exogenousVariable);
nequal = sum(historicalData == exogenousVariable);
centile = 100 * (nless + 0.5*nequal) / length(historicalData);

This actually computes 94.95 rather than 95 for your example, because the test value is equal to one of the data points. You can round to the nearest whole number or to any other number of significant figures using the round function.

2 个评论
显示无隐藏无

Maximzzz 2015-3-8

在 MATLAB Online 中打开

Hello, thanks for your answer! After some research on my own I came up with another solution

function x = comp_percentile(datas,value)
    perc = prctile(datas,1:100);
    [c index] = min(abs(perc'-value));
    x = index+1;
end

Thomas Possidente 2021-12-1

在 MATLAB Online 中打开

Note that the original answer by David Young is more robust than the version in OP's comment. The version in OP's comment will only give percentile answers to the nearest integer percent. Additionally, David Young's answer can be easily modified to perform the operations on multiple exogenousVariables at once like so -

function centile = comp_percentile(data,value)
    
    data = data(:)';
    value = value(:);
    
    nless = sum(data < value, 2);
    nequal = sum(data == value, 2);
    centile = 100 * (nless + 0.5.*nequal) / length(data);
    
end

请先登录，再进行评论。

Answer 2

the cyclist 2015-3-8

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/182131-percentile-of-a-value-based-on-array-of-data#answer_170533

在 MATLAB Online 中打开

Sounds like you want the prctile function.

You could have found this yourself by typing

docsearch percentile

at the command prompt.

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

Maximzzz 2015-3-8

Thank you for your answer!

If I am correct, prctile returns the value of a certain percentile (i.e. returns the value for the 42nd percentile) ? I would like juste the contrary, given a value I would like to know the closest percentile related to that value.

请先登录，再进行评论。

Answer 3

the cyclist 2015-3-8

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/182131-percentile-of-a-value-based-on-array-of-data#answer_170559

This is the inverse of the percentile function, right? There is not a built-in function for that, as far as I know. There are a few contributions in the File Exchange. (They show up if you google the keywords inverse percentile matlab .) Here is one example.