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)
Software (Microsoft Excel 365 ProPlus)

FOLLOW US

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.

[stevenroberts]

Thankyou. Finally, someone who can teach this stuff to anyone. Its a valuable skill. You are the man!

[paigeygirl]

Thank you! Thank you! Thank you! I was struggling to correct the X-axis labels and this is the first tutorial I have found that explained it!

[uftpogp]

This was an excellent presentation of how to create a histogram in Excel....Perfect!! Very easy to follow.

[PraisingIntheMiddle]

Thank you so much for making this easy on me! I was truly lost until I found your video on how to do a histogram!

[thessenceofconstance]

Its been a while since I’ve used excel. Thank you!

[dolledout]

thank you !!! excellent, straight to the point. i have a terrible professor who doesn’t explain this stuff easily so this is a lifesaver !

[stephaniea.jimenezcontrera]

Super helpful, didn't understand what I was doing wrong til now, thank you, cheers from Honduras,

[gerryts]

I will definitely send my students to this tutorial... Your clarity is really great!

[tinabarnesactor]

You have no idea how much you've just helped me out! Amazing video. Thank you!

[LifeLearned]

Simple and easy to follow up, many thanks

[rileymg]

extremely helpful, up to date and clear

[phoenixblack]

Thank you so much! Working on Data Analytics in school and this is very helpful!

[jk]

thanks, really helped with my assignment!

[dark]

Thank you! This was an excellent video!

[dursung_]

Extremely basic n helpful vid. Thanks for this cool work!

[DavidRodriguezPR]

Thank you. You did a great job explaining it.

[brettlangridge]

Thanks so much! I had an assignment with a basic histogram and couldn't do it. This video really made a difference!

[maxinechantel]

Steven, thank you this is the best explanation on You Tube teaching me to understand bins, frequency and how to create a histogram chart with bins. A big help for my course work.

[vincenthodge]

Thank you, this was the best tutorial for what I needed.

[monotonous]

THANK YOU SO MUCH! YOU ARE NOW MY HERO! YOU JUST SAVED ME FROM A DAY OF HEADACHES!