Excel 2013 Statistical Analysis #10: Description of Dot Plot and Stem and Leaf Charts

Download files: people.highlin...
Topics in this video:
1. (00:25) Dot Plot
2. (01:37) Stem and Leaf Charts
Reference Videos:
Excel 2010 Statistics #20: Stem and Leaf Chart with REPT and COUNTIFS functions
• Excel 2010 Statistics ...
Excel 2010 Statistics #19: Dot Plot Chart with REPT and COUNTIFS functions
• Excel 2010 Statistics ...

[@excelisfun]

Excel 2013 Statistical Analysis #10: Description of Dot Plot and Stem and Leaf Charts
Download files: people.highline.edu/mgirvin/excelisfun.htm
Topics in this video:
1. (00:25) Dot Plot
2. (01:37) Stem and Leaf Charts
Reference Videos:
Excel 2010 Statistics #20: Stem and Leaf Chart with REPT and COUNTIFS functions
ruclips.net/video/tvEgMBrPw-E/видео.html
Excel 2010 Statistics #19: Dot Plot Chart with REPT and COUNTIFS functions
ruclips.net/video/GK5NgLzLmpc/видео.html

[@jerrydellasala7643]

Mike, I'm going through this course, and regarding the Stem and Leaf table (1:38), assuming the Stem starts in cell H9, I found the formula "=SORT(UNIQUE(LEFT(B6:B17,1)))" gave the same array as the Stem in the class file (it's text but easy enough to change to numbers), and then the formula in I9 "=TEXTJOIN(" ",1,SORT(RIGHT(FILTER($B$6:$B$17,LEFT($B$6:$B$17,1)=H9),1)))" (the first parameter in TEXTJOIN is a space " ") gave the correct answer for the Leaves for the first item in the H9# array, but that formula needed to be copied down to complete the Stem/Leaf table. I couldn't figure out an array formula to either give the complete Leaf array, nor a single formula to give the complete table. Can that be done?

[@pphong]

Thanks!

[@Chamchijjige]

I believe you add up some drug in to excel teaching. Addicted:) Thank you very much.

[@DIGITAL_COOKING]

awesome !! totally awesome
I was struggling with my work, with studying and revising old stuff I learned, now everything becomes good, how? , by studying excel
and I realize it's the most efficient way, what you need? powerful material like this channel, why
I write this ? because I realize How much time I lost to find out the right way the right place :)

[@excelisfun]

I was the same way too, DIGITAL COOKING. I worked without Excel, without efficiency and fun. Then I found Excel in the 1990s. It changed my life. Then I started to share the fun, and here we are now!

[@Clifffffffffford]

Thanks

[@excelisfun]

You are welcome, clifford!!!!

[@healurselfcuzin]

A frequency histogram would work just fine, wouldnt it?