NORMSINV is an Excel function used along with normal ... In the old days, you used tables of the standard normal distribution to calculate the number of standard deviations (Z) that relate to ...