Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

excel functions

ResolvedVersion 2016

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

Sun 14 Mar 2021: Automatically marked as resolved.

Excel tip:

Repeating headings on spreadsheets that print on more than one page

By default when you print a spreadsheet out and it prints on more than one page, the headings at the top and the side of the spreadsheet don't appear on all the pages following page 1.

To get Excel to repeat headings on all pages when printing, go to File - Page Setup - Sheet, then select the rows to repeat at the top of pages, and the columns to repeat at the side of pages by clicking on the red arrows at the right side of the two boxes under the 'Print titles' area. Then click OK.

If you view your spreadsheet in Print Preview, you should see the headings being repeated on each page.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.12 secs.