[ Home | Data Analysis | Excel | Visual Basic ]

All work should be completed in the session for which it is set. Work carried over for marking in the following week will only receive half the credit. Note that the session ends at 5:30pm, and work should be marked by this time.

This week you should complete the following tasks:

The use of random numbers (really pseudo-random numbers) in a computer is a powerful tool for the simulation of physical processes.  In Excel-10  we first investigate some properties of random numbers and meet the central limit thereom - the saving grace for many physicists!  You then simulate the exponential decay of nuclei and investigate the 'Drunkard's walk' - a classical random process!  This exercise also introduces you to some sophisticated use of the Excel functions to save tedious typing of formuale. 

This week's lecture provided an introduction to Visual Basic for Applications (VBA) and to procedures in VBA.

[ Previous week | Next week ]