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