Forum Discussion

Monka's avatar
Monka
Copper Contributor
Feb 17, 2025

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.
accessibility
community
MarkHalstead's avatar
MarkHalstead
Copper Contributor
Mar 03, 2025

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.

Resources