How To Create A Frequency Table & Histogram In Excel

378,157

2,892 0

Published 2020-09-21

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 techsmith.z6rjha.net/c/1988496/506622/5161
YouTube SEO www.tubebuddy.com/SHTeach
Software (Microsoft Excel 365 ProPlus)

FOLLOW US
Website toptipbio.com/
Facebook www.facebook.com/TopTipBio/
Twitter twitter.com/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.

All Comments (21)

@stevenroberts426 2 years ago

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

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!
@PraisingIntheMiddle 1 year ago

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!
@user-uf6tp1og8p 1 year ago

This was an excellent presentation of how to create a histogram in Excel....Perfect!! Very easy to follow.
@thessenceofconstance 3 years ago

Its been a while since I’ve used excel. Thank you!
@stephaniea.jimenezcontrera159 2 years ago

Super helpful, didn't understand what I was doing wrong til now, thank you, cheers from Honduras,
@phoenixblack1220 1 year ago

Thank you so much! Working on Data Analytics in school and this is very helpful!
@gerryts2040 5 months ago

I will definitely send my students to this tutorial... Your clarity is really great!
@tinabarnesactor 21 days ago

You have no idea how much you've just helped me out! Amazing video. Thank you!
@dolledout8 3 years ago

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

Simple and easy to follow up, many thanks
@rileymg4675 1 year ago

extremely helpful, up to date and clear
@jones5970 2 years ago

Thanks! Excellent demonstration.
@brettlangridge9449 2 years ago

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

thanks, really helped with my assignment!
@dursung_ 11 months ago

Extremely basic n helpful vid. Thanks for this cool work!
@dark4137 1 year ago

Thank you! This was an excellent video!
@ivlivs.c3666 1 year ago

Super helpful! Thank you!
@rabbiahmed249 2 months ago

Very well explained, TY!
@maxinechantel2393 1 month ago

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.