KomFi. Academy

medium · CFA Level I Quantitative Methods

An analyst at Oakridge Capital is simulating a price path using Geometric Brownian Motion (GBM) in a spreadsheet.

To generate a standard normal random variate z sim N(0, 1), the correct syntax is:

  1. `=NORM.S.DIST(RAND(), TRUE)`
  2. `=NORM.S.INV(RAND())`
  3. `=RANDBETWEEN(-3, 3)`

Sign up free to see the explanation and track your rank →

More CFA Level I Quantitative Methods practice

All Quantitative Methods questions · CFA Level I study guide · CFA Level I glossary · CFA Level I flashcards