Knowing how to calculate relative and cumulative distribution in Excel can be useful in a variety of circumstances. It can be used in market analysis to sort a sample of people into age groups.

NORMSINV is an Excel function that provides a Z value for a cumulative probability using a standard normal distribution. If you assume your data is normally distributed and are interested in ...