topic Re: How can I calculate Inverse Cumulative Probability? in New SAS User

How can I calculate Inverse Cumulative Probability?

alexim — Wed, 23 Jan 2019 19:21:54 GMT

The math behind distribution tables is complicated. Does SAS University Edition provide the means to calculate such values without specifying all the mathematical details in a program.

For example calculate the critical value or Inverse Cumulative Probability for F distribution (for 2-Way ANOVA) given Numerator degrees of freedom = xx, Denominator degrees of freedom = xx, alpha = 0.05 (input constant = 0.95). Can you point me to a code example?

thanks,

Alexim

Re: How can I calculate Inverse Cumulative Probability?

Reeza — Wed, 23 Jan 2019 19:39:35 GMT

Check the functions under the probability section:

https://documentation.sas.com/?docsetId=lefunctionsref&docsetTarget=n01f5qrjoh9h4hn1olbdpb5pr2td.htm&docsetVersion=9.4&locale=en

@alexim wrote:

The math behind distribution tables is complicated. Does SAS University Edition provide the means to calculate such values without specifying all the mathematical details in a program.

For example calculate the critical value or Inverse Cumulative Probability for F distribution (for 2-Way ANOVA) given Numerator degrees of freedom = xx, Denominator degrees of freedom = xx, alpha = 0.05 (input constant = 0.95). Can you point me to a code example?

thanks,

Alexim

Re: How can I calculate Inverse Cumulative Probability?

alexim — Wed, 23 Jan 2019 20:45:08 GMT

Thanks, haven't found exactly what I'm looking for but you've got me headed in the right direction I believe.

Alexim

Re: How can I calculate Inverse Cumulative Probability?

alexim — Wed, 23 Jan 2019 20:54:24 GMT

The required function is QUANTILE.

data one;
x=quantile('F',0.95, 1, 4);
put x=;
run;

Alexim

Re: How can I calculate Inverse Cumulative Probability?

Reeza — Wed, 23 Jan 2019 21:00:04 GMT

You want the Quantile function then 🙂

data demo;

CriticalValueNormal = quantile('Normal', 0.025);
CriticalValueF = quantile('F', 0.025, 2, 3);

run;

proc print data=demo;
run;

https://communities.sas.com/t5/General-SAS-Programming/alpha-and-z-value/td-p/254023

Re: How can I calculate Inverse Cumulative Probability?

alexim — Wed, 23 Jan 2019 21:42:35 GMT

Yes I discovered QUANTILE just prior to your latest post, you did head me in the right direction, very much appreciate your assistance.

thanks,
Alexim