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.

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.

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.

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.

You might get lucky and have someone with knowledge about StatPlus
respond to your query. If not, consider checking with the folks from
whom you got/bought the add-in.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...
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.