power4XL Microsoft Excel Resource Center
Free Macros, Formulas, Functions, Tutorials, Downloads, Add-Ins & More!

Modeling normal distributions with the Excel Monte Carlo VBA hybrid approach - SAT example #3

ShareThis

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 outcome.

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 example:

 

 

Prev | Contents | Next

Copyright notice:  This site and all content, including computer code and spreadsheet examples, are copyright 2006 by Fritz Dooley.  License is granted for individual users to download examples and to copy code directly into user's spreadsheets and Visual Basic for Applications files.  Users may not redistribute code in any way.  Providing hyperlinks to this web site is encouraged, but posting code and examples on other web sites is expressly forbidden.  "Microsoft" is a registered trademark of Microsoft Corporation.   Neither this web site nor Fritz Dooley is affiliated with Microsoft Corporation.