cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
The Discovery Summit 2025 Call for Content is open! Submit an abstract today to present at our premier analytics conference.
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!