Formulas > =NORM.S.INV()
How to Use NORM.S.INV() in Google Sheets
Description
How To Actually Use NORM.S.INV() in Sheets
NORM.S.INV(x)
Try NORM.S.INV yourself
In cells A1:A10, enter probabilities between 0 and 1. Use the NORM.S.INV formula in cell B1 to calculate the corresponding z-scores for these probabilities. Drag the formula down to fill cells B1:B10.
Hints (2)
-
Make sure your probabilities are valid (between 0 and 1).
-
Remember to drag the formula down to apply it to the other cells.
Looking for a video tutorial? Members can email me anytime! Check out the blogs below for more info on this formula. Or generate your formula. Find more formulas here at BetterSheets.co/formulas
Learn more about the NORM.S.INV() formula:
Generate a NORM.S.INV() formula for your needs
Describe your task in plain English and get a paste-ready formula that uses NORM.S.INV(). 2 free AI generations, no signup. Members get unlimited use.
Generate a NORM.S.INV() formula