Creating frequency charts

- On this worksheet called Frequency…we're seeing a chart with that label…and also what is commonly thought of…as a frequency chart.…In column B we've got about 600 salaries here,…and ID numbers off to the left.…We want to know how many entries in this list…are 20,000 and below…or how many are between 20,000 and 30,000.…And the chart is showing us that.…But let's actually go back and create this.…It does involve an unusual function called frequency,…not difficult but it is an array function.…

And if you haven't worked with those…they're a little bit different in how we construct them.…So the list here is in no particular order.…We can sort it if we wanted to.…That might help bring out the breakouts.…But we begin the process by creating what's called…a bins list.…And this is somewhat arbitrary.…I think nearly always you'll see a list with the…interval being the same…but that's not a requirement.…And we want to always know our data well enough…to indicate what the highest value is.…Sometimes we won't miss that one.…