How do I create a historgram of non-discrete events

M

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
 
M

Mike Middleton

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 <
Click to expand...

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
 
M

MG

Mike Middleton said:
MG -


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
Click to expand...

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
 
Top