Forum Discussion
statistics
I am taking an intro statistics course and was wondering if anyone knows how to find the frequency of numbers within a range. I've tried to look up formulas, and videos, but everyone hand counts.
Hi Monka, to find the frequency of numbers within a specific range in a dataset, you can use the COUNTIFS function in Excel.
Here's what you would do:
1. Prepare Your Data - Ensure your dataset is organised in a single column. For example, if your data is in column A, each cell from A2 onward contains a number.​
2. Determine the Range - Decide the lower and upper bounds of the range you're interested in. Let's say you want to count numbers between 10 and 20, inclusive.
Use the COUNTIFS Function: In an empty cell, enter the following formula:​
=COUNTIFS(A2:A100, ">=10", A2:A100, "<=20")
This formula counts the number of cells in the range A2:A100 that contain values between 10 and 20. Just replace A2:A100 with the actual range of your data, and adjust the numbers 10 and 20 to your desired range limits.​
This method allows you to calculate the frequency without manually counting each occurrence.
