Simulation in Excel
Monte Carlo Simulation
Uncertainty is always present in business, but your analysis will allow leaders to make calculated risks. In this course, you’ll learn how to use simulation to identify the most likely future outcomes in an uncertain climate.
Intermediate 12 Lessons 150 Minutes CPD Credits
About This Course
By simulating the best, worst-case scenarios of a business choice, you offer valuable insight into how your company will cope in each case. In this course, you’ll learn how to do this with Monte Carlo Simulation.
Throughout this course, you’ll learn how to use simulations, summary statistics, a frequency distribution table, and a histogram to understand the results of a project length simulation.
By the end of the course, you’ll be best placed to analyze all potential outcomes for a future business operation, using the past to predict the future, as best you can.
Explain the principles of Monte Carlo simulation
Create a simulation and repeat it many times
Analyze the results of a simulation
Simulate variables from a variety of probability distributions
Understand different distributions that a process may follow
1. Principles of Monte Carlo Simulation
2. Creating a Single Simulation
4. Analyzing Simulation Results
5. Simulating Activity Times
6. Simulating Project Length
7. Analyzing the Project Simulation
8. Simulating Demand for a Product
9. Simulating Costs for a Product
10. Simulating Profits for a Product
11. Analyzing our Profit Model
12. Determining the Appropriate Distribution
Showcase Your Skills
Each time you complete a course exam, you earn a certificate that demonstrates your proficiency in that subject matter. We are proud to be able to say that Kubicle certificates are recognized by the most respected employers from around the world.
When you earn internationally-recognized certificates, you increase confidence. And when you enhance your ability, speed and accuracy, you increase your employability.