How To Create A Frequency Table & Histogram In Excel

In this video tutorial, I will show you how to create a frequency table and a frequency histogram by using Microsoft Excel.

A frequency table is a table that lists the number of counts (frequency) for a dataset. To be able to create a frequency table, the data must be split into bins. Bins are a small range of values to make it easier to count the data. The FREQUENCY formula in Excel makes this really easy to create a frequency table.

The data in the frequency table can then be displayed as a histogram. This makes the data easier to interpret. Frequency histograms are an excellent way to visually inspect your data when testing for normality.

HOW I CREATED THIS TUTORIAL (AFFILIATE LINKS)
Screen recorder & editor https://techsmith.z6rjha.net/c/198849...
YouTube SEO https://www.tubebuddy.com/SHTeach
Software (Microsoft Excel 365 ProPlus)

FOLLOW US
Website https://toptipbio.com/
Facebook   / toptipbio  
Twitter   / toptipbio  

AFFILIATE DISCLAIMER
Some of the above links are affiliate links, meaning I will earn a commission if a sale is made after clicking on the link.