# Statistics excel-based coursework Watch

1. This is the question:
Columns A and B contain the smoking status and education level of 315 British adults. Complete the observed contingency table. Assuming that smoking status and education level are not related complete the expected table. Carry out a test to determine if smoking status and education level are related.

Data are provided in excel and I have completed the observed and expected tables given in excel.

2. (Original post by Eric Wong)
This is the question:
Columns A and B contain the smoking status and education level of 315 British adults. Complete the observed contingency table. Assuming that smoking status and education level are not related complete the expected table. Carry out a test to determine if smoking status and education level are related.

Data are provided in excel and I have completed the observed and expected tables given in excel.

I think Spearman's Rank Correlation Coefficient could be a good next step might be totally off though, yiu never know at 2am lol

TSR Support Team

We have a brilliant team of more than 60 Support Team members looking after discussions on The Student Room, helping to make it a fun, safe and useful place to hang out.

This forum is supported by:
Updated: June 5, 2016
Today on TSR

### What is the latest you've left an assignment

And actually passed?

### Simply having a wonderful Christmas time...

Discussions on TSR

• Latest
• ## See more of what you like on The Student Room

You can personalise what you see on TSR. Tell us a little about yourself to get started.

• Poll
Useful resources

Can you help? Study help unanswered threadsStudy Help rules and posting guidelines

## Groups associated with this forum:

View associated groups
Discussions on TSR

• Latest
• ## See more of what you like on The Student Room

You can personalise what you see on TSR. Tell us a little about yourself to get started.

• The Student Room, Get Revising and Marked by Teachers are trading names of The Student Room Group Ltd.

Register Number: 04666380 (England and Wales), VAT No. 806 8067 22 Registered Office: International House, Queens Road, Brighton, BN1 3XE

Reputation gems: You get these gems as you gain rep from other members for making good contributions and giving helpful advice.