cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Try the Materials Informatics Toolkit, which is designed to easily handle SMILES data. This and other helpful add-ins are available in the JMP® Marketplace
Choose Language Hide Translation Bar
iamericha
Level II

Is there an equivalent function to excel's BETA.INV() in JSL?

I'm trying to calculate confidence intervals with the following formula that I use in Excel:

 

=BETA.INV(alpha/2, x, y -x +1)

 

I can't seem to find an equivalent function in the scripting index so am not sure if one exists. Any help is appreciated.

1 ACCEPTED SOLUTION

Accepted Solutions
MRB3855
Super User

Re: Is there an equivalent function to excel's BETA.INV() in JSL?

4 REPLIES 4
MRB3855
Super User

Re: Is there an equivalent function to excel's BETA.INV() in JSL?

Hi @iamericha   The Beta Quantile function is what you are looking for.

https://www.jmp.com/support/help/en/17.0/#page/jmp/probability-functions-2.shtml#ww2695691

 

txnelson
Super User

Re: Is there an equivalent function to excel's BETA.INV() in JSL?

In addition to @MRB3855 response, I will point you to the Scripting Index

     Help=>Scripting Index=<Beta Quantile

It will give you the definition along with an example 

txnelson_0-1712713839135.png

 

Jim
iamericha
Level II

Re: Is there an equivalent function to excel's BETA.INV() in JSL?

Thank you for the screenshot!

iamericha
Level II

Re: Is there an equivalent function to excel's BETA.INV() in JSL?

Thank you!