I have two columns, column one shows the number of people who reported eating 5 fruits a day, column two shows the number of people who reported eating 5 fruits a day after the second test. Both these values are from a random sample of the population.
I would like to return both the rate of people who started eating 5 fruits a day between test 1 and test 2 and the confidence interval. I always assumed calculating the CI requires the mean and standard deviation, but not sure what the mean would be in the scenario
Here is a sample of my data
test1 test2 no yes no yes no no yes yes yes yes no no yes yes no no yes yes no no no no no no