Your data analysis solution
Name is required.
Email address is required.
Invalid email address
Answer is required.
Exceeding max length of 5KB

Trends in antibiotic consumption over time

By Chris | Jul 23, 2017 06:05AM CEST

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 days
Jan-Jun 2013 80.6
Jul-Dec 2013 85.7
Jan-Jun 2014 82.5
Jul-Dec 2014 81.7
Jan-Jun 2015 88.9
Jul-Dec 2015 96.3

Thanks.

Up

0

Down

By Sébastien | Jul 24, 2017 10:42AM CEST | XLSTAT Agent

Dear Chris,

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.
https://help.xlstat.com/customer/en/portal/articles/2062261-spearman-correlation-coefficient-in-excel-tutorial?b_id=9283

Jean Paul

Post Your Public Answer

Contact Us

1c26995d494fb3061dd0ae8571ffc0a4@xlstat.desk-mail.com
https://cdn.desk.com/
false
desk
Loading
seconds ago
a minute ago
minutes ago
an hour ago
hours ago
a day ago
days ago
about
false
Invalid characters found
/customer/portal/articles/autocomplete
9283