Formulas > =NORMSINV()
How To Use NORMSINV() Function in Google Sheets
Description
How To Actually Use NORMSINV() in Sheets
NORMSINV(x)
Try NORMSINV yourself
In cells B1:B10, input probabilities between 0 and 1. Use the NORMSINV formula in cell C1 to calculate the inverse standard normal distribution for the probability in B1. Drag the formula down to C10 to fill the range.
Hints (2)
-
Make sure the values in B1:B10 are between 0 and 1.
-
Use the NORMSINV function to find the corresponding z-scores.
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 NORMSINV() formula:
Generate a NORMSINV() formula for your needs
Describe your task in plain English and get a paste-ready formula that uses NORMSINV(). 2 free AI generations, no signup. Members get unlimited use.
Generate a NORMSINV() formula