Excel Statistics 22: Histogram & Ogive Charts & % Cumulative Frequency

[blessingyu91]

thank you so much!! you help me alot! :D

[ExcelIsFun]

@blessingyu91 , you are welcome!

[ThunderShock2005]

you sound like that one guy from full house.

but i like it.

[KingOfTheJungleRoar]

Very helpful, thanks!

[sophisextra]

Awesome video!!! Extremely helpful!!

[NicBoyce]

Wow!!! thank you so so much, really helped me :)

[Candichiz]

what is the F4 key on a hp laptop? bcuz if i click the f4 key, it does somethin else :s

[curlykutie]

Thank you so much!!!! you have no clue how many hours you just saved me!

[iemand6685]

I will draw a histogram from your data here fiverr(dot)com/523048

[Soulenergy31]

Great material Sen Sei! As usual!

[ExcelIsFun]

@Soulenergy31 , I am glad that you like it!

[oxlirotatos]

I love you man! I love your simplicity, your style and your enthusiam! I love you!

[ExcelIsFun]

@oxlirotatos , I am glad that the video helped!

[SPQRlupa]

You are awesome !!! Thank you

[ExcelIsFun]

@SPQRlupa , you are welcome!

[CharmingDesignsbycf]

OMG you are great for this a million thank yous,I had racked my brain trying to understand the book for 2 days!.

[ExcelIsFun]

@CharmingDesignsbycf , You are welcome!!!

[redtracklane]

You have no idea how much this video has aided me in my understanding of plotting charts and stuff on excel!! Thank you so much!!!

[ExcelIsFun]

@redtracklane , you are welcome!

[MJNT100]

Just wondering why some profs can't do such explainations and thats their work by profession, you really don't know how much your videos are of help to some of us and u sound motivated in what you are doing making your listeners motivated too...God bless!

[ExcelIsFun]

@MJNT100 , I am glad that the videos help!!!

[ExcelIsFun]

@PrettyEyedMommy , you are welcome! I am glad they help.

[randomanchovies1]

SOOOOO helpful. thank you!!!!

[ExcelIsFun]

@randomanchovies1 ,you are welcome!!!

[ExcelIsFun]

@randomanchovies1 , You are welcome!

[AlphaTek795]

Thanks for the help man. It's people like you that help people with mathematics and their problems. :D

[ExcelIsFun]

You are welcome!

[smked1234]

used the same technique to construct a relative frequency graph n it worked perfect thanks my man great stuff.

[ExcelIsFun]

You are welcome!

[DettiaC]

OMG!!! your so amazing...yeah yeah thank you!!! i'm subscribing!!

[ExcelIsFun]

I am glad that you like it!

[RamboEinstiene]

thank that help me a lot, but i was just wondering from what i had studied isn't orgive suppose to connect to the corner of the bar graph.

[ExcelIsFun]

I don't know about the corner, but it should be connected to the mid-point of each class.

[ExcelIsFun]

I don't know about the corner, but it should be connected to the mid-point of each class.

[00korzika]

Thank you very much. Helped my out a lot.

[ExcelIsFun]

You are welcome!

[rinaldiputra]

u just made my uni homework alot easier thanks!

[mtrputra]

omggg this is so helpful thanks alot!

[ExcelIsFun]

You are welcome!

[kaiL0r]

i have a histogram with a frequency polygon attached on top of it. how do i make my polygons tales reach all the way down to the horizontal x axis?

[wushaaaaaable]

YOU. ARE. A. LIFE. SAVER.

Thank you so much! xoxo

[ExcelIsFun]

You are welcome!

[ysh50hk]

datz wat am sayin' :)

[darrencornell1]

it sure is fun thank you

[ExcelIsFun]

You are welcome!

[conkrotwife]

I'm taking a research stats class for my graduate program and was ready to quit the class. This is an excellent video, I'm on a mac and had no problem following along! Thank you!

[ExcelIsFun]

You are welcome!

[Whitefinish]

Again a great help !!

You're doing so good ExcelIsFun !

Whenever I need to know something about a function I directly go to YouTube and find a video of yours.

Keep it up

[ExcelIsFun]

I am glad that the videos help!

[Isafanhp]

thanks for this! it has helped me a lot!!

[ExcelIsFun]

You are welcome!

[ExcelIsFun]

I am happy to help!

[Am00na]

thank you very much,

this video was helpful and made everything easier for me! =)

[ExcelIsFun]

You are welcome!

[queenyoyola]

Thank you for posting this video. :)

[ExcelIsFun]

You are welcome!

[koop9000]

I know you posted this video a long time ago, but i would still like to thank you as it really helped! 

[ExcelIsFun]

You are welcome!

[ExcelIsFun]

You are welcome!

[xellosomo]

thank you very much!

[ExcelIsFun]

You are welcome!

[liuz0004]

@ExcelIsFun u are amazing.

[ExcelIsFun]

I am glad that you like it!

[pahwac]

Wow amazing I have gone through various excel trainings however I gues they all are no match for you----

Great way of teaching

Strong examples

Your voice reveals that you enjoy excel........

[ExcelIsFun]

I am glad that the videos help!

[gasi88]

One word.. Awesome!

[ExcelIsFun]

I am glad that you liked it!

[rikawenproductions]

You are flawless. Why aren't you my data statistics professor? You make it a lot more interesting than he does, that's for sure.

[ExcelIsFun]

I am glad that the videos are helpful!

[viljamiini]

omg, thank you man. You save my life. Have been trying to learn excel and find these myself but it takes so long. This is absolutely one of the most helpful lessons i have ever taken. Thank you

[ExcelIsFun]

You are welcome!

[gincotree]

Perfect summary. Thank you so much. 

[ExcelIsFun]

You are welcome!

[msjoby89]

You're videos are amazing!! Thank you so much!!! :)

[ExcelIsFun]

You are welcome!

[imles57]

using excel for creating histogram and ogive chart



[serenecelene]

I LOVE YOUR VIDEOS. IM STUDYING 4 A QUIZ TOMORROW AND THE PROFE MADE THE HW ON STUFF WE DIDNT COVER. >_> THNX SO MUX. UR ENTHUSIASM AND CLARITY REALLY HELPS KEEP ME FROM FALLING ASLEEP. IF ONLY U WERE MY PROFE *SIGH*

[ExcelIsFun]

I am glad that the video helps!

[Racd345]

This totally helped me with my Basic Statistics homework for my college class... Thanks soooo much!

[ExcelIsFun]

I am glad that you like the videos!

[Muuip]

Great presentation, just learned a few great tips!

Thanks :)

[ExcelIsFun]

I am glad that it helped!

[aalberta1]

How do I create a histogram where the bins are 20 to <25, 25 to <30, 30 to <35, 35 to <40, 40 to <45, 45 to <50?

[ExcelIsFun]

This video shows how:

Excel Statistics 21: P2 Quantitative Freq. Dist. w Formulas

[ExcelIsFun]

This one shows 3 different formulas:

Excel Magic Trick #198: 3 Formulas For Frequency Distribution

[ellie6530]

that was really helpful, thanks

[ExcelIsFun]

You are welcome!

[vibol03]

your so funny and helpful man :D! thanks

[ExcelIsFun]

You are welcome!

[ilove2shredtheRGZ]

U rock!

[ExcelIsFun]

I am glad that the videos help!

[ArchUndead]

hi, thxx for your tutorials, they have been very helpful, btw can i know how the number are all automatically converted into percentage with the % unit at their back?

[ExcelIsFun]

Search for and watch this video title:

Highline Excel Class 05: Charts, Page Setup, Data Analysis

[huoxushaowei]

so many useful!!!thank yolu!

[ExcelIsFun]

I am glad that it was useful!

[Kellykelify]

you have no idea how many students you have helped.. i think i love you..lol.. no but for real you are really helping me..with my class

[ExcelIsFun]

That is why I put the videos out there! I am glad that they help.

[Palomee16]

You my friend are a life saver!

[ExcelIsFun]

I am glad that the video helped!

[paintwarrior21]

Thank you. You are a life saver

[ExcelIsFun]

You are welcome!

[seamuscrawley]

Is it possible to have uneven class widths on the x axis of a histogram? I know you don't have a video for it.

[shkoder123]

do you offer tutoring?

Elementary Statistics 11th ed

[shkoder123]

do you offer tutoring?

Elementary Statistics 11th ed

[ExcelIsFun]

I do not do tutoring or consulting.

[seamuscrawley]

Have you a tutorial for uneven class widths, so that the x axis has uneven widths of columns?

[ExcelIsFun]

I do not have a video for that.

[seamuscrawley]

I am trying to form a histogram with uneven class widths so that the x axis has uneven widths. Would you have a tutorial???

[ronaldibbio123]

this is really nice!

what was it ctrl + wat? enter?

[ExcelIsFun]

Ctrl Enter. See this video:

Excel Magic Trick #208 Ctrl + Enter 6 Examples Of Efficiency

[Bubnova]

thx so much i would be crazy if i haven't found this excel video , do you have all excel applications video which uses for statistics in your channel or will u add in the future

[ExcelIsFun]

There are over 100 stats videos at the excelisfun channel at YouTube. Search for this video title that shows how to use the excelisfun channel and how to find the Stats/Excel playlists with over 100 videos:

excelisfun Search for Excel Videos, Playlists & Download Workbooks

[XxMelissa16xxx]

Thankyou so much!!! x

[ExcelIsFun]

You are welcome!

[sonusandeep31]

@ExcelIsFun

[needu12]

Man you rock tooooo much....really needed this for my ib math project....thanks a lot buddy

[ExcelIsFun]

You are welcome!!

[AndrewRanicki]

Thank you for the help... and let me say, I've never seen someone so excited over Excel :D

[ExcelIsFun]

You are welcome!

[yA5MiiNE420]

quick question.. the first few colums, was all that data entered manually? cause thats what i've been doing in stats class..

[ExcelIsFun]

Not at all! Watch these video titles first:

Excel Statistics 20: P1 Quantitative Freq. Dist. w Formulas

Excel Statistics 20: P1 Quantitative Freq. Dist. w Formulas

Excel Statistics 21: P2 Quantitative Freq. Dist. w Formulas

[yA5MiiNE420]

thanks so much!

[ExcelIsFun]

You are welcome!

[lenazelaya2]

Thank you SO much!

5 stars!

[ExcelIsFun]

You are welcome! Thanks for the 5 stars!

[Barnsies]

yeah thanks alot dude!! awesome help :D

[ExcelIsFun]

You are welcome!

[BronteNerd]

Thank you so much! You have possibly saved my life. :) Seriously, thank you. xxx

[ExcelIsFun]

You are welcome!

[spand3244]

Thats awesome. I wonder if you can explain pareto chart in that way you did now?

That would be something.

[ExcelIsFun]

I have over 100 stats videos at the excelisfun channel. This video title shows pareto :

Excel Statistics 18: Pareto Chart for Categorical Data See how to create

[spand3244]

Thanks! .

Hey is it possible that you also done a lot of different charts for SPC? (statistic Processing Control) That would be very interesting. For example Steward charts or control charts or other quality methods.

[ExcelIsFun]

I have made no SPC videos.

[spand3244]

That is ok, perhaps that is something that will be complemented some day. QC (quality control" is a very interesting subject.

Thanks for the other videos there was really needed. Continue in the same spirit.

*five stars from me*

[ExcelIsFun]

Thanks for the 5 stars!!

[andreypaultomenban99]

tnx:D

[ExcelIsFun]

You are welcome!

[GabiRav]

Great!!

Preferable to have cells for the titles, and put them in the graph from there.

all of it will be dynamic as it should be.

[ExcelIsFun]

I totally agree1 Although there are other more automatic ways to do this, I always prefer the formulas because they are so updateable.

[winkstarbabe]

duuude, you just saved my life.

i think you fell from heaven (:

ahahah

[ExcelIsFun]

I am glad that the video helped!

[PureDestiny02]

haha nice this is just wat i needed for my data assignment!! very helpful, thx and keep it up.

[ExcelIsFun]

You are welcome!

[TheWorldIsMine0]

5 STARS AMAZING MAN KEEP IT UP !!!!!!!

[ExcelIsFun]

Thanks very much! I'll keep making them.

[venus292]

Thanks man,Your a real help...couldn't done this assignment without your help!

[ExcelIsFun]

You are welcome. I am glad that the video helped!!

[kayogita]

Hey, that was excellent. I couldn't do this and watching your video helped me so much. Thank you so much. I'm going to come back here again and watch more of your videos.

[ExcelIsFun]

I am glad that the videos are helpful. Search for and watch this video title:

Search For Excel Videos Download Excel Files excelisfun

It will show how to search and find the playlist so that you can find exactly the video that you want.

[MrWillverine]

I owe my coursework success to you

[ExcelIsFun]

I am glad that it helped!

[ionavalanche]

ur lesson is so full of emotion, my histogram looked like a piece of shit before i saw this vid

[ortmanz]

Thank you very much this was really helpful, as I had forgotton the formula and was having to do the cumulative frequency in my head, saved alot of time, thank you :)

[ExcelIsFun]

Dear ortmanz,

I am glad that the video helped@

--excelisfun

[vidpeon]

very useful. I'll be coming around again soon.

[ExcelIsFun]

Dear vidpeon ,

I am glad that it was useful!

--excelisfun

[highwaytohe11]

Nice vide mate, helped me out big time

thanks

[ExcelIsFun]

Dear highwaytohe11,

I am glad that the video helped! Stats are fun when you get to do it in Excel!

--excelisfun

[cocknshit]

you really tought me a lesson! thank you.. L1v3 Sav0r

[ExcelIsFun]

Dear cocknshit,

I am glad that the video was useful!

--excelisfun

[dancebgirl]

THANKS U~

[ExcelIsFun]

Dear dancebgirl ,

You are welcome!

--excelisfun

[dimitridauphin]

=Sum((Very + very helpful) + free) = A+

[ExcelIsFun]

Dear dimitridauphin,

= YouAreWelcome!

--excelsifun

[Kiddan78]

Great videos!

Will be visiting often.

[ExcelIsFun]

Dear Kiddan78 ,

EXCELlent!

I'll keep making videos!

--excelisfun

[Alexxu24]

Awsomeeeee....your videos made my work very easy.Thanks and keep it going

[ExcelIsFun]

Dear Alexxu24,

I am glad that it helped!

I'll keep going and making videos if you keep watching (and rating ;))!

--excelisfun

[OneGamblor]

nearly perfect just a little bit slower would be spot on nice job.

[ExcelIsFun]

Dear OneGamblor,

I will keep that in mind!

If some of the videos are too fast, rewind a few times and check them out again.

--excelisfun