Skip to content
Skip to main content

About this free course

Download this course

Share this free course

Data analysis: visualisations in Excel
Data analysis: visualisations in Excel

Start this free course now. Just create an account and sign in. Enrol and complete the course for a free statement of participation or digital badge if available.

2.4 Frequency density

Frequency density is defined as the frequency per unit of the data in each class. Frequency density is calculated by dividing the frequency by the class width (the class width is the difference between the upper limit of the class interval and the lower limit of the class interval). Frequency density allows for a meaningful comparison of different classes where the class width may not be equal.

Frequency density equals frequency over class width

The frequency density gives the ratio of the frequency of a class to its width. Frequency density is used to plot a frequency density histogram; here, you plot frequency density instead of frequency on the y-axis. Frequency density gives you the total area of bars and tells you about the frequency in the histogram (rather than the height).

You can calculate frequency density when you have a set of grouped data that consists of unequal widths of class intervals. For example, see the following Excel worksheet in Figure 22, which shows information about the ages of a group of people playing football.

A histogram in Excel
Figure 22 Information about the age of people playing football in an Excel file

To calculate the frequency densities:

  • In Column C, find the class width of the class intervals by finding the difference of upper and lower bounds/limits. (For example, 10 minus zero equals 10 comma 15 minus 10 equals five, and so on.)
Excel spreadsheet
Figure 23 Calculating the class width
  • Then, in Column D, divide the frequency of each class interval by its width.
Excel spreadsheet
Figure 24 Calculating the frequency density

In the activity below, you will test your knowledge of the difference between a frequency density histogram and a frequency histogram.

Activity 7 The difference between frequency histograms and frequency density histograms

Timing: Allow approximately 15 minutes to complete this activity

Watch the video below and note down in the box the difference between frequency histograms and frequency density histograms.

Download this video clip.Video player: Video 3
Copy this transcript to the clipboard
Print this transcript
Show transcript | Hide transcript
Video 3
Interactive feature not available in single page view (see it in standard view).
To use this interactive functionality a free OU account is required. Sign in or register.
Interactive feature not available in single page view (see it in standard view).