NATCOR Simulation
————————————————————————————
Topic: Design and Analysis of Simulation Experiments
The lectures are based on Working Notes which are divided into four Parts.
You can access the working notes by going to the bottom of my Home Page and following the link there.
The Working Notes are meant to be worked through.
They contain Examples and Exercises. These illustrate the topic or method being discussed. They are an essential part of the text and need to be carefully studied.
Many of the Examples and Exercises come with their own link. (i) Some of the links contain additional notes and more detailed formulas, (ii) The other links are to actual spreadsheets containing data and the worked details using the data.
Some of the initial spreadsheets contain elementary exercises connected with generating random variables and simple sampling experiments. You should aim to do these exercises yourself independently of the worked solutions and then compare your solution with that supplied. The point of these exercises is to give you familiarity with basic formulas and functions that you will need for the more complicated later examples.
The other spreadsheets contain more substantial problems. These are solved using VBA macros for carrying out more substantial calculations and more extensive analyses. You are not expected to write your own macros to duplicate these macros. However you should spend sufficient time using and studying the macros to understand how they function. Thus you should aim to be able to understand the workings of the VBA macros sufficiently well to be able to modify them for solving simple variations of the problem to which they have presently been applied. I have tried to make the macros transparent and relatively easy to modify.
In the spreadsheets, the following convention for cells is used:
Cells with a Yellow background - Headings, Incidental Information
Cells with a Green background - Input Information used in calculations on that Sheet
Intermediate Results and Calculations are not usually coloured.
————————————————————————————
Links
• Lectures/Labs Diary
Lab WorkSheets
Worksheet 1
Worksheet 2
Worksheet 3
Worksheet 4
References are provided at the end of Part IV
————————————————————————————
Stop Press
————————————————————————————