Formulas > =NORM.S.DIST()
How to Use NORM.S.DIST() in Google Sheets
Description
How To Actually Use NORM.S.DIST() in Sheets
NORM.S.DIST(x)
Try NORM.S.DIST yourself
In cell B1, use the NORM.S.DIST formula to calculate the standard normal distribution for the value in cell A1. The correct answer should return the probability that a standard normal random variable is less than or equal to the value in A1.
Hints (2)
-
Remember to reference the cell containing the value you want to evaluate.
-
The second argument of the function indicates whether you want the cumulative distribution.
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.DIST() formula:
Generate a NORM.S.DIST() formula for your needs
Describe your task in plain English and get a paste-ready formula that uses NORM.S.DIST(). 2 free AI generations, no signup. Members get unlimited use.
Generate a NORM.S.DIST() formula