CHISQ.INV.RT

[#1]

Does JMP have an equivalent to excel's CHISQ.INV.RT function? I need it for FIT rate (reliability) calculations. Thanks in advance!

[#2 · Accepted solution]

Use "ChiSquare Quantile" function. See following screenshot to see how the results match.

Notice, the Excel function use right-tail probability, and you need 1 minus that probability for the JSL function.

BTW, I am curious, under what situation, do you need to manually calculate this quantity?

[#3]

Thank you so much!! 

The application is for semiconductor failure rates. 
https://www.renesas.com/us/en/document/qsg/calculation-semiconductor-failure-rates

[#4]

Thanks for letting me know the application and providing the reference.