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

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

iamericha — Tue, 09 Apr 2024 23:29:35 GMT

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.

MRB3855 — Wed, 10 Apr 2024 01:30:39 GMT

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

txnelson — Wed, 10 Apr 2024 01:50:54 GMT

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

iamericha — Wed, 10 Apr 2024 17:09:13 GMT

Thank you!

iamericha — Wed, 10 Apr 2024 17:10:22 GMT

Thank you for the screenshot!