モンテカルロシミュレーションを行う。

設定内容

　メニューから［Poptools］→［Simulation tools］→［Numerical projection］と選択すると以下のようなダイアログが表示される。

This routines iterates a discrete time process by simply copying the values in the state vector N(t+1) to the vector N(t) and then recalculating the worksheet for the given number of iterations. At each iteration, Excel recalculates new values for N(t+1). The values in N(t+1) can depend on an arbitrarily complex deterministic or stochastic process. The routine is useful when it is difficult to use a spreadsheet for iteration. You need only specify once how the transition from the state at time t to the state at time t + 1 occurs, and then call the numerical projection routine. The advantage is that the size and complexity of the worksheet required is reduced and you will not need to do too much less copying and pasting ・a source of many errors in spreadsheets. The main disadvantage of this technique is that the results of the iteration are not dynamic. The initial state, N(t), must be a column of values. The final state, N(t+1), must also be arranged as a column, but the cells should contain formulas.

Update : 2005/04/21