Excel - How to Create a Frequency Distribution Table for Quantitative Data | Make Histogram in Excel

👍👍If you have found this content useful and want to show your appreciation, please use this link to buy me a beer 🍺. https://www.paypal.com/donate/?hosted_button_id=CGKRY2BAYEQBQ Thank you! 👍👍 Download the featured file here: https://www.bluepecantraining.com/wp-content/uploads/2022/01/Frequency-Distribution-1.xlsx In this video I demonstrate how to create a frequency distribution table in Excel. The video covers two ways of doing this: 1) Using the FREQUENCY function 2) Using the Analysis Toolpak I also demonstrate how to create a histogram chart based on a frequency distribution table. Both the frequency distribution table and the histogram chart require you to set up bins. Each bin contains the number of values that lie within the range of values that define the bin. So for example, I am using age ranges for bins: less than 25, 26-35, 36-45 etc and each bin will contain the number of people that fall within that age range. Table of Contents: 00:00 - Introduction 00:19 - Method one: using formula 00:28 - Setting up the bins 01:21 - Creating horizontal category labels for a histogram chart 02:46 - Using the FREQUENCY function 04:35 - Creating a histogram chart 05:36 - Method two: using the Analysis Toolpak ------------------------