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.

Excel's "trimmean" function calculates the mean of the interior of a data set. You can tailor the function to calculate the interquartile mean. Enter your data set into a single column in Excel.

Moreover, if we have a huge dataset in Excel, calculating the occurrences of a text is almost impossible. In this article, we will show you an easy way to count the frequency of a text in Excel.