<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />So, I have this big table. I am only interested in looking at incidence of infection (number of infections / total days of admission per age group ) and determining if there was a difference between the pre and post intervention group. What analysis should I be using.
The second table attached is the simplified version: (Total number of infections, total admissions days and Incidence of infection per 100 days of admission) distributed per age group.
Any suggestion/ help is much appreciated.
| Admission days | Age group | number of infections | Intervention group |
| 2 | a | 0 | Post |
| 31 | a | 1 | Post |
| 5 | a | 0 | Post |
| 31 | a | 1 | Post |
| 5 | a | 0 | Post |
| 30 | a | 0 | Post |
| 29 | a | 1 | Post |
| 2 | a | 0 | Post |
| 30 | a | 0 | Post |
| 5 | a | 0 | Post |
| 4 | a | 0 | Post |
| 3 | a | 0 | Post |
| 3 | a | 0 | Post |
| 10 | a | 0 | Post |
| 9 | a | 0 | Post |
| 13 | a | 1 | Post |
| 2 | a | 0 | Post |
| 2 | a | 0 | Post |
| 2 | a | 0 | Post |
| 11 | a | 0 | Post |
| 12 | a | 0 | Post |
| 4 | a | 0 | Post |
| 5 | a | 1 | Post |
| 22 | a | 0 | Post |
| 7 | a | 0 | Post |
| 13 | a | 1 | Post |
| 5 | a | 0 | Post |
| 2 | a | 0 | Post |
| 2 | a | 0 | Post |
| 12 | a | 0 | Post |
| 4 | a | 0 | Post |
| 3 | a | 0 | Post |
| 2 | a | 0 | Post |
| 7 | a | 0 | Post |
| 4 | a | 0 | Post |
| 5 | a | 0 | Post |
| 2 | a | 0 | Post |
| 13 | a | 1 | Post |
| 5 | a | 0 | Post |
| 3 | a | 0 | Post |
| 7 | a | 0 | Post |
| 4 | a | 0 | Post |
| 2 | a | 0 | Post |
| 3 | a | 0 | Post |
| 4 | a | 0 | Post |
| 3 | a | 0 | Post |
| 3 | a | 0 | Post |
| 3 | a | 0 | Post |
| 5 | a | 0 | Post |
| 11 | b | 0 | Post |
| 3 | b | 0 | Post |
| 8 | b | 0 | Post |
| 3 | b | 0 | Post |
| 4 | b | 0 | Post |
| 3 | b | 0 | Post |
| 3 | b | 0 | Post |
| 7 | b | 0 | Post |
| 3 | b | 0 | Post |
| 4 | b | 0 | Post |
| 2 | b | 0 | Post |
| 3 | b | 0 | Post |
| 3 | b | 0 | Post |
| 2 | b | 0 | Post |
| 4 | b | 0 | Post |
| 6 | b | 0 | Post |
| 4 | b | 0 | Post |
| 4 | b | 0 | Post |
| 6 | b | 0 | Post |
| 4 | b | 0 | Post |
| 3 | b | 0 | Post |
| 4 | b | 0 | Post |
| 5 | b | 0 | Post |
| 7 | b | 0 | Post |
| 2 | b | 0 | Post |
| 7 | b | 0 | Post |
| 3 | b | 0 | Post |
| 4 | b | 0 | Post |
| 3 | b | 0 | Post |
| 4 | b | 0 | Post |
| 2 | b | 0 | Post |
| 5 | b | 0 | Post |
| 15 | b | 0 | Post |
| 4 | b | 0 | Post |
| 9 | b | 0 | Post |
| 4 | c | 0 | Post |
| 4 | c | 0 | Post |
| 2 | c | 0 | Post |
| 4 | c | 0 | Post |
| 3 | c | 0 | Post |
| 3 | c | 0 | Post |
| 4 | c | 0 | Post |
| 5 | c | 0 | Post |
| 3 | c | 0 | Post |
| 3 | c | 0 | Post |
| 5 | c | 0 | Post |
| 35 | c | 0 | Post |
| 7 | c | 0 | Post |
| 12 | c | 0 | Post |
| 8 | c | 1 | Post |
| 48 | c | 0 | Post |
| 20 | c | 0 | Post |
| 3 | c | 0 | Post |
| 2 | c | 0 | Post |
| 3 | d | 0 | Post |
| 5 | d | 0 | Post |
| 2 | d | 0 | Post |
| 3 | d | 0 | Post |
| 4 | d | 0 | Post |
| 4 | d | 0 | Post |
| 12 | d | 0 | Post |
| 2 | d | 0 | Post |
| 5 | d | 0 | Post |
| 3 | d | 0 | Post |
| 11 | d | 0 | Post |
| 5 | d | 0 | Post |
| 4 | d | 0 | Post |
| 2 | d | 0 | Post |
| 21 | d | 0 | Post |
| 3 | d | 0 | Post |
| 3 | d | 0 | Post |
| 5 | d | 0 | Post |
| 3 | d | 0 | Post |
| 6 | d | 0 | Post |
| 4 | d | 0 | Post |
| 3 | d | 0 | Post |
| 5 | d | 0 | Post |
| 14 | d | 1 | Post |
| 3 | d | 0 | Post |
| 3 | d | 0 | Post |
| 2 | d | 0 | Post |
| 3 | d | 0 | Post |
| 2 | d | 0 | Post |
| 5 | d | 0 | Post |
| 3 | d | 0 | Post |
| 5 | d | 0 | Post |
| 6 | d | 0 | Post |
| 4 | d | 0 | Post |
| 2 | d | 0 | Post |
| 5 | d | 0 | Post |
| 2 | d | 0 | Post |
| 34 | d | 1 | Post |
| 6 | a | 0 | Pre |
| 34 | a | 0 | Pre |
| 31 | a | 0 | Pre |
| 17 | a | 1 | Pre |
| 28 | a | 0 | Pre |
| 16 | a | 1 | Pre |
| 4 | a | 1 | Pre |
| 5 | a | 0 | Pre |
| 6 | a | 0 | Pre |
| 2 | a | 0 | Pre |
| 6 | a | 0 | Pre |
| 2 | a | 0 | Pre |
| 16 | a | 1 | Pre |
| 5 | a | 0 | Pre |
| 12 | a | 0 | Pre |
| 2 | a | 0 | Pre |
| 6 | a | 0 | Pre |
| 2 | a | 0 | Pre |
| 9 | a | 0 | Pre |
| 4 | a | 0 | Pre |
| 2 | a | 0 | Pre |
| 6 | a | 0 | Pre |
| 2 | a | 0 | Pre |
| 3 | a | 0 | Pre |
| 4 | a | 0 | Pre |
| 2 | a | 0 | Pre |
| 5 | a | 0 | Pre |
| 5 | a | 0 | Pre |
| 3 | a | 0 | Pre |
| 2 | a | 0 | Pre |
| 4 | a | 0 | Pre |
| 6 | a | 0 | Pre |
| 4 | a | 0 | Pre |
| 2 | a | 0 | Pre |
| 4 | a | 0 | Pre |
| 2 | a | 0 | Pre |
| 3 | a | 0 | Pre |
| 5 | a | 0 | Pre |
| 5 | a | 0 | Pre |
| 35 | a | 1 | Pre |
| 8 | a | 0 | Pre |
| 29 | a | 1 | Pre |
| 8 | a | 0 | Pre |
| 12 | a | 0 | Pre |
| 4 | a | 0 | Pre |
| 5 | a | 0 | Pre |
| 9 | a | 0 | Pre |
| 4 | a | 0 | Pre |
| 2 | a | 0 | Pre |
| 5 | a | 0 | Pre |
| 6 | a | 0 | Pre |
| 3 | a | 0 | Pre |
| 5 | a | 0 | Pre |
| 5 | a | 0 | Pre |
| 3 | a | 0 | Pre |
| 3 | a | 0 | Pre |
| 2 | a | 0 | Pre |
| 4 | a | 0 | Pre |
| 15 | a | 0 | Pre |
| 4 | a | 0 | Pre |
| 4 | a | 0 | Pre |
| 5 | b | 0 | Pre |
| 14 | b | 1 | Pre |
| 10 | b | 1 | Pre |
| 5 | b | 0 | Pre |
| 2 | b | 0 | Pre |
| 5 | b | 0 | Pre |
| 8 | b | 0 | Pre |
| 5 | b | 0 | Pre |
| 3 | b | 0 | Pre |
| 2 | b | 0 | Pre |
| 4 | b | 0 | Pre |
| 4 | b | 0 | Pre |
| 3 | b | 0 | Pre |
| 5 | b | 0 | Pre |
| 4 | b | 0 | Pre |
| 4 | b | 0 | Pre |
| 4 | b | 0 | Pre |
| 4 | b | 0 | Pre |
| 8 | b | 0 | Pre |
| 3 | b | 0 | Pre |
| 3 | b | 0 | Pre |
| 4 | b | 0 | Pre |
| 9 | b | 0 | Pre |
| 4 | b | 0 | Pre |
| 3 | b | 0 | Pre |
| 5 | b | 0 | Pre |
| 4 | b | 0 | Pre |
| 5 | c | 0 | Pre |
| 3 | c | 0 | Pre |
| 4 | c | 0 | Pre |
| 2 | c | 0 | Pre |
| 4 | c | 0 | Pre |
| 2 | c | 0 | Pre |
| 3 | c | 0 | Pre |
| 5 | c | 0 | Pre |
| 4 | c | 1 | Pre |
| 4 | c | 0 | Pre |
| 3 | c | 0 | Pre |
| 3 | c | 0 | Pre |
| 15 | c | 1 | Pre |
| 29 | c | 2 | Pre |
| 5 | c | 0 | Pre |
| 19 | c | 1 | Pre |
| 4 | c | 0 | Pre |
| 5 | c | 0 | Pre |
| 3 | c | 0 | Pre |
| 4 | c | 0 | Pre |
| 6 | c | 0 | Pre |
| 4 | c | 0 | Pre |
| 4 | c | 0 | Pre |
| 3 | c | 0 | Pre |
| 3 | c | 0 | Pre |
| 3 | c | 0 | Pre |
| 2 | c | 0 | Pre |
| 2 | c | 0 | Pre |
| 9 | c | 0 | Pre |
| 4 | c | 0 | Pre |
| 11 | c | 1 | Pre |
| 2 | c | 0 | Pre |
| 5 | c | 0 | Pre |
| 2 | c | 0 | Pre |
| 3 | c | 0 | Pre |
| 3 | c | 0 | Pre |
| 3 | c | 0 | Pre |
| 2 | c | 0 | Pre |
| 2 | c | 0 | Pre |
| 4 | c | 0 | Pre |
| 3 | c | 0 | Pre |
| 4 | c | 0 | Pre |
| 3 | c | 0 | Pre |
| 4 | c | 0 | Pre |
| 3 | c | 0 | Pre |
| 3 | c | 0 | Pre |
| 3 | c | 0 | Pre |
| 3 | c | 0 | Pre |
| 5 | d | 0 | Pre |
| 7 | d | 1 | Pre |
| 4 | d | 0 | Pre |
| 4 | d | 0 | Pre |
| 4 | d | 0 | Pre |
| 7 | d | 1 | Pre |
| 3 | d | 0 | Pre |
| 8 | d | 1 | Pre |
| 2 | d | 0 | Pre |
| 2 | d | 0 | Pre |
| 3 | d | 0 | Pre |
| 3 | d | 0 | Pre |
| 5 | d | 0 | Pre |
| 3 | d | 0 | Pre |
| 3 | d | 0 | Pre |
| 2 | d | 0 | Pre |
| 3 | d | 0 | Pre |
| 4 | d | 0 | Pre |
| 6 | d | 0 | Pre |
| 5 | d | 0 | Pre |
| 15 | d | 1 | Pre |
| 4 | d | 0 | Pre |
| 4 | d | 0 | Pre |
| 4 | d | 1 | Pre |
| 6 | d | 0 | Pre |
| 3 | d | 0 | Pre |
| 5 | d | 0 | Pre |
| 8 | d | 0 | Pre |
| 3 | d | 0 | Pre |
| 3 | d | 0 | Pre |
| 7 | d | 0 | Pre |
| 5 | d | 0 | Pre |
| 2 | d | 0 | Pre |
| 3 | d | 0 | Pre |
| 3 | d | 0 | Pre |
| 4 | d | 0 | Pre |
| 5 | d | 0 | Pre |
| 4 | d | 0 | Pre |
| 2 | d | 0 | Pre |
| 23 | d | 0 | Pre |
| 7 | d | 0 | Pre |
| 4 | d | 0 | Pre |
| 5 | d | 0 | Pre |
| 3 | d | 0 | Pre |
| 2 | d | 0 | Pre |
| 2 | d | 0 | Pre |
| 18 | d | 3 | Pre |
| 18 | d | 1 | Pre |
| 7 | d | 0 | Pre |
| 6 | d | 0 | Pre |
| 5 | d | 0 | Pre |
| 2 | d | 0 | Pre |
| 4 | d | 0 | Pre |
| Number of Infections | Admission days | Group | Age group | ID (infection/100 admission days) |
| 6 | 457 | Pre | a | 1.3129 |
| 2 | 134 | Pre | b | 1.4925 |
| 6 | 229 | Pre | c | 2.6201 |
| 9 | 279 | Pre | d | 3.2258 |
| 7 | 395 | Post | a | 1.7721 |
| 0 | 164 | Post | b | 0.0000 |
| 1 | 175 | Post | c | 0.5714 |
| 2 | 211 | Post | d | 0.0095 |
