cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
New to using JMP? Hit the ground running with the Early User Edition of Discovery Summit. Register now, free of charge.
Register for our Discovery Summit 2024 conference, Oct. 21-24, where you’ll learn, connect, and be inspired.
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!