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.