Now we'll look at a slight variation on the previous
example. Instead of using a VBA to summarize results for the histogram,
we'll use the VBA to capture the raw data, then output the entire database to
the worksheet. The worksheet will then tally the values for the histogram
table and chart.
This approach is based completely on concepts we've
already covered and serves to integrate the concepts in a back-to-back
comparison with the previous example as an alternative way of achieving the same
The chief benefit of this approach over the previous
one is that because the user has access to the entire database of iterations, it
may be simpler to perform additional analyses on the data using pivot charts,
statistical functions, and other tools.
The input screen is virtually identical to the prior