St4em and Leaf Display or Plot

[Dessi Bravo]

I had an assignment at class and couldn't do it because I didn't get the stem
and leaf chart in Excel. Can anyone assist me in how to create a stem and
leaf plot?
Thanks.

 

[Mike Middleton]

Dessi Bravo -

Excel does not have a built-in feature for stem and leaf charts.

Perhaps your class is using a textbook that has an Excel add-in that
produces such charts.

If not, browse to www.google.com, and search for "excel stem leaf" (without
the quotes), and you'll find some instructions about creating a stem and
leaf chart using Excel.

- Mike Middleton
http://www.DecisionToolworks.com
Decision Analysis Add-ins for Excel

 

[Gaj Vidmar]

It may be as low as no. 23 on Google's result list for "excel stem leaf",
but it may be an excellent solution:

http://www.mf.uni-lj.si/ibmi-english/biostat-center/programje/excel/StemAndLeafPlot.xls

If you dont' want to mention or use it just because it's (partly) mine,
here's another workbook with macro that produces S&L plots:

http://statistics.unl.edu/faculty/bilder/stat2023/excel/stem-and-leaf.xls

For putting things in a broader perspective, stem-and-leaf plots can be
classified under "charts Excel can't do" (though, of course, it can):

http://epublications.bond.edu.au/ejsie/vol1/iss3/6/

For a somewhat more scholarly and more comprehensive article on such and
other matters of statistical graphics in Excel, one might read (again, can't
help it, it's mine)

http://www.mf.uni-lj.si/ibmi/biostat-center/predtiski/MZ_Vidmar.pdf

Regards, Gaj

 

[Andy Pope]

A few more examples,
http://www.mrexcel.com/pc16.shtml

Cheers
Andy