From the course: Excel 2016: Advanced Formulas and Functions

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Determining frequency distributions with the FREQUENCY function

Determining frequency distributions with the FREQUENCY function

From the course: Excel 2016: Advanced Formulas and Functions

Start my 1-month free trial

Determining frequency distributions with the FREQUENCY function

“

- In this worksheet called Frequency, I've got a list of over 600 entries identified by Social Security number and salary, and I've created a list here in Column D, a somewhat arbitrary list. I could have used different breakpoints. They don't have to be equally spaced. What I'm about to do is to create what's called a frequency distribution. I want to know how many of our salaries fall between 30 and 40,000, 40 and 50,000, and so on. I've figured out the minimum and the maximum just with simple formulas here, in my list, so I think this will cover all bases. This entry here, for example, will cover all entries up to and including 30,000. I'd like to create a frequency distribution. Again, the list here is arbitrarily set up. I could have had $15,000 differences, or $5,000 differences, or maybe the first few might be 10,000, and then I've got differences of 5,000. It's more consistent, probably, and more likely that they would have the same interval, but that's not a requirement. What…

Contents