Excel: calculate frequency - how it works
This article shows you how to calculate frequencies in Excel.
Calculate frequencies in Excel: dates and classes
First of all you have to enter the data in Excel:
- Enter all prices in a column, this is your data.
- In a second column you enter the classes, eg price categories.
- Now mark the cells in which the evaluation should take place. In our example, four classes are given (see picture). Select five cells because an additional class is required for all cases outside of the classes.
- Then click on the function bar at the top and enter the following command: "= FREQUENCY (D5: D11; E5: E8)" (without quotation marks).
- Now press the [Ctrl] + [Shift] + [Enter] keys to display the frequencies.
- The example given here and the evaluation should be understood as follows: The prices of three products were less than 10 euros. None of the products were in the 20 euro category. 2 products each cost up to 50 and 100 euros. No product was more expensive than 100 euros.
In the next practical tip, read how to create a histogram in Excel.