Hi I'm trying to prepare for my CA2 exam, and have gone through the Acted notes. The Acted notes mention the NORMSINV formula that can be used in Excel to generate values from a standard Normal distribution. I find this a very quick and easy method to use, but the example projects on the Institute website seem to use the Box-Muller algorithm instead, which I find is more time consuming to program. Is it okay to use the NORMSINV formula? Also, I'd appreciate any general advice from those who have sat this exam. I've heard that the so-called "model" solutions given in the Acted Notes would only be sufficient to obtain a "borderline" pass. Is this true? If so, what more are the examiners expecting?!
