## Monte Carlo Methods in Excel: Part 4 – The Triangle Distribution

A mathematician friend of mine worked for the Navy on calculations involving the movement of sound waves through water. It’s a difficult problem, since the speed of sound varies with temperature and salinity. Being a mathematician to the core, he always wanted the exact answer. At times the Navy had to shake him by the […]

## Monte Carlo Methods in Excel: Part 3 – Some Helpful Tricks

Monte Carlo Methods in Excel: Part 3 – Some Helpful Tricks Andea S. , a student in Learning Tree’s course Power Excel: Analyzing Data to Make Business Decisions, expressed dismay about a problem at work. When she attempted to plot the results of her Monte Carlo inventory and production model, her entire set of model […]

## Monte Carlo Methods in Excel: Part 2 – Random Numbers

Monte Carlo Methods in Excel: Part 2 – Random Numbers All Monte Carlo methods rely on a source of random numbers. Most such sources would more precisely be called pseudorandom numbers, since a deterministic algorithm cannot, by definition, ever produce truly random numbers. If you Google “random numbers” you will encounter a daunting list of […]

## Monte Carlo Methods in Excel: Part 1 – Introduction

If we toss a coin 1000 times, it is pretty easy to calculate the probability of tossing exactly 537 heads. For better or for worse, the real world rarely offers us such cut-and-dry calculations. What if we were trying to calculate neutron density in a critical mass of plutonium? A mathematically precise result is beyond […]

## Subqueries, Real and Apparent

Part III – A Look at a “Physical” Subquery Perhaps I am being a little loose in my terminology, since there really isn’t a query operator called “subquery”. When I say “physical subquery” I am referring to those correlated subqueries where the subquery portion must be executed again and again, once for every row returned […]

Type to search blog.learningtree.com

Do you mean "" ?