Knowing how to calculate relative and cumulative distribution in Excel can be useful in a variety ... The "$" anchors cell E6 so it remains constant when you copy this function to the other cells ...

Key Points NORMSINV is an Excel function used along with normal distributions. ... The standard normal distribution is a cumulative distribution with a mean of 0 and a standard deviation of 1.