Write a program (either in VBA or R) that reproduces the lognormal frequency distribution for an arbitrary number of runs. That is, this program should:

Produce N normal random deviates.

For each deviate produce a lognormal price relative Classify each price relative into a set of bins running from 0, 0.1, …, 3.

Put the frequencies on the spreadsheet and produce a frequency graph such as the one in section 23.4.