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 )
