Using Microsoft Excel to do Simulation

I have created some screen movies using Lotus Screen Cam to describe how to do some of the simulation and decision analysis steps that we have discussed in class. These files have been "zipped." The table below gives a brief description of the files. To download the files, simply click on the file name. If you have any questions or comments about the movies, please e-mail me at mgtdgw@business.utah.edu. If you are interested in movies that show how to do statistical analyses, click here.


File Descriptions
File Zipped Size Unzipped Size Description
scrncamp.zip 214 Kb589 Kb The screencam player needed to show the movies. If you don't have LOTUS Screen Cam, you need to download this file.
vlookup.zip 876 Kb 2,436 Kb Shows how to use the VLOOKUP in Excel to generate random numbers from a discrete distribution.
replicat.zip 1,012 Kb2,895 Kb Shows how to use the Data/Table menu item to replicate simulation experiments.

If you do not have a utility to unzip zipped files, you can visit the PKWARE Inc. homepage by clicking on the icon below. You can then download PKZIP that will allow you to unzip the screen movies.

PKWARE, Inc.

Back to Wardell's Home Page

Last updated Mar. 24, 1997