Stem & Leaf Plots?
Is there a way to produce stem & leaf plots in Excel?
-- simplyamazed |
"If a Tree Fell in the Woods, Would It Be Part of a Stem-and-Leaf Plot?"
(quoted from http://www.create.cett.msstate.edu/c...?articleID=199) A template is available from this page which may help: http://home.ched.coventry.ac.uk/Volume/vol0/stem.htm - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ simplybarry wrote: Is there a way to produce stem & leaf plots in Excel? |
Thanks for the Goldmine...looks & works just like I had hoped...happy
crunching & thanks again...sign me, -- simplyamazed "Jon Peltier" wrote: "If a Tree Fell in the Woods, Would It Be Part of a Stem-and-Leaf Plot?" (quoted from http://www.create.cett.msstate.edu/c...?articleID=199) A template is available from this page which may help: http://home.ched.coventry.ac.uk/Volume/vol0/stem.htm - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ simplybarry wrote: Is there a way to produce stem & leaf plots in Excel? |
For an implementation a bit closer to the old-days sophistication of
stem-and-leaf-plots (see J.D.Emerson & D.C.Hoaglin: "Stem-and-leaf displays", in "Understanding robust and exploratory data analysis" by D.C.Hoaglin, F.Mosteller & J.W.Tukey, Wiley, 1983, reprinted 2000), automated via macro, visit http://www.mf.uni-lj.si/ibmi-english...ter/index.html and in the menu on the left click on "Software" (and then scroll to the bottom of the page). Direct link is http://www.mf.uni-lj.si/ibmi-english...ndLeafPlot.xls There you (and others interested in distribution plotting in Excel) can also find my implementations of windowgrams and coplots, dot plots (simple and multi-way) and dot-density plots (an extremely simple yet efficient solution with character-based cell-chart). Additionally, there's a macro for the Bland-Altman method-comparison chart, and a macro for Kaplan-Meier survival curve estimation and plotting (both are just improvements of other people's work). Best regards, Gaj ---------- Gaj Vidmar, MSc, Biostatistician University of Ljubljana, Faculty of Medicine, Institute of Biomedical Informatics "Jon Peltier" wrote in message ... "If a Tree Fell in the Woods, Would It Be Part of a Stem-and-Leaf Plot?" (quoted from http://www.create.cett.msstate.edu/c...?articleID=199) A template is available from this page which may help: http://home.ched.coventry.ac.uk/Volume/vol0/stem.htm - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ simplybarry wrote: Is there a way to produce stem & leaf plots in Excel? |
All times are GMT +1. The time now is 04:00 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com