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?