COUNTIF() family of functions is amongst the most frequency used family of functions in Excel.
Grouping of numbers can be done for creating a frequency distribution table in a Pivot Table.
In business, several tools are used to analyze data. One of such tools is the histogram. The histogram is a chart, which has chart columns that signify how frequent a variable is present.