not exactly, no. It contains the mathematical formulas for deducing the probability of certain results, but you will have to write these into Excel yourself, unless you have a statistical package to help you
It covers the theory of one-tail and two-tail tests, but you would need to write the actual test yourself, e.g. at what point would you want to break out if the 2tail test fails..?
Once you have written the formulas, you can use macros to loop through and perform some monte-carlo sampling for you
For basic monte carlo style anaylsis, you would have formulas that include the RAND() function, then use a simple macro something like the following
Code:
sub simulate()
dim i as integer
for i = 1 to 100
calculate
sheets("results").cells(i,1).value = range("[cell with results in]").value
next i
This builds a table of results, that you could then perform further analysis on
I'm straying outside of my areas of - lets call it comfort, rather than expertise
- so I don't really want to get dragged further into statistical theory than this