# How to Find Frequency in Google Sheets (2 Easy Methods)

Frequency is a metric that gives us the idea of how frequently a particular data appears within a dataset. Calculating frequency is often necessary for analyzing data and taking data-driven decisions. Google Sheets has a couple of well-designed functions to find frequency. In this article, we are going to discuss how to find frequency distribution in Google Sheets of specified classes.

## 2 Easy Methods to Find Frequency in Google Sheets

There may have various methods of finding frequency in Google Sheets. However, we are going to investigate the two easiest methods to find frequency using the following dataset. ### 1. Using FREQUENCY Function

Generally, the FREQUENCY function is the most popular function for finding frequency in Google Sheets. Using this method we can easily find the frequency of a class by defining the upper limit of the class interval.

📌 Steps:

• First of all, we manually input the Class Upper Limit to find the frequency of Age for each class within this limit.
`=FREQUENCY(D5:D14,E5:E10)` • Then we select cell F5 and put the above formula in the formula bar and hit Enter. • As a result, we get the frequency of all the classes as follows. ### 2. Applying COUNTIF Function

The COUNTIF function in combination with the UNIQUE function can perform the above task of finding frequency. In this method, we are going to find the frequency of each department of the Department column within the dataset.

📌 Steps:

• Initially, we select cell E5 to find the Class or unique departments in the Department column.
`=ARRAYFORMULA(UNIQUE(C5:C14))` • Consequently, we get the unique departments as follows in the Class column. `=COUNTIF(\$C\$5:\$C\$14,E5)`
• Afterward, we select cell F5 to write down the above formula in the formula bar and press Enter. • As a result, we get the frequency of the first row. Then we use the fill handle tool to get the frequency of subsequent rows. • Once we perform the fill handle operation we get the frequency of each department as follows. Read More: How to Use Find and Replace in Column in Google Sheets

## How to Calculate Cumulative Frequency in Google Sheets

Now, if we want to find the cumulative frequency we can easily calculate that in Google Sheets. Here, we calculate the cumulative frequency of the frequencies we got from the first method.

📌 Steps:

• Firstly we select cell E5 to find the cumulative frequency of the first class and set its value as D5 in the formula bar.
`=D5`

####  • Then we select cell E6 and again write down the below formula in the formula bar.
`=D6+E5`

####  • Now, we perform the fill handle operation to get the cumulative frequency for other rows. • Completion of the fill handle operation gives us the following output. ## How to Calculate Relative Frequency in Google Sheets

We can even calculate the relative frequency in Google Sheets just by following a few easy steps. Now, we are going to calculate the relative frequency of the frequencies we got in the second method of this article.

📌 Steps:

• At the very beginning, we select cell D12 to get the summation of the frequencies.
`=SUM(D5:D11)`
• Then, we write down the above formula in the formula bar. • This gives us the summation of frequencies in the selected cell. `=(D5/\$D\$12)`
• After finding the summation of frequencies we select cell E5 and write down the above formula in the formula bar to calculate the relative frequency. • As a result, we get the relative frequency of the first row in fractions. • Afterward, we use the Format as per cent icon as indicated to get the relative frequencies in percentage. • At last, we use the fill handle tool to get the relative frequencies in percentage for the other rows. • Finally, we get the relative frequency in percentage for each class as follows. ## Things to Remember

• Be careful in setting the upper limit of the classes when using the FREQUENCY function.
• Always extract the unique classes before finding frequency using the COUNTIF function.

## Conclusion

In conclusion, I believe from now on you can easily apply the methods we discuss of how to find the frequency in Google Sheets. Furthermore, If you have any questions or suggestions regarding this article feel free to comment below and I will try to reach out to you soon. Visit our website OfficeWheel for the most useful articles.

## Related Articles #### Laku

Hey, I'm Zahidul Islam Laku. I completed my graduation from Bangladesh University of Science and Technology (BUET). I write articles about a variety of tech topics. I enjoy using my abilities as a creative thinker and problem-solver to develop original solutions to issues.

We will be happy to hear your thoughts 