How do I create a historgram of non-discrete events
 

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

How do I create a historgram of non-discrete events
 

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

How do I create a historgram of non-discrete events
 

"Mike Middleton" wrote:

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




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