View Single Post
  #4   Report Post  
Jon Peltier
 
Posts: n/a
Default

I've never used StatPlus.

- Jon

elvis sipos wrote:

Thanks for this information. I do have a similar formula for making whisker
plots without StatPlus (and using Excel), but I am trying to figure out how
to do it using StatPlus, since this is a functionality of StatPlus. If you
have any suggestions for how to do these in StatPlus, I would appreciate it.
Regards.

"Jon Peltier" wrote:


A simple box plot is based on percentiles (0-25-50-75-100). You don't
need equal numbers of measurements to determine percentiles.

I have some instructions for building box and whisker plots on my web site:

http://peltiertech.com/Excel/Charts/...tml#BoxWhisker

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

elvis sipos wrote:


I've got the StatPlus add-in for Excel and have data sets with unequal number
of data points. For those columns that have fewer data points, the cells are
blank. I am trying to create a box plot using this data, but unless all of
the columns have the exact same number of data points, I am unable to execute
this function.