## Introduction to 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, use **the COUNTIFS function**.

### 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 answer 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 with*total frequency***the SUM function.**

`=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
the**0.2666667**: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**