Determining frequency distributions with FREQUENCY

- The term frequency distribution is a familiar one…for those familiar with statistical functions and concepts.…In this particular worksheet we've got a list,…some 500 entries or so, in columns A and B.…People referred to by ID numbers,…and we've got their salaries here.…And we'd like to see a breakout of those salaries…as they fall in different ranges here.…Now I've got a chart to the right.…If I click on the chart you can see…that the chart is based on the data in column D and E.…And for the moment, we have nothing in column E.…We're going to put in the function called FREQUENCY.…

Now this is an array function.…The way the FREQUENCY function works is we fill…in the area where we're going to put in the function first.…Now prior to that, what you have set up…is what's called a bins range.…This is a typical kind of example.…Now we could have different breakpoints here.…They don't even have to be evenly spaced,…although much of the time they probably would be.…We wanna know how many people make…up to and including 10,000,…