Key Points NORMSINV is an Excel function used along with normal distributions. It allows you to conduct calculations faster ...

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.

In the next cell below that, enter the formula: "=B2+10" where "B2" is the cell where you entered zero and "10" is the number of units you want to show for each section of your frequency distribution.