Hi -- I have data on whether or not farmers plant different kinds of crops; each crop is a dummy variable (yes or no). The crops are not mutually exclusive; farmers can and most do plant more than one. Is there an easy way to make a two-way table that shows, in each cell, the percent of respondents that plant each possible pair of crops. For instance: (these aren't the actual crops):
Apples Pears Oranges Grapes
Apples 100% 25% 35% 60%
Pears 100% 40% 25%
Oranges 100% 40%
Grapes 100%
And, ideally, code also for exporting the table into excel...
Related Posts with making a two-way table for dummy variable overlap frequencies
Help to generate a new variable using 2 existing variablesHi all First, let me say I am a 4th-year psychology student doing her Honours thesis, I am NOT a st…
Generating confidence intervals using a line graphI have run a difference-in-difference regression and want to make a line graph to illustrate my resu…
Looping year codesHi all, I'm currently having the same codes for multiple years (2000-2007), and I was wondering if t…
Generate binary variable from string variable contentsIs there a way to generate a variable based on a string variable that contains numbers in a list? Fo…
BRFSS weighting data post 2011After cleaning the BRFSS data for sample ranging from 2005-2015 I need to append the data. But, befo…
Subscribe to:
Post Comments (Atom)
0 Response to making a two-way table for dummy variable overlap frequencies
Post a Comment