topic JMP / JSL equivalent excel's NORM.S.INV in Discussions

JMP / JSL equivalent excel's NORM.S.INV

Anonymous — Fri, 09 Jun 2023 00:30:56 GMT

What is the JMP / JSL equivalent Excel's NORM.S.INV function.

It takes a p value and returns Z value

for example at .5, it returns 0

as .84 returns ~1

Thanks!

ian_jmp — Wed, 24 Mar 2021 11:39:58 GMT

Try 'Normal Quantile()'. And do 'Help > Scripting Index' and search for 'Normal' to see this and related functions.