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

See how to create Quantitative Data Stem & Leaf Chart using the REPT and COUNTIF functions. This is a BIG formula...

Chapter 02 Busn 210 Business and Economic Statistics and Excel Class

This is a beginning to end video series for the Business & Economics Statistics/Excel class, Busn 210 at Highline Community College taught by Michael Gel ExcelIsFun Girvin

Category:

Education

Tags:

• Excel
• 2007
• Statistics
• See
• how
• to
• create
• Quantitative
• Data
• Stem
• Leaf
• Chart
• using
• the
• REPT
• and
• COUNTIF
• functions

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

[ryangiggs8890]

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

[ExcelIsFun]

You are welcome!

[KingOfTheJungleRoar]

The formula didn't work for me either :( my stem figures had 1 d.p. so I tried dividing by 10 instead... didn't work! Although I had to do it manually the video still helped me learn what stem&leaf diagrams are so thanks!! still a great vid :D

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

[meloving123]

my ctlr+v it wont work why