## SQL Server vNext (aka 2017) CTP2 Includes Python Scripting

More Analytic Excitement in SQL Server 2017 Last week (the third week in April 2017) Microsoft released its Community Technology Preview 2.0 for SQL Server vNext, more often referred to as simply “SQL Server 2017”. Among the many new features of interest to business intelligence analysts, data scientists, and machine learning aficionados is support for […]

## 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 […]

Type to search blog.learningtree.com

Do you mean "" ?