Philip has attended:
Excel Forecasting and Data Analysis course
Excel Advanced course
Excel Functions
I wondered if Excel has a function for a Chi Square test (I believe this is the name). My memory from A-level maths is that this test provides an indication of statistical dependency.
In the example from Jens regarding Dangerous Ice Creams, there was a Correlation between shark attacks and ice cream sales, but not a not an inter dependency. I believe Chi^2 tests for this.
RE: Excel Functions
Hi Philip
Thanks for your question, sounds like a really interesting one!
The best person to answer you is of course Jens, who ran your training and will be familiar with the example you talk about.
Jens is delivering a complex training today and tomorrow, so may not have capacity to answer your question this week. However I can see he will have time on Monday to take a look at it, I hope this is ok.
Kind Regards,
Sarah
STL Training Manager
RE: Excel Functions
Thanks
RE: Excel Functions
Hi Philip,
I hope you are well.
Thank you for the forum question.
We can do a Chi Square test in Excel. We have the chitest function.
I haven't had the time to get my head around exactly what the function is doing, but I will come back to you not later than Monday.
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
RE: Excel Functions
Thanks Jens, I look forward to hearing from you, although no rush.
RE: Excel Functions
Hi Philip,
I hope you had a nice weekend.
We have got an updated function to do a Chi Square test. The CHISQ.TEST function, but if I understand the Chi Square test right, it will not help us to find out if ice cream is dangerous in Australia :-)
As I understand Chi Square test, the test can tell us how far a expected result is from the actual result.
The link below show an example of using the CHISQ.TEST function.
https://support.microsoft.com/en-us/office/chisq-test-function-2e8a7861-b14a-4985-aa93-fb88de3f260f
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector