How do I create a historgram of non-discrete events

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

MG - 12 Oct 2006 21:58 GMT

I am trying to create a histogram of when events occur, but my time values is
associated with a partial event from a Monte Carlo simulation

Reply to this Message

Mike Middleton - 12 Oct 2006 23:43 GMT

MG -

> I am trying to create a histogram of when events occur, but my time values
> is associated with a partial event from a Monte Carlo simulation <

And what is your problem?

Usually a histogram is created using (1) the static Histogram tool of the
Analysis ToolPak or (2) the dynamic array-entered FREQUENCY function (or
multiple COUNTIF functions) with a Column chart type.

A third static alternative is my free Better Histogram add-in available from
http://www.treeplan.com.

- Mike
http://www.mikemiddleton.com

Reply to this Message

MG - 16 Oct 2006 17:54 GMT

> MG -
>
[quoted text clipped - 12 lines]
> - Mike
> http://www.mikemiddleton.com

I want to sum the fractional events that occur within certain time spans the
histogram add in will not do it nor will FREQUENCY, though I may beable to
use SUMIF

Reply to this Message