• We are pleased to announce that the winner of our Feedback Prize Draw for the Winter 2024-25 session and winning £150 of gift vouchers is Zhao Liang Tay. Congratulations to Zhao Liang. If you fancy winning £150 worth of gift vouchers (from a major UK store) for the Summer 2025 exam sitting for just a few minutes of your time throughout the session, please see our website at https://www.acted.co.uk/further-info.html?pat=feedback#feedback-prize for more information on how you can make sure your name is included in the draw at the end of the session.
  • Please be advised that the SP1, SP5 and SP7 X1 deadline is the 14th July and not the 17th June as first stated. Please accept out apologies for any confusion caused.

Sep 2015 P1 sample solution

P

pyuille_1609

Member
Hi

Can someone pleeease put my mind at ease and confirm there was an error in the Excel solution for this paper?
In particular, the data validation of the random numbers... the check should be that there are no numbers greater than 1, correct?
I'm seeing that the entry in cell B9 on the 'Data Validation' tab says "Number less than 1"..... this is wrong, init?
It makes me wonder if I would be penalised for an error like that in the exam?

Concerned,
P
 
for ease of reference, here is the sample solution file...
 

Attachments

  • IandF_CA2-paper1_201509_SampleSolution-Model.xlsx
    519.6 KB · Views: 3
Hello Pyuille,

Yes, I can confirm that to validate your data, you would need to check whether the data conforms to a uniform distribution of U(0,1). Hence, you will need to check that are no such numbers less than zero and greater than one.

If you left a typo in the Excel but you communicated well your methodology in your audit trail and your formula reads well. I don't think you will be penalised for this.

Cheers
 
Back
Top