I'm not gonna lie, I was messing around with my graph for hours, and I had to leave it because I was getting a massive headache. This video is literally gold. I understood everything so easily. Sir you are God send
@pinky7235
3 жыл бұрын
This was comprehensive and straight to the point. Easy to follow. Thank you!
@annettesyou-niqueboutique3579
7 жыл бұрын
You are awesome. Got me out of a jam. No one knows how to explain as well as you for creating a histogram. Thank you.
@victorcurtisjr2797
5 жыл бұрын
This video helped me out immensely. Before this video I was trying to make a histogram in excel and it would never come out right. Now I know how to do it. Thank you so much!!
@BurkeyAcademy
5 жыл бұрын
I am happy to have reduced your Microsoft-related pain! ☺
@Zanator1
Жыл бұрын
Thank you so much for this. It's so much more useful than the automatic histograms Excel makes.
@queeniepomeranian8318
2 жыл бұрын
Oh man you explained that better than my lecturer I'm so puzzled to figure out how to histogram my calculation of class boundaries. Thank you so much
@debbybrigham7095
3 жыл бұрын
Best and easiest to understand instructions THANK YOU!
@tinaosgood4136
7 жыл бұрын
Thank you so much!!!! After struggling for days to do this histogram solo....you made it abundantly easy!!!! Excellent quality!
@lynndakay
4 жыл бұрын
I know . It’s just as simple as he makes it
@hendrixjardiniano1542
3 жыл бұрын
THANK YOU SO MUCH, SIR! I LEARNED SO MANY FROM THIS TUTORIAL! GODSPEED!
@prajjuathikari5370
3 жыл бұрын
Thank you so much, finally I found this video. It really helped a lot🙏
@annettesyou-niqueboutique3579
7 жыл бұрын
Thank you so much. Your explanation on how to make a histogram was the best one I found. Step by step, informative and attention to detail. Thanks again. Awesome!
@BurkeyAcademy
7 жыл бұрын
Glad you liked it! Please let me know if there are other topics you'd like to see!
@erlanmirlanov6267
3 жыл бұрын
Thank you a lot for the detailed explanation and break down. Everything was clear and comprehensive!
@hcamilo95
5 жыл бұрын
Thank you for the great explanation of how to create a histogram!
@ashirugarba7554
8 ай бұрын
You made my day, instructor per excellence
@alexabraham9035
Ай бұрын
very well explined sir thank you. you are a master
@alexabraham9035
Ай бұрын
love your voice too
@kenjimorimitsu1757
7 жыл бұрын
HAS ANYONE TOLD YOU, YOU SOUND EXACTLY LIKE TOM HANKS! (are you tom hanks?)
@BurkeyAcademy
7 жыл бұрын
Kenji Morimitsu Life is like a box of chocolates?
@arlindslab9315
7 жыл бұрын
ha!! i had the same thought.
@adenjones1802
5 жыл бұрын
Lol was thinking the same thing
@leixiao169
4 жыл бұрын
your explanation is very good!
@darshitthakar7999
4 жыл бұрын
Thank you very much, it helped me a lot with my data. My analysis got completed quickly ....
@SarisLtd
7 жыл бұрын
Great video, good for those with very basic/ little or no knowledge of excel. I'm good at excel so I found the explanations to long winded sometimes. :) Good work though, we need more people to understand the power of Excel!
@stijnhogewoning9549
3 жыл бұрын
This saved me so much time! I was already struggling for a while many thanks!
@ameenabaluch5044
4 жыл бұрын
thank you so much I cant emphasis enough how much this helped me
@Davitz2025
4 жыл бұрын
But, you can make a graphic using the pivot table created previously. Thanks for the tutorial. Great use of pivot tables for create range and count the frequencies
@tomanderson1588
6 жыл бұрын
Thanks very much, this video helped me create a good-looking histogram for my geography project.
@samsara5282
7 жыл бұрын
Thank you, you made this really simple to follow.
@teacher9377
6 ай бұрын
Very helpful. Thank you
@sreeparnaadhikari2533
3 жыл бұрын
Thankyou so much it's a saviour
@ruthcarladore2111
2 жыл бұрын
Absolument great
@user-ne3vj1qm9y
Жыл бұрын
how can you add percent and relative frequency without changing the calculation would you have to add that row before you create the pivot table ?
@johng5295
14 күн бұрын
Awesome. Great content.
@ibrahimKhan-nl6of
5 жыл бұрын
Hi... Nice buddy...Tom Hanks...you are great....Thank you...
@kajaljoshi3061
3 жыл бұрын
You are the best! Thank you so much.
@rawandmohammedmajid3828
3 жыл бұрын
Thanks so much for this great video
@jolenedsouza7907
3 жыл бұрын
thank you. really helped me a lot.
@prod.tommylove3886
3 жыл бұрын
This is VERY helpful , thank you very much
@yasmeendanboyah4429
6 жыл бұрын
Thank you so much for making this video, it was absolutely helpful and useful!🙌🏽👌🏽
@valentincontilde
5 жыл бұрын
Thanks, You Saved Me
@lambert1287
6 жыл бұрын
AWESOME! two for one by pivot tabling us into a histogram!
@BurkeyAcademy
6 жыл бұрын
That's how we roll at BurkeyAcademy. ☺
@angelinabalenciaga466
4 жыл бұрын
Thank you very much!!!
@hayderal-sarraf667
2 жыл бұрын
you are perfect!
@bkosql5432
6 жыл бұрын
Thank you, thank you very much!
@commonNigerian
4 жыл бұрын
Very helpful. Thank you.
@SnotRockets55
6 жыл бұрын
THIS IS SO AWESOME THANK YOU!
@rachelchavarin6817
2 жыл бұрын
I'm right clicking and the grouping option doesn't appear
@user-zr5qj9xl5e
Жыл бұрын
Thank you!!!
@TheRealJLS
4 жыл бұрын
Thank you alot bro
@atherahazman
6 жыл бұрын
Hi, Im having trouble to group the sample... when I hovered one of the digit, then I right clicked, then pick group... it says "Cannot group that selection". Help me please, thank you
@mylesmovie
4 жыл бұрын
Same have you found the solution?
@joevilla5925
3 жыл бұрын
@@mylesmovie Did you find the solution? Plz respond asap my grade depends on me overcoming this hurdle
@joevilla5925
3 жыл бұрын
Did you find the solution i'm having the same problem and my grade depends on me getting past this issue plz respond ASAP
@acyn3688
7 жыл бұрын
this was really helpful thankyou
@BurkeyAcademy
7 жыл бұрын
You are welcome!
@paulosabib
7 жыл бұрын
Thank you, very helpful. Would you know how to format those grouped numbers in that row (8:32)? In my case, I need to transform in percentage. Cheers!
@tommyharris5817
Жыл бұрын
Go to format (Ctrl 1)
@nothanks550
3 жыл бұрын
man i love you
@BurkeyAcademy
3 жыл бұрын
I love you too, man!
@IncognitoGirl112
2 жыл бұрын
Thankyou so much :D
@baba-rf2md
Жыл бұрын
nice work
@user-vm4bt2io1s
7 жыл бұрын
So helpful!!! Thank you :)
@mdazam6477
7 жыл бұрын
GREAT Job!
@ehteshamali2893
2 жыл бұрын
Thank you so much sir!! Can you please explain what 'by' stands for when grouping data?
@saharadnan6797
7 жыл бұрын
Its was so informative .. thanks alot
@BurkeyAcademy
7 жыл бұрын
You are welcome sir! Should I start a series on short Excel tips? Hmmm.
@mr.albuslamborghini559
3 жыл бұрын
Thanks sir
@johnmosier4652
4 жыл бұрын
Is there a way to connect the ratings column to the histogram? I'm curious to know the correlation between the price of the restaurant and quality of ratings with the frequency of visits... All in one chart... Is that possible? Thanks!!!
@BurkeyAcademy
4 жыл бұрын
I guess you could divide each bar into colors representing the number of each rating given. I don't know how to do that, but am pretty sure it is possible.
@tzuyu5548
3 жыл бұрын
THANK U
@Bangers_mostly
3 жыл бұрын
What if I want to group the observations in uneven increments? For example, if a price is below $10, then the item is considered 'tier 1', if it's between 10-50, it's tier 2, if it's between 50-100 it's tier 3, etc. How can I get it to group it under those categories?
@BurkeyAcademy
3 жыл бұрын
Then you are not making a histogram, you are separating data into qualitative categories, and make a bar graph. You can assign labels using the ifs function, then count them using the countif function.
@Bangers_mostly
3 жыл бұрын
@@BurkeyAcademy lol ended up making a bar graph naturally & then your comment made perfect sense 😭
@user-on6uh8gi8g
2 жыл бұрын
u r z best !
@blader8303
5 жыл бұрын
Really Helpfull
@anshulgarg4875
5 жыл бұрын
Really appreciate your help man🍺
@ssvnikatta600
4 жыл бұрын
Thanks
@StayCurious247
5 жыл бұрын
hi, can you tell me how did you come up with a decision of giving good, very good and excellent value?
@BurkeyAcademy
5 жыл бұрын
It is a data set that came from an old textbook. But, the idea is that this would have been a survey questionnaire where that value is the judgement of the customer.
@lisamvelase4770
2 жыл бұрын
@joselcontrerasmora9047
7 жыл бұрын
I am having trouble finding a way to plot the relative frequency with Excel 2016. Do you know how to do that?
@BurkeyAcademy
7 жыл бұрын
What trouble are you having? You can copy the frequencies, divide by N, then plot the result.
@joselcontrerasmora9047
7 жыл бұрын
I guess you cannot do that directly. You have to make the table for it, correct? Thanks for the quick reply!
@BurkeyAcademy
7 жыл бұрын
That would be my guess- Excel is quick for getting the frequencies, but when doing anything more involved I always copy out the frequencies, then manipulate them so I know what is happening. Cheers!
@shenaazebrahim3402
2 жыл бұрын
Can u post the link to the previous video please
@BurkeyAcademy
2 жыл бұрын
I have a link to the entire playlist in the video description... But here it is anyway: kzitem.info/news/bejne/qqln2pyBbopkrH4
@xinpan7872
7 жыл бұрын
Thank you for the instruction. I do have one further question for the histogram chart, the x-axle particularly. Can the marks of the x-axle be changed as "10, 15, 20,……,45, 50", rather than the ranges like "10-14, 15-19……, 45-49"?
@BurkeyAcademy
7 жыл бұрын
I made you a video on this: kzitem.info/news/bejne/rm2rnIl5oqmVlmk
@xinpan7872
7 жыл бұрын
Thank you for the reply. However, this link is unavailable
@BurkeyAcademy
7 жыл бұрын
Thanks for letting me know, and Sorry! For some reason KZitem didn't release the video after it processed it. Try now, it should work.
@meridianlandmark7537
7 жыл бұрын
WHAT ABOUT INSERTING NORMAL DISTRIBUTION CURVE
@BurkeyAcademy
7 жыл бұрын
Sure, I can do a video on that... stay tuned!
@BurkeyAcademy
7 жыл бұрын
Here is a video just for you! kzitem.info/news/bejne/yn6Av4udcmujg6A
@JustToCallYouOut
7 жыл бұрын
thanks, my histogram is beautiful.
@hossainabeer
4 жыл бұрын
I paid my university, IUB, a $1,000. They just linked me to a free, youtube video?
@hossainabeer
4 жыл бұрын
Admin's creative teaching skills are being exploited
@BurkeyAcademy
4 жыл бұрын
Well, at least I hope you learned something. 😃 I love trying to help everyone learn, so I am happy to try to you if I can.
@muhammadm4582
4 жыл бұрын
so complicated
@MrKrushgutz
3 жыл бұрын
Did this really needed to take 20 minutes?
@BurkeyAcademy
3 жыл бұрын
You do know you can watch at a higher speed and fast forward, right? 😁
Пікірлер: 105