Excel 2013 Statistical Analysis #10: Description of Dot Plot and Stem and Leaf Charts
HTML-код
- Опубликовано: 22 авг 2024
- 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 ...
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
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?
Thanks!
I believe you add up some drug in to excel teaching. Addicted:) Thank you very much.
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 :)
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!
Thanks
You are welcome, clifford!!!!
A frequency histogram would work just fine, wouldnt it?