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.

A cumulative average recalculates a data set's average as new data is added. During the recalculation all data contained in the data set is included in the average. In Microsoft Excel your ...

A straight ranking result is easy using one of Microsoft Excel’s ranking functions. Calculating a conditional rank is even easier if you let an Excel PivotTable do all the work.

With Excel and data from your broker, however, calculating the average return is fairly easy using the XIRR function. How to calculate average stock returns in Excel ...