Powerful Histogram Concept!

redheadclay

New Member
Joined
Sep 24, 2008
Messages
15
I am looking to create a chart detailing the distribution of an equation that has a random number generator as a component. So, the end result would be the above mentioned equation showing a normal distribution curve (or some other distribution curve - not sure yet!!).

Here is the catch. Lets say the answer before I refesh is 500. I press F9, and now it is 200. I want to run 1,000 iterations, but catch the value to each iteration and log it as a value...thus building the Histogram.

I'd like to stay out of writing code, and I would assume that there is a relatively easy way of doing it, but I can't seem to find it. I know I can create a macro, but that would take forever to set up (copying the result into line 1, press F9, copy result in line 2, etc for a 1,000 lines).
There must be an easier way, right??
Thx!
 

Some videos you may like

Excel Facts

Can you sort left to right?
To sort left-to-right, use the Sort dialog box. Click Options. Choose "Sort left to right"

Gerald Higgins

Well-known Member
Joined
Mar 26, 2007
Messages
9,115
There may be easier ways than this, but here's one simple modification of your solution -

Do the calc.
Copy the result into A2.
Insert a new row above A2.
Repeat 1000 times.
 

Watch MrExcel Video

Forum statistics

Threads
1,099,010
Messages
5,466,005
Members
406,460
Latest member
tryingtogoalone

This Week's Hot Topics

Top