cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
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

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

Created: Mar 22, 2021 11:13 AM  |  Last Modified: Jun 8, 2023 5:30 PM (912 views)

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!

 

 

0 Kudos
1 REPLY 1
ian_jmp
ian_jmp
Level X

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

Mar 24, 2021 07:39 AM (904 views)  |  Posted in reply to message from Anonymous 03-22-2021

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