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?
> 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.
> Thanks in advanced
> Barak Mery