• 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.

NORM.S.DIST function

I

Interestec

Keen member
Hi, for CM2A are we allowed to use this function to solve for phi or do they want to see the tables result (interpolated)?
 
You can use any calculator in the world (including Excel) to work out P[Z< number]. You do not need to use a printed table and linearly interpolate.

However, for Paper A, I would be cautious to show my working if the number was negative, for example, P[Z< -0.543] = 1 - P[Z<0.543] and then use Excel. I would also not use ANY Excel s/sheet where I had typed anything at all before the exam clock has started.

Weirdly, if you use a Casio (fx991-ES for example), the phi function is already in the circuit board, which is equivalent to having an Excel s/sheet ready set-up with just cell B1 saying "=norm.s.dist(a1,true)", ie ready to type 0.543 into Cell A1 and give an answer in B1. Yet, my understanding is that this second method would constitute a "pre-existing spreadsheet" - so you're actually better off with a Casio in this respect - a pre-existing calculator, I suppose :-D

Good luck!
John
 
You must log in or register to reply here.
Back
Top