I'm a doctor writing a thesis (about multidrug-resistant bacteria) - meaning I'm a beginner in rstudio I'd like to create a cochrane armitage test in rstudio. the data is relatively simple:

There is a function to perform a Cochrane Amitrage Test in the {DescTools} package.

Perform a Cochran Armitage test for trend in binomial proportions across the levels of a single variable. This test is appropriate only when one variable has two levels and the other variable is ordinal. The two-level variable represents the response, and the other represents an explanatory variable with ordered levels. The null hypothesis is the hypothesis of no trend, which means that the binomial proportion is the same for all levels of the explanatory variable.

The CochranArmitageTest() function takes as its argument a contingency table or a matrix. The example given is

CochranArmitageTest(dose)
#>
#> Cochran-Armitage test for trend
#>
#> data: dose
#> Z = -1.8856, dim = 4, p-value = 0.05935
#> alternative hypothesis: two.sided
CochranArmitageTest(dose, alternative="one.sided")
#>
#> Cochran-Armitage test for trend
#>
#> data: dose
#> Z = -1.8856, dim = 4, p-value = 0.02967
#> alternative hypothesis: one.sided

^{Created on 2023-12-15 with reprex v2.0.2}

Your data's variable year is the only candidate as the treatment, or explanatory, variable, meaning that the proportions of binary outcomes 0 and 1 are some function of the calendar year in which they are observed. The test provides evidence on whether the outcomes differ from random at some level of confidence.

There's an implicit assumption in selecting year that all observations within a calendar year are treated the same, such that 2021-01-01 and 2021-12-31 are the same and 2021-12-31 and 2023-01-01 are different even though many days elapse in the former and ony a single day in the later.

In working with R it is rewarding to begin at a higher level of generality by defining the question to be put to the data, imagining the form of the answer and only then looking for a specific function.

A homely example is the hapless woodworker who walks into a hardware store to ask "what chainsaw should I use on my mahogeny?" The clerk asks "how big is your log?" The customer answers "I have two planks." Clerk: "And what is it you want to do with the planks?" Customer: "Join them." Clerk: "Like to make a tabletop?" Customer: "Yeah, I want to stick them together now that I have them cut to the same size and planed." Clerk: "I suggest a biscuit cutter."