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 techsmith.z6rjha.net/c/198849...
KZbin SEO www.tubebuddy.com/SHTeach
Software (Microsoft Excel 365 ProPlus)
FOLLOW US
Website 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.

[@stevenroberts426]

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

[@selenanv859]

Great tutorial. Using this for tracking my coins found metal detecting.

[@paigeygirl2016]

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!

[@thessenceofconstance]

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

[@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!

[@user-uf6tp1og8p]

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

[@stephaniea.jimenezcontrera159]

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

[@tinabarnesactor]

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

[@rileymg4675]

extremely helpful, up to date and clear

[@dolledout8]

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

[@StevenBradburn]

Thanks Kyle! Glad it helped

[@attab007]

econ?

[@jones5970]

Thanks! Excellent demonstration.

[@gerryts2040]

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

[@j69k]

thanks, really helped with my assignment!

[@LifeLearned460]

Simple and easy to follow up, many thanks

[@phoenixblack1220]

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

[@dark4137]

Thank you! This was an excellent video!

[@ivlivs.c3666]

Super helpful! Thank you!

[@dursung_]

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

[@vincenthodge2404]

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

[@rabbiahmed249]

Very well explained, TY!

[@catherinekeenan7797]

I love you. Thank you so much for this video.

[@DavidRodriguezPR]

Thank you. You did a great job explaining it.

[@StevenBradburn]

Thank you David

[@minahan9315]

Thank you for homework help!!

[@brettlangridge9449]

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

[@maxinechantel2393]

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.

[@StevenBradburn]

You're very welcome Maxine!

[@monotonous6195]

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

[@geewin8473]

ok

[@user-ti1nf7qb4v]

Thank you so much, it is so useful

[@Sumesest]

Great video!

[@DrMame]

Is there a way to do chi-squared and t-students (for example) to compare multiple variables at the same time in one single command in R instead of choosing one variable at time to compare in every command?

[@ZeeSounds]

Good stuff. Thanks

[@kingheffy9044]

Thanks dude, I couldn't see the board and ended up trying to do this for hours

[@ace101guy]

Thank you so much

[@batcryalok]

Very good. I will use it.

[@suzymagnin4677]

Thank you!

[@rrag1233]

LIFESAVER!!

[@keyarana1425]

thank you so much

[@tommyharris5817]

BRILLIANT

[@Tonnika719]

I do not have a labtop or desk top. I am using my IPad to construct this histogram. I cannot input the data into the data source because I cannot find it on the ribbon. Can you please assist in locating the data source?

[@gorgeeus]

My bins get HUGE towards the end of the 217 values. I’ve settled in a width of 5, any idea of what I’m doing wrong? Thank you for the video!

[@TacoloyDodongDaveV]

I think most options talked about in the chart are only available on premium, excel online did not have much variety of options, to begin with just the basic ones. But still a really great help!

[@gumenemichael2871]

Awesomeness

[@KennedyIvy]

You are my new god

[@fonolab]

Excelent.

[@doaakhalil7152]

Very useful thank you

[@StevenBradburn]

Very welcome

[@kamalranatunga]

What a great tutorial, that cleared many issues, still have an issue if you add the formula for the frequency array just next to the first bin. Rather it needs to add 1 row above it seems. May be a difference in the version of MS Excell. I use Office 365.

[@sharoncosgrove5392]

Nice video but the new version is slightly different and no way of changing the horizontal axis to bin limits..it puts them on the vertical limits.

[@TheHolymoly73]

Hello! Thank you very much for your great explanation! Can you give me some advice? I want to analyse certain KZbin Channels, compare them, views, regions, days. What kind of test would be the best?

[@StevenBradburn]

Hi Michael. Thanks for your feedback. So the type of test depends on the type of data you want to analyse and the number of groups etc

[@NorthmenStudios]

Awesome video - when sorting the bins if using whole numbers you can also do the command =min and =max and select the data on each command to quickly figure out what the min and max data is.

[@edwardbaker9026]

You prolly dont give a shit but does someone know of a method to get back into an instagram account? I somehow lost my login password. I love any tricks you can offer me.

[@jacegarrett1008]

@Edward Baker instablaster =)

[@edwardbaker9026]

@Jace Garrett i really appreciate your reply. I got to the site through google and Im in the hacking process now. Seems to take a while so I will get back to you later with my results.

[@edwardbaker9026]

@Jace Garrett It worked and I now got access to my account again. I am so happy:D Thank you so much, you really help me out!

[@jacegarrett1008]

@Edward Baker Happy to help =)

[@famueduyou]

How come this wonderful video has got some dislikes? They were probably watching it upside-down, hence the likes turned into dislikes, haha.

[@samuelchiang2285]

I dont have the option to select data when right clicking the chart. I'm on Sharepoint

[@user-jq7mn2nq4z]

Okay but how do you set the Y-axis??

[@lysecandle]

I keep getting a 0 as my first frequency number and I know it has something to do with the class array but I'm not sure why. If anyone knows what I'm doing wrong, do please let me know! I do have the excel sheet created that is causing this error.

[@LNasterio]

I saw someone using a simple Analyze Data function did this all... but I couldn't find it

[@xJoe90]

that's a bar chart, not a histogram. the area of the bar in histogram represents the frequency

[@XxShade_FrostxX]

Histograms are bar graphs without spaces though..

[@TrinxjayFC]

Why you did the bin limits you stopped at cell c18, why didn't you do it all the way to c51. Is there a particular reason?

[@StevenBradburn]

Because I only wanted my range to go from 64-72 (with 0.5 intervals). So, I only needed 17 cells to do this

[@desifoodie8371]

@@StevenBradburn But how come you decided your range should start with 64 and end on 72 and your interval should be 0.5 , is this mentioned in question ?

[@DavidLee-jd9lg]

​@@desifoodie8371 Because look at the height data, the lowest height was 64, and the highest height was 72. He only needs the range of heights between 64 (which is the min height) and 72 (which is the max height).............. He chose 0.5 intervals because it would distribute the data better visually, but that is personal choice.

[@mr702s]

The bins situation is totally screwing me up

[@leakhoury1882]

it's not working for me

[@tommyharris5817]

You do not need to click Ctrl, Shift, Enter as Excel does it automatically in v2021

[@StevenBradburn]

Thanks for the tip Tommy!

[@legend7890]

Would 5 go between 0-5 or 5-10?

[@DavidLee-jd9lg]

5 is from 0-5.... and 10 would be anything from 5-10.

[@horstmueller1000]

brrr ☺

[@dangortarez1]

Why though. Why did you use a limit of 64. That’s the type of shot you need to explain.

[@Lucas-mj7je]

"Fromula"

[@jesperroelofsen5830]

array fromula :)

[@tcshorts3353]

anyone notice this isn't a histogram?

[@dangortarez1]

Yeah without knowing why you used 64 I cannot do mine. Ugh.

[@Rumil_]

If you listened, he explained the data represents student heights. Obviously you wouldn’t need bins from 0-5,5-10, and etc if none exist there.

[@axel_r_]

That is not a histogram. It is a Column Chart.

[@alfredtovar6451]

Didnt work buddy...