98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel Functions
Excel Functions
Resolved · Low Priority · Version 2016
Wed 3 Mar 2021, 16:07Delegate Philip said...
Philip has attended:
Excel Advanced course
Excel Forecasting and Data Analysis 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.
Thu 4 Mar 2021, 09:12Trainer Sarah said...
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
Thu 4 Mar 2021, 10:41Delegate Philip said...
RE: Excel Functions
Thanks
Thu 4 Mar 2021, 12:13Trainer Jens said...
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
Thu 4 Mar 2021, 19:13Delegate Philip said...
RE: Excel Functions
Thanks Jens, I look forward to hearing from you, although no rush.
Sun 7 Mar 2021, 11:19Trainer Jens said...
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
Sun 14 Mar 2021: Automatically marked as resolved.
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Convert a column into row quickly in Excel 2010Occasionally you might enter data into Excel vertically and then when you finish realize that actually it would look more clearer if it was represented in a horizontal format. If you follow these simple steps below, you can quickly change the data from going vertically to horizontally and vice versa. |
