Hello,
( I have also posted in https://stats.stackexchange.com/questions/535284/oddsratioorothertechnique)
Before I start I am not well versed in posting on forums so please be patient if I'm going against convention. Plus I am on a steep learning curve with statistics.
I have been presented with some data which originates from a survey filled in by workers who work in the chemical factories (made up data is attached in an excel spreadsheet to illustrate the question  in reality the sample size is larger).
I am being asked to statistically analyse whether there is a significant connection between workers who were diagnosed with cancer whilst working in the chemical environment and whether the workplace has designated clean and dirty areas.
1) Am i correct in saying that i can conduct an odds ratio calculation with confidence intervals and p value as below (I would have to class 'Y  not well adhered to' as 'N' in this case. Is this recommended):
2) Would odds ratio be the recommended approach or are there more robust methods?
3) It may be that I have to exclude some participants who were diagnosed with cancer whilst working with chemicals, but have declined to answer. Does this need taking into account in some way?
Thank you for your time.
Andy
( I have also posted in https://stats.stackexchange.com/questions/535284/oddsratioorothertechnique)
Before I start I am not well versed in posting on forums so please be patient if I'm going against convention. Plus I am on a steep learning curve with statistics.
I have been presented with some data which originates from a survey filled in by workers who work in the chemical factories (made up data is attached in an excel spreadsheet to illustrate the question  in reality the sample size is larger).
I am being asked to statistically analyse whether there is a significant connection between workers who were diagnosed with cancer whilst working in the chemical environment and whether the workplace has designated clean and dirty areas.
1) Am i correct in saying that i can conduct an odds ratio calculation with confidence intervals and p value as below (I would have to class 'Y  not well adhered to' as 'N' in this case. Is this recommended):
2) Would odds ratio be the recommended approach or are there more robust methods?
3) It may be that I have to exclude some participants who were diagnosed with cancer whilst working with chemicals, but have declined to answer. Does this need taking into account in some way?
Thank you for your time.
Andy
Attachments

10.1 KB Views: 0
Last edited: