Use the array function FREQUENCY to produce a frequency distribution based on a bins range that consists of cells containing breakpoint values. Before typing the function, select a range of cells corresponding to the bins range; then press Ctrl+Shift+Enter to provide results in the selected cells.
- [Voiceover] On this worksheet called Frequency,…we've got some ID numbers in column A,…some salaries in column B.…There are over 600 entries here,…we'd like to get a frequency distribution.…Now, in an arbitrary way,…I've set up some breakpoints here.…When you're setting up a list like this,…I think most of the time…you want to have these equally spaced.…Now, I could have a list…that's 5,000 apart or 15,000 apart,…I chose 10 here.…I've analyzed the data ahead of time…with two simple functions here.…The MIN function right here…tells me the lowest value in that list.…
I could've sorted the data, as well.…The max function tells me the highest value,…so I know the range.…And so, although we haven't see the results just yet,…that chart to the right will confirm.…The chart here, as I click on it,…is going to be based on the data…in these highlighted cells.…So, we set this list up somewhere nearby,…it doesn't have to be adjacent to our data, necessarily.…We might experiment with this a bit later,…and again, most of the time,…
Author
Dennis Taylor
Released
5/26/2016- Understanding how the hierarchy of operators affects formula results
- Knowing when to use absolute vs. relative references
- Using Formula Builder for unfamiliar functions
- Displaying a worksheet's formulas and highlighting formula cells
- Converting formulas to values
- Creating 3D formulas to gather data from multiple sheets
- Creating and expanding nested IF functions; using AND, OR, and NOT with IF
- Looking up information with VLOOKUP, HLOOKUP, MATCH, and INDEX
- Analyzing data with the statistical functions: MEDIAN, MODE, etc.
- Using the power functions: COUNTIF, SUMIF, COUNTIFS, AVERAGEIFS, and more
- Calculating financial data such as payments
- Performing basic math
- Calculating dates and times
- Editing text with functions
- Using array formulas and functions
- Referencing data in other cells and files
- Extracting information from Excel worksheets
Skill Level Intermediate
Duration
Views
-
Introduction
-
Welcome46s
-
Exercise files25s
-
-
1. Formula and Function Tools
-
2. Formula and Function Tips and Shortcuts
-
3. IF and Related Functions
-
4. Lookup and Reference Functions
-
Use MATCH and INDEX together4m 40s
-
5. Statistical Functions
-
6. Power Functions
-
7. Selected Financial Functions
-
8. Math Functions
-
9. Date and Time Functions
-
10. Text Functions
-
11. Array Formulas and Functions
-
12. Reference Functions
-
13. Information Functions
-
Conclusion
-
Next steps25s
-
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Determine frequency distributions with FREQUENCY