i would like to create this variable:

piracy rate$/1-$piracy rate

either in an Excel sheet or directly in R$,$ programing, then you take the log of it$.$

to produce a table like table $4$ which is attached with exact information in R programming. can you provide me the steps both in R programming and excel.

my data are as follows:

I need first to create the variables mentioned on top of column $3$ and $4$ of the table attached. I need a ligestic regression which is used only if the dependent variable takes a binary value $(0,1).$ So how can i do that.

PIR COL INC COST INT

PIR $(45,30,40,75,95,15,20,60,92,40,15,20,50,70,95,75,85,40,40,40,25,15,20,60,45,50),$

COL $(54,62,77,87,92,65,75,52,86,46,24,82,74,70,86,84,68,62,80,35,49,29,32,80,63,88),$

INC $(6841,4641,5441,2275,1795,14162,25455,493,1060,16675,21395\mathrm{.}14936,4810,3720,520,2379,1208,7562,27532,4201,18050,33664,46553,3000,2946,2977$

COST $(8\mathrm{.}5,2\mathrm{.}4,14\mathrm{.}7,5\mathrm{.}9,10\mathrm{.}5,8\mathrm{.}2,6\mathrm{.}9,222\mathrm{.}3,386\mathrm{.}2,34\mathrm{.}1,3\mathrm{.}9,4\mathrm{.}5,2,10,45\mathrm{.}8,29\mathrm{.}7,103\mathrm{.}7,0,1\mathrm{.}9,61\mathrm{.}6,10\mathrm{.}7,7\mathrm{.}6,3\mathrm{.}9,1\mathrm{.}4,5\mathrm{.}4,46\mathrm{.}9),$

INT $(112,82,237,46,41,154,430,15,37,301,352,551,319,98,10,93,44,61,504,68,156,573,351,77,72,50)$