Share via

Excel Frequency Frequency Function

Anonymous
2019-09-25T11:45:30+00:00

Hi,

I am trying to find the frequency of a range of values from a data set for wind speeds, my set is D2:D52549 - I want to find the frequency from the values ranges of 0-0.5,0.5-1,...26.5-27. Initially I used COUNTIF() but this only gives me the frequency for specific values.

I change the function to FUNCTION(), the values should rise rapidly then fall to zero (basically, a normal distribution graph). The graph/value rises but continues to rise and doesn't descend. I think the function is adding every cells that it passes and doesn't change range (0-0.5,-0.5-1,1-1.5...)

Basically, how do I find the frequency from a range of values?

Any help would be appreciated x

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Vijay A. Verma 104.7K Reputation points Volunteer Moderator
    2019-09-25T12:16:45+00:00

    Hi ScottMuir1

    Greetings! I am Vijay, an Independent Advisor. Cast your From and To and put following formula in E2 or somewhere and drag down

    =COUNTIFS($D$2:$D$52549,">="&A2,$D$2:$D$52549,"<"&B2)

    0 comments