Download Excel File: http://excelisfun.net/files/EMT1693.xlsx
Learn how to use the FREQUNCY array function to make a frequency distribution for quantitative data. See how to use INDEX to remove the last category created by the FREQUENCY function. See how to use SEQUENCE function and how to create the labels that show the correct bin categories.
Second part of video: LET function to build entire frequency distribution report in a single cell.
Topics:
1. (00:00) Introduction.
2. (00:33) MAX Function
3. (00:50) CEILING.MATCH function to create upper limit in last category
4. (01:16)Number Bins formula
5. (01:26) SEQUENCE function to create all upper limits
6. (02:22) FREQUNCY array function
7. (02:55) INDEX to remove the last category created by the FREQUENCY function
8. (05:07) Create labels for report, easy way.
9. (05:37) Create labels for report, harder way, but more accurate. Use IF function to append different labels into one column.
10. (07:15) LET function single cell formula with variables and final report.
11. (12:47) Summary, Closing and Video Links