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

Chapter 10 Questions in Excel

A

ActStudent2711

Member
I understand that Examiners wish to see all working when using excel as a calculator. For a goodness of fit question for example, would I need to show the exact calculation (with values) for each standardised deviation or could I simple state that:

z_x = (observed deaths - E_x^c*graduated rate)/sqrt(observed deaths - E_x^c*graduated rate)

And then copy and paste an image of the table with explanations of the columns in the same style as above?

Thanks in advance!
 
Hello

Personally I'd be doing the latter, clearly stating the formula that I'm using for the individual standardised deviations and then copying over a table having done the calculations in Excel.

Andy
 
You must log in or register to reply here.
Back
Top