urgent: Histogram and box plot with excel 2000 !
Author Message
urgent: Histogram and box plot with excel 2000 !

Hi !
Does somebody know if there's anyway to build a box plot
and histogram with excel 2000 ?
I'm trying to build a histogram with statistic summarize
such as - avarage, SD, median ect without using functions.

Barak Mery

Wed, 11 Sep 2002 03:00:00 GMT
urgent: Histogram and box plot with excel 2000 !
[This followup was posted to microsoft.public.excel.charting and a courtesy

newsgroup for further discussion.]

I'm sure that what you want to do is crystal clear to you.  Unfortunately, the
same cannot be said about me.  I have two questions about the posting.

1)  A histogram, typically, is a column chart, i.e., a rectangular box that
touches the x-axis.  A box plot, on the other hand, uses a rectangle that seems
to hang in mid air.  So, I'm not sure of what exactly you want.  Is it a
histogram that looks like a box plot?  Or something else?

2)  I'm not sure if there is any way for anyone to calculate statistical data
without a function or a formula.  Whether one does it 'by hand' or by using a
built-in Excel function, or a (more robust) user-defined VBA function, some
function (or equivalent formula) has to be used.  So, what exactly it is that
you want to do?

--
Regards,

Tushar Mehta
www.tushar-mehta.com
--

Quote:

> Hi !
> Does somebody know if there's anyway to build a box plot
> and histogram with excel 2000 ?
> I'm trying to build a histogram with statistic summarize
> such as - avarage, SD, median ect without using functions.

> Barak Mery

Thu, 12 Sep 2002 03:00:00 GMT
urgent: Histogram and box plot with excel 2000 !
Barak Mery  -

Quote:
> Does somebody know if there's anyway to build a box plot
> and histogram with excel 2000 ?
> I'm trying to build a histogram with statistic summarize
> such as - avarage, SD, median ect without using functions.

Box Plot: There's a Knowledge Base article on the Microsoft web site that
explains how to use a stock chart to make something resembling a box plot.

Histogram and Descriptive Statistics: Use Excel's built-in analysis tools.
Choose Tools | Data Analysis | ... If Data Analysis doesn't appear on the
Tools menu, choose Tools | Add-Ins and check the box for Analysis ToolPak.
If it's not listed there, find your Excel/Office installation disk and add
it by doing a custom install.

-  Mike Middleton

Fri, 13 Sep 2002 03:00:00 GMT
urgent: Histogram and box plot with excel 2000 !

Quote:
> Barak Mery  -

> > Does somebody know if there's anyway to build a box plot
> > and histogram with excel 2000 ?
> > I'm trying to build a histogram with statistic summarize
> > such as - avarage, SD, median ect without using functions.

You are welcome to look at Analyse-it, our statistical analysis add-in for
Excel. It will generate histograms & box-whisker plots, plus all manner of