We frequently need to determine how vital and influential a specific range is. The relative frequency of a data set can be used to measure the effect of a range. In this tutorial, we will show you how to make a relative frequency table in Excel.

**Table of Contents**hide

## Introduction to Relative Frequency

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

## How to Make a Relative Frequency Table in Excel: 5 Quick Steps

Weâ€™ve included a sample data set in the image below, which includes some weight information for certain specific people. Each classâ€™s frequency must be determined. We could do it by hand, one by one, counting the frequency. However, if our data set is too vast, this is not a good idea. To count the frequency of each class, weâ€™ll utilize **the COUNTIFS function**. Later, weâ€™ll sum everything to get the overall frequency and create a ratio for each range frequency. Weâ€™ll also make a chart to show how the relative frequency compares to the discrete frequency.

### Step 1: Specify the Range for Weights

- Firstly, specify the range with an equal interval. In our example, we take 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: Apply COUNTIFS Function to Count Frequency

- We will apply
**the COUNTIFS function**to count the number of frequencies for the range ofâ€“*40*.*49* - In cell
, for the criteria argument, we will apply the conditions of greater than or equal to*E5*and less than or equal to*40*.*49*

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

- As a result, because there are four cell values for the weight range between
and*40*kg, the answer will be*49*.*4*

- Apply the same function to the other ranges as well. For example, in cell
, we will insert the following formula with*E10***the COUNTIFS function**.

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

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

### Step 3: Use SUM Function to Count Total Frequency

- To count the
of the data set, write the following formula with*total frequency***the SUM function.**

`=SUM(E5:E10)`

- Press
to see the result of total frequency (*Enter*).*15*

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

### Step 4: Insert Formula to Make Relative Frequency Table

- Now, divide each cellâ€™s frequency by the total frequency to find the
.*relative frequency* - For example, for the cell value of
(*E5*), type the following formula.*4*

`=E5/E11`

- Consequently, it will result in
as the**0.2666667**of the range*relative frequency*.*40*â€“*49*

- Repeat the procedure for the other ranges as well.
- As a result, your
table will display the one below.*relative frequency*

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

- Finally, from the
tab, select any chart with the relative frequency table.*Insert* - The
color in the chart denotes the*orange*of a given range, whereas the*relative frequency*color denotes the*blue*of that specific range.*frequency*

**Download Practice Workbook**

## Conclusion

I hope this article has given you a tutorial about how to make a relative frequency table in an Excel spreadsheet. All of these procedures should be learned and applied to your dataset. Take a look at the practice workbook and put these skills to the test. Weâ€™re motivated to keep making tutorials like this because of your valuable support.

Please contact us if you have any questions. Also, feel free to leave comments in the section below.

Stay with us and keep learning.