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

Chi square tests

C

claire3000006

Member
I'm doing the CA2 worked example and I notice they do the chi square test the long way (calculating A-E, chi square value, degrees of freedom etc) when you can get the same result using the CHITEST formula in excel.

Is this formula frowned upon or is it okay to use it?

Thanks
 
I can't comment on this from the point of view of the examiners.

However, I would say that Excel is not a sound tool for statistical analysis. For example, older versions of Excel calculated standard deviations using the single pass method, which is inaccurate for sets of large data points. More generally, numerical algorithms are almost never specified and generally, seem to be derived directly from theoretical results, with no consideration given to practical numerical effects.

There is a good summary and set of references here:

http://www.practicalstats.com/xlsstats/excelstats.html

It is also worth having a read of this:

http://www.burns-stat.com/pages/Tutor/spreadsheet_addiction.html
 
You must log in or register to reply here.
Back
Top