that's a bar chart, not a histogram. the area of the bar in histogram represents the frequency
@dolledout83 жыл бұрын
thank you !!! excellent, straight to the point. i have a terrible professor who doesn’t explain this stuff easily so this is a lifesaver !
@StevenBradburn3 жыл бұрын
Thanks Kyle! Glad it helped
@attab0072 жыл бұрын
econ?
@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.
@stevenroberts4262 жыл бұрын
Thankyou. Finally, someone who can teach this stuff to anyone. Its a valuable skill. You are the man!
@j69k3 жыл бұрын
thanks, really helped with my assignment!
@franciscomachadodeassis12974 күн бұрын
Greetings from Brazil! Your channel has by far the best tutorials! Congratiulations!
@Lucas-mj7je Жыл бұрын
"Fromula"
@jesperroelofsen5830 Жыл бұрын
array fromula :)
@minahan93152 жыл бұрын
Thank you for homework help!!
@thessenceofconstance3 жыл бұрын
Its been a while since I’ve used excel. Thank you!
@sharoncosgrove53923 жыл бұрын
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.
@paigeygirl20162 жыл бұрын
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!
@rileymg4675 Жыл бұрын
extremely helpful, up to date and clear
@zacharymcguirk64312 ай бұрын
A HISTOGRAM AND BAR CHART ARE 2 VERY DIFFERENT THINGS. I SAT THERE FOR AN HOUR WONDERING WHY MY HISTOGRAM FREQUENCY WASNT WORKING ONLY TO FIND THAT MY FREQUENCY WAS BEING TREATED AS THE DATASET. PLEASE BE MORE SPECIFIC NEXT TIME.
@gerryts204010 ай бұрын
I will definitely send my students to this tutorial... Your clarity is really great!
@mr702s Жыл бұрын
The bins situation is totally screwing me up
@KennedyIvy2 жыл бұрын
You are my new god
@gorgeeus2 жыл бұрын
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!
@famueduyou3 жыл бұрын
How come this wonderful video has got some dislikes? They were probably watching it upside-down, hence the likes turned into dislikes, haha.
@LNasterio3 жыл бұрын
I saw someone using a simple Analyze Data function did this all... but I couldn't find it
@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!
@dangortarez12 жыл бұрын
Why though. Why did you use a limit of 64. That’s the type of shot you need to explain.
@selenanv8592 ай бұрын
Great tutorial. Using this for tracking my coins found metal detecting.
@DavidRodriguezPR3 жыл бұрын
Thank you. You did a great job explaining it.
@StevenBradburn3 жыл бұрын
Thank you David
@XxShade_FrostxX2 жыл бұрын
Histograms are bar graphs without spaces though..
@dursung_ Жыл бұрын
Extremely basic n helpful vid. Thanks for this cool work!
@vincenthodge24044 ай бұрын
Thank you, this was the best tutorial for what I needed.
@samuelchiang22852 жыл бұрын
I dont have the option to select data when right clicking the chart. I'm on Sharepoint
@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
@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.
@tinabarnesactor5 ай бұрын
You have no idea how much you've just helped me out! Amazing video. Thank you!
@phoenixblack1220 Жыл бұрын
Thank you so much! Working on Data Analytics in school and this is very helpful!
@Tonnika7193 жыл бұрын
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?
@maxinechantel23936 ай бұрын
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.
@StevenBradburn6 ай бұрын
You're very welcome Maxine!
@tommyharris5817 Жыл бұрын
You do not need to click Ctrl, Shift, Enter as Excel does it automatically in v2021
@StevenBradburn Жыл бұрын
Thanks for the tip Tommy!
@catherinekeenan77972 жыл бұрын
I love you. Thank you so much for this video.
@VokeMichaelOghenekaro7 ай бұрын
Okay but how do you set the Y-axis??
@johnteo83327 күн бұрын
Thank you, your a life saver!!
@axel_r_ Жыл бұрын
That is not a histogram. It is a Column Chart.
@stephaniea.jimenezcontrera1593 жыл бұрын
Super helpful, didn't understand what I was doing wrong til now, thank you, cheers from Honduras,
@leakhoury18823 жыл бұрын
it's not working for me
@kingheffy90442 жыл бұрын
Thanks dude, I couldn't see the board and ended up trying to do this for hours
@tcshorts3353 Жыл бұрын
anyone notice this isn't a histogram?
@monotonous61953 жыл бұрын
THANK YOU SO MUCH! YOU ARE NOW MY HERO! YOU JUST SAVED ME FROM A DAY OF HEADACHES!
@geewin84733 жыл бұрын
ok
@dangortarez12 жыл бұрын
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.
@المرأةالناجحة369-ذ7ع Жыл бұрын
Thank you so much, it is so useful
@DinellArnold-s8l Жыл бұрын
This was an excellent presentation of how to create a histogram in Excel....Perfect!! Very easy to follow.
@horstmueller10006 ай бұрын
brrr ☺
@alfredtovar64512 жыл бұрын
Didnt work buddy...
@batcryalok Жыл бұрын
Very good. I will use it.
@DrMame4 жыл бұрын
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?
@ace101guy3 ай бұрын
Thank you so much
@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!
@dark41372 жыл бұрын
Thank you! This was an excellent video!
@rabbiahmed2498 ай бұрын
Very well explained, TY!
@ZeeSounds2 жыл бұрын
Good stuff. Thanks
@fonolab Жыл бұрын
Excelent.
@tommyharris5817 Жыл бұрын
BRILLIANT
@jones59703 жыл бұрын
Thanks! Excellent demonstration.
@TrinxjayFC3 жыл бұрын
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?
@StevenBradburn3 жыл бұрын
Because I only wanted my range to go from 64-72 (with 0.5 intervals). So, I only needed 17 cells to do this
@desifoodie83713 жыл бұрын
@@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-jd9lg3 жыл бұрын
@@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.
@gumenemichael28712 жыл бұрын
Awesomeness
@LifeLearned460 Жыл бұрын
Simple and easy to follow up, many thanks
@brettlangridge94492 жыл бұрын
Thanks so much! I had an assignment with a basic histogram and couldn't do it. This video really made a difference!
@Sumesest2 жыл бұрын
Great video!
@rrag12332 жыл бұрын
LIFESAVER!!
@suzymagnin46772 жыл бұрын
Thank you!
@ivlivs.c36662 жыл бұрын
Super helpful! Thank you!
@keyarana14253 жыл бұрын
thank you so much
@NorthmenStudios3 жыл бұрын
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.
@edwardbaker90263 жыл бұрын
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.
@jacegarrett10083 жыл бұрын
@Edward Baker instablaster =)
@edwardbaker90263 жыл бұрын
@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.
@edwardbaker90263 жыл бұрын
@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!
@jacegarrett10083 жыл бұрын
@Edward Baker Happy to help =)
@doaakhalil71523 жыл бұрын
Very useful thank you
@StevenBradburn3 жыл бұрын
Very welcome
@legend78903 жыл бұрын
Would 5 go between 0-5 or 5-10?
@DavidLee-jd9lg3 жыл бұрын
5 is from 0-5.... and 10 would be anything from 5-10.