Is there a function to determine the non-exceedance probability of each value in the table?

Table = readtable("practice3.xlsx");

x = Table.values

x = 10×1

450 1100 1060 700 350 80 2310 2000 370 50

Answer 1

[the cyclist]

Using info from your near-duplicate of this question:

Table = readtable("https://www.mathworks.com/matlabcentral/answers/uploaded_files/1293540/practice3.xlsx");
x = Table.values

x = 10×1

450 1100 1060 700 350 80 2310 2000 370 50

nonExceedanceProbability = sum(x'<=x,2)/numel(x)

nonExceedanceProbability = 10×1

0.5000 0.8000 0.7000 0.6000 0.3000 0.2000 1.0000 0.9000 0.4000 0.1000

This assumes that you are trying only to do the purely empirical non-exceedance for this particular set of values. If, instead, this is a sample and you are trying to estimate something about a population, you'll need to provide the info that @Torsten mentions.

[Macy]

Thanks! Yes for now I just need empirical non-exceedance.

Answer 2

[Torsten]

You will first have to tell us the type of distribution the values are supposed to follow (e.g. log-normal distribution).

After this, you will have to determine the parameters of this distribution from your measurement data.

After this, you will be able to plot a non-exceedance probability curve.

e.g.

Table = readtable("practice3.xlsx");
x = Table.values

x = 10×1

450 1100 1060 700 350 80 2310 2000 370 50

params = mle(x,'Distribution','LogNormal')

params = 1×2

6.2041 1.2021

hold on
y = linspace(0,max(x));
plot(y,logncdf(y,params(1),params(2)))
legend('Non-Exceedance Probability')
hold off
grid on

[Macy]

Thank you, I was looking for a command that would help me find emprical non-exeedance values, but this was going to be my second question which you answered.