Percentile of a value based on array of data
67 次查看(过去 30 天)
显示 更早的评论
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 个评论
采纳的回答
David Young
2015-3-8
编辑:David Young
2015-3-8
% 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 个评论
Thomas Possidente
2021-12-1
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
更多回答(2 个)
the cyclist
2015-3-8
Sounds like you want the prctile function.
You could have found this yourself by typing
docsearch percentile
at the command prompt.
the cyclist
2015-3-8
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.
0 个评论
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Descriptive Statistics 的更多信息
产品
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!