In this tutorial you will learn How to Calculate Frequencies in Google Sheets

To calculate the frequencies in Google Sheets you can use the ** FREQUENCY() **function .

Following is the Syntax to use the FREQUENCY function in Google Sheets.

### Syntax

FREQUENCY(data, classes)

Here :

**data means :**The array or range of values that will be counted.**Classes means**: The array or range that contains the collection of classes.

Let’s go through an example to calcualte frequencies in Google Sheets

**How to Calculate Frequencies in Google Sheets : Step by Step Guide**

Here are the steps **to Calculate Frequencies in Google Sheets**

**Step 1** : Open Google Sheets

**Step 2** : Prepare your dataset

In this example we will use the below dataset

As the first parameter in the formula is fullfiled .Now we need to define the second parameter which is classes in another column to calculate the frequency.We can use the below formula to define the classes in Column B.

Click on cell B2 and type or copy below formula(adjust formula as per your data range)

Press enter and you will get a result similar to below screenshot.

**Step 3 : Calculate Frequency**

Now we can calculate the frequency using the below formula in cell C2 for our data and classes dataset .

=FREQUENCY(A2:A12, B2:B7)

Select cell C2 and type or copy the above formula in the fx function area at the top and press enter .

It will calculate frequencies as shown below.

From the above result we can interpret that number 16 appears three times in the dataset ,number 20 appears three times,number 22 appears once ,number 25 appears once,number 35 appears once and number 40 appears twice.

**How to Relative Frequencies in Google Sheets**

You can use the below formula to calculate the relative frequencies after calculating the frequencies of a dataset .

=C2/COUNT($A$2:$A$12)

The above formula will calculate the relative frequency for the value 16.

**Step 1** : Select Cell C2 and type the formula

**Step 2 **: Press enter to the get the result on Column D

Tick the Suggested auto-fill to apply the formula on rest of the cells in the column.

**How to visualize relative frequencies in Google Sheets**

Here are the steps to visualize relative frequencies in Google Sheets :

In order to visualize the relative frequencies we will create a histogram Chart for our dataset.

**Step 1** : Select the array of relative frequencies in Column D

**Step 2 **: Now Click on** Insert->Chart**

- Click on the
**Insert**menu on the main menu bar. - Now from the drop-down Select
**Chart**

**Step 3** : Change the default Chart

- Once you click on Insert->Chart Google Sheet will automatically generate a Column Chart.
- Click on the down arrow infront of Column Chart under Chart type section .
- Now scroll down and Select Histogram Chart

Now Google Sheet will generate a Histogram Chart

**Step 4** : Add labels to the Histogram Chart.

You can easily add labels to the histogram chart Click on the Customise tab and type a title text **Relative frequency**

You will now have a visual chart for relative frequencies which will help you to determine how often a value appears in the dataset .

**How to Calculate Frequencies in Google Sheets(Conclusion)**

In the above tutorial we have walked you through an example to calculate frequencies in Google sheets using frequency funtion along with relative frequency calculation .

We hope this tutorial on **How to Calculate Frequencies in Google Sheets** was helpful.

Related articles :

How to Insert Spin Button in Google Sheets ( Easy Guide )

How to Freeze Rows in Google Sheets

How to Calculate Square Root and Cube Root in Google Sheets(Quick & Easy Guide)

How to use SUMSQ Function in Google Sheets(Quick & Easy Guide )