Excel Statistics 28: Stem & Leaf Chart w REPT & COUNTIF functions

[MrJrod704]

i typed i the formula exactly and it did not go through for me :(

[ferg2289]

How do you make a box plot in excel!?!

Thanks!

[mgranamar3]

I'm an 8th grader whose working on a project.. i looked at your video...it hhelped a lot man!!!! High-five!!

[snip3z1995]

hey to help other people you should copy and paste the formula in the information box :)

[ExcelIsFun]

I am glad that the video helps! High-five!!!

[9997775551000]

Thank you

[ExcelIsFun]

You are welcome!

[meloving123]

my ctlr+v it wont work why

[ryangiggs8890]

longest formula I've ever typed in Excel ! but it's work, lol thanks man !

[ExcelIsFun]

You are welcome!

[leoltwang]

excellent tips!!!!! even grad school data analysis class does not teach me this.....i was told to buy Minitab myself..........

[ExcelIsFun]

I am glad that it helped!

There is basically not many calculating and data analysis tasks that Excel can't do...

[Problem1204]

couldn't you manually type this in?

[jwharris625]

Wow...What an incredibly arduous formula, but, my teacher said the stem and leaf could NOT be done using formulas in Excel. Thank you for the lesson. You have now helped me twice

[ExcelIsFun]

Please show your teacher! And remember: almost anything can be done with Excel!!

[xeniosm]

nice videos man. but ouch! isn't there any simplest way to do this?

[ExcelIsFun]

No, it is just the ouch way. You really have to be tricky with excel sometimes to get it to do what you wnat.

[siaulangkeng]

you sounded like adam lambert and you video helped me! THANKS

[ExcelIsFun]

You are welcome!

[ikettles]

I found you a bit too over enthusiastic at first , but this is one of the most useful things ever! Very helpful and clear I take back what I said.

[ExcelIsFun]

I am glad that the videos is useful!

[ihzero]

I was wondering how would the formula change is you need to do a Stem & Leaf Chart using numbers with decimals?, I thought as much as the COUNTIF cond is pretty much the only change but I cant figure it out

[ihzero]

I've figured it :3 silly me it was so easy, thanks for the video again, great stuff!!!

[ExcelIsFun]

I am glad that you figured it out!!

[almondpigeon]

Zeros

[sweetnezzz1909]

you are the BEST. Thank you so much. I cant even express how helpful this was. <3

[ExcelIsFun]

You are welcome!

[TracyReneeScott]

I love you!!!!

[ExcelIsFun]

Thanks!

Excel and love are good!

[blacksandals]

Thanks!

[ExcelIsFun]

You are welcome!

[Greerina]

I'm impressed by the formula! :-) But I can hardly imagine a situation where I can use it...

[ExcelIsFun]

Some people like them because they are sort of like a Frequency Distribution (see shape of data) and they are sort of like a dot plot (individual items stacked on top of each other) and it has all the detail (unlike FD and DP).

[dada540]

but what if the number get pretty large? let's say we are dealing numbers such as 1800, 2109, 2025, and i would want to put my stem as 18, 20 and 21, wouldn't it be crazy if I derive the fomula for the leaf from 00 all the way to 99?? is there any other way I can do the stem and leaf plot?

[ExcelIsFun]

I did not forget about you - I was just on vacation.

I just made a video for you addressing your question. The title is:

Excel Magic Trick 376: Stem & Leaf Chart for Big Numbers

It may be about 20 minutes until it is fully proccesed

[gandukabacha]

this is insane.....grt work

[ExcelIsFun]

Dear gandukabacha,

I am glad you liked it!

--excelisfun