Excel's "trimmean" function calculates the mean of the interior of a data set. You can tailor the function to calculate the interquartile mean. How to Make a Frequency Table on Microsoft Excel.

You can use the Frequency function within Excel in Microsoft Office 2011 for the Macintosh platform to calculate the frequency of data that lies within a certain range. From that calculation you ...

You can use Microsoft Excel to calculate a bond's modified duration given these parameters: settlement date, maturity date, coupon rate, yield to maturity, and frequency. What Modified Duration ...