Need a hand? All the help you want just a few clicks away
I am trying to determine if there are trends in antibiotic use over a 3 year period ( divided in to 6 month periods). Can the cochran-armitage test be used to determine this? is so how do I set up the data and input the info into XLSTAT? I want to know if antibiotic use is increasing during this time frame. Antibiotic consumption is measured in defined daily doses per 1000 patient days. Below is an example of the data. Period Ceftriaxone DDD/1000 pt daysJan-Jun 2013 80.6Jul-Dec 2013 85.7Jan-Jun 2014 82.5Jul-Dec 2014 81.7Jan-Jun 2015 88.9Jul-Dec 2015 96.3Thanks.
Thanks for your question.
In order to be able to use the Cochran-Armitage test, you need sample size at each time step. For example, in Jan-Jun 2013, you found 191 people out of 2366 (sample size) who used antibiotics, (which gives a rate of 80.6/1000 pt days).
If you don’t have sample size data, I suggest that you simply use the Spearman correlation test instead. Transform your period data into ordinal 1-6 data points.
XLSTAT first steps and statistical learning resources
The place where you will master all of XLSTAT features
Any feature or option you’d like us to develop?
For those of you who prefer video help