From the course: Learning Excel What-If Analysis
Join today to access over 24,700 courses taught by industry experts.
Run and evaluate your simulation - Microsoft Excel Tutorial
From the course: Learning Excel What-If Analysis
Run and evaluate your simulation
- [Instructor] After you have set up your workbook you can add summary formulas and run your simulation. In fact, because you're using random values to power your analysis, you should run it multiple times and evaluate the results to guard against having unlikely outcomes influence your decisions. My sample file is 0404 analysis, and you can find it in the Chapter 4 folder of the files collection. This workbook is the one that we created in the previous movie. And you can see that I have a table below of random numbers and I have demand above that. The values in cells, B16 through G16 are actually headers that indicate different production levels. And I need to calculate the average result for each of the production scenarios below. And remember, we're working with 100 trials. So to calculate the average of those values in column B in cell B15, I'll type an equal sign, and then average. And then the cell range that I want is…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.
