Stem & Leaf Plots?

[simplybarry]

Is there a way to produce stem & leaf plots in Excel?

 

[Jon Peltier]

"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/create/classroom/lplan_view.asp?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]

Thanks for the Goldmine...looks & works just like I had hoped...happy
crunching & thanks again...sign me,

 

[Gaj Vidmar]

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/biostat-center/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/biostat-center/programje/excel/StemAndLeafPlot.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