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.

i keep on having these errors message and would like to fix:

$>$ expression paste$("$Log$\_$Piracy$\_$Ratio $=$ log$(",$ "Piracy$\_$Ratio", $")",$ sep $="")$

$>$ print$($expression$)$

$[1]$ "Log$\_$Piracy$\_$Ratio $=$ log$($Piracy$\_$Ratio$)"$

$>$ Piracy$\_$Ratio PIR $/(1-$ PIR$)$

$>$ Log$\_$Piracy$\_$Ratio log$($Piracy$\_$Ratio$)$

Warning message:

In log$($Piracy$\_$Ratio$)$ : NaNs produced

$>$ model glm$($PIR ~ COL $+$ INC $+$ COST $+$ INT, family $=$ binomial$)$

Error in eval$($family$initialize$)$ : y values must be y

how can we fix this using R programming.

You need to create the variable mentioned on top of columns $3$ and $4$ FIRST, then you can proceed using the regression. NOTE: Logit or logistic regression is used ONlY if the dependent variable takes a binary value $(0,1),$ which is NOT the case here!

my data are as follows:

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)$