Monte Carlo Simulation Fundamentals

In this course you will learn to use Monte Carlo simulations to better your decision making when dealing with uncertainty.
Course info
Level
Beginner
Updated
Oct 27, 2020
Duration
3h 28m
Table of contents
Course Overview
Introduction to Monte Carlo Simulation
Understand Commonly Used Probability Distributions
Monte Carlo Simulation Foundations
Build Your First Monte Carlo Simulation Model
Add a Histogram and Statistics to Your Model
Using a Native Excel Monte Carlo Simulation Model
Build More Complex Monte Carlo Simulation Models
Description
Course info
Level
Beginner
Updated
Oct 27, 2020
Duration
3h 28m
Description

Do you need to make a difficult decision about some uncertain future outcome? Maybe you need to estimate a project cost or schedule, or create a forecast for when your agile-developed software product can be delivered to customers. In this course, Monte Carlo Simulation Fundamentals, you’ll learn how to model these and other uncertainties using a Monte Carlo simulation model in Microsoft Excel. First, you’ll learn why you’ll want to use Monte Carlo simulation to solve estimation problems. Then, you’ll learn how to create a Monte Carlo simulation from scratch, and how to use pre-built Monte Carlo simulation models. Finally, you’ll discover some more complicated problems that commercial Monte Carlo simulation products can solve. By the end of this course, you’ll know what a Monte Carlo simulation is, why it’s used, and how to create your own Monte Carlo simulation using the built-in functions inside Microsoft Excel.

About the author
About the author

William is an experienced Scrum Master, agilist, and project manager who creates positive transformations through training, coaching, and mentoring software development teams.

More from the author
Forecasting for Agile Teams
Intermediate
2h 47m
Sep 11, 2019
Easily Estimate Projects and Products
Beginner
2h 50m
Mar 14, 2019
Section Introduction Transcripts
Section Introduction Transcripts

Course Overview
[Autogenerated] Hi, I'm William W. Davis and welcome to my course Monte Carlo Simulation fundamentals. I'm a scrum master and I t project manager living in South Florida. Estimating the finish date of a plan driven project is hard because the duration of each task on the project schedule is uncertain and forecasting major release dates for agile develops software is hard to because you don't know how much work your agile team might complete in future iterations. Monte Carlo simulation brings insight into these kinds of uncertainties. This course will introduce you to Monte Carlo Simulation using Microsoft excels built in statistical functions to get started. You just need Native Excel in this course. Here's what you'll learn. Understand what Monte Carlo simulation is and why it's used. Discover how to model uncertainty. Using four popular probability distributions. Build a simple Monte Carlo simulation model using a seven step process. Evaluate excels histogram chart To make informed forecasts. By the end of this course, you'll know how to create a basic Monte Carlo simulation model that represents uncertain future outcomes of interest to you. Before beginning this course, you should be familiar with basic statistical terms and have a working knowledge of Microsoft Excel. Please join me to learn how you can create probabilistic forecasts with a Monte Carlo simulation fundamentals course right here on Pluralsight.