## Relative Frequency

** Relative frequency** is the ratio of a frequency within a specific range to the total number of frequencies. The percentage or dominance of a class range over the overall range can be determined using relative frequency.

The sample dataset showcases people’s weight.

To determine the frequency of each class:

### Step 1- Specify the Range of Weights

- Specify the range with an equal interval. Here, a range from
to*40*with an equal interval of*100*.*10*

**Read More: **How to Make a Categorical Frequency Table in Excel

### Step 2 – Use the COUNTIFS Function to Count the Frequency

To count the frequency for the range ** 40**–

**:**

*49*- In
, use the conditions greater than or equal to*E5*and less than or equal to*40*as the criteria argument:*49*

`=COUNTIFS($B$5:$B$19,">=40",$B$5:$B$19,"<=49")`

- As there are four cell values for the weight range between
and*40*kg, the output is*49*.*4*

- Use the same function for the other ranges. For example, in
, use the following formula:*E10*

`=COUNTIFS($B$5:$B$19,">=90",$B$5:$B$19,"<=100")`

**Read More: **How to Make a Contingency Table in Excel

### Step 3 – Use the SUM Function to Count the Total Frequency

- To count the
of the dataset, enter the following formula:*total frequency*

`=SUM(E5:E10)`

- Press
to see the result:*Enter*.*15*

**Read More: **How to Calculate Percent Frequency Distribution in Excel

### Step 4 – Use a Formula to Create a Relative Frequency Table

- Divide the frequency of each cell by the total frequency to find the
.*relative frequency* - For the cell value in
(*E5*), use the following formula.*4*

`=E5/E11`

The output is * 0.2666667: *the

**of the range**

*relative frequency***.**

*40*–*49*- Repeat the procedure for the other ranges.
- The
table will be displayed.*relative frequency*

### Step 5 – Insert a Chart with a Relative Frequency Table

- In the
tab, select a chart.*Insert* - The
color denotes the*orange*of a given range, whereas the*relative frequency*color denotes the*blue*of that specific range.*frequency*

**Download Practice Workbook**

**Related Articles**

**<< Go Back to Frequency Distribution in Excel | Excel for Statistics | Learn Excel**