How to get proportion in R by comparing columns?

[spatra1992]

Hi,

I am stuck in a situation and the task is that I need to calculate proportion by comparing two columns.

The sample code is given below:

Fir <- glm(Drop_yn ~ Community + Age + Gender
+ Time_aus + Postcode_SEIFA + Edu_combine + Country_Q + Employ_comb +
House_cat + BMI_cate1 + WHtR_yn + High_BP + Weight_pc_cate
+ Chronic_con ,data = A2, family = "binomial",
control = list(maxit = 100))

From the above code it can be said that Drop_yn is the response variable and where the others are explanatory variables.

Drop_yn has two levels: Complete and DropOut.

The thing what I need to find out is that:

Depending on community which community has the highest percentage of Dropout.
What is the highest percentage of drop out depending on the increase or decrease in Age.

If any one gives me idea regarding how to solve the above queries will be very helpful.

Regards
Saikat

[jrkrideau]

We need a reproducible example (reprex)

FAQ: What's a reproducible example (`reprex`) and how do I create one?

Why reprex? Getting unstuck is hard. Your first step here is usually to create a reprex, or reproducible example. The goal of a reprex is to package your code, and information about your problem so that others can run it and feel your pain. Then, hopefully, folks can more easily provide a solution. What's in a Reproducible Example? Parts of a reproducible example: background information - Describe what you are trying to do. What have you already done? complete set up - include any library() calls and data to reproduce your issue. data for a reprex: Here's a discussion on setting up data for a reprex make it run - include the minimal code required to reproduce your error on the data…