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. It.

In Excel, syntax for this function is NORMINV(probability,mean,standard deviation). Using the sales example, with a weekly sales average of $2,000 that fluctuates about $500 up or down, you know ...