Chapter 20
Using Probability: Modeling and Simulation
IN THIS CHAPTER
Discovering models
Modeling and fitting
Working with the Monte Carlo method
Model is a term that gets thrown around a lot these days. Simply put, a model is something you know and can work with that helps you understand something you know little about. A model is supposed to mimic, in some way, the thing it’s modeling. A globe, for example, is a model of the earth. A street map is a model of a neighborhood. A blueprint is a model of a building.
Researchers use models to help them understand natural processes and phenomena. Business analysts use models to help them understand business processes. The models these people use might include concepts from mathematics and statistics — concepts that are so well known they can shed light on the unknown. The idea is to create a model that consists of concepts you understand, put the model through its paces, and see whether the results look like real-world results.
In this chapter, I discuss modeling. My goal is to show how you can harness Excel’s statistical capabilities to help you understand processes in your world.
Modeling a Distribution
In one approach to modeling, ...
Get Statistical Analysis with Excel For Dummies, 5th Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
