It is quite easy to draw a boxplot in Excel.
There is a very simple one you can download from
http://www.man.deakin.edu.au/rodneyc
or if you want one that shows outliers separately there is one in 1Num.xls in
XLStatistics.
(XLStatistics is a set of Excel workbooks designed to replace and enhance the Data
Analysis toolbox addin that comes with Excel. It has separate workbooks for each
combination of variables. The freeware version of XLStatistics (with a demonstration
movie, etc) can be downloaded from
http://www.man.deakin.edu.au/rodneyc/XLStats.htm
or, if you are an educator, the full version can be downloaded from the same place if
you get the password from me.)
Rodney
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Rodney Carr
School of Management Information Systems
Deakin University
PO Box 423
Warrnambool VIC 3280
Australia
email: [EMAIL PROTECTED] phone: + 61 3 5563 3458
mobile: 0417 307 692 fax: + 61 3 5563 3320
www: http://www.man.deakin.edu.au/rodneyc
-----Original Message-----
From: Del Harnisch [SMTP:[EMAIL PROTECTED]]
Sent: Monday, December 13, 1999 10:57 AM
To: [EMAIL PROTECTED]
Subject: boxplots from Excel or Access
Does anyone know how to produce boxplots from excel spread sheets or from
Access? I know how to do this with SAS but was wanting to see if it was
possible to go directly from excel to boxplots that could be saved in .gif
or some readable html format.
Del
