Organize Group Roles Data Analysis

  work in a group to move from messy raw data about ice-cream preferences to a simple percent table, also known as a crosstabulation (crosstab). The table should explore a relationship between variables you identify in the data. Your final table should look something like the example attached. You will produce the percent table together as a group, but I expect you to create the write-up individually.

1. Read the assignment together and then take a few minutes to organize group roles. Make a plan to complete the work as a group. What will you agree to do up front? Who will manage communication? Who has everyone’s email so you can follow up with the group after class? How will decisions be made about variables and categories? Will you limit discussion time to make the best use of online time together (recommended)? Who will take notes? Will a smaller subgroup produce the final percent table?
2. As a group, examine the raw data provided by previous students enrolled in Sociology123. It is available as an excel file. If you don’t know how to use excel to sort the data, consider watching the video attached below.
3. Choose two variables. Be careful here. Fewer categories are your friend! Seriously I cannot emphasize this enough. Feel free to check in with me about the categories. In your individual write-up explain your thinking in sentences and be sure to answer these questions explicitly: [a] How many cases are there? [b] What variables are in the data? [c] Are there differences/problems with the way the variables are described across different cases? Missing data? What are they? [d] How did you decide what data to use and what variables to construct? [e] How do you think your variables are related? What is your logic? Is it non-trivial? What information is lost when you recode and reduce the data? Is anything gained? [f] Which is the independent variable and which one is the dependent variable?
4. For you own use, create a table that describes the relationship between the two variables your group has chosen. Using excel or counting by hand, identify the cell of the table into which each case falls. In other words, make sure you know how many cases there are in each cell. The, consider how your coding is working. Do you need to go back and recode the variables so there are few categories? (FYI fewer categories are your friend and will make your table far easier to read and understand. Beware small cell sizes produced by too many categories in your variables!)
5. Convert the counts in the cells of the table into percentages (this is the final and only table I want to see). Make sure your table is percentaged in the right direction. Even experienced analysts make mistakes here. Check and recheck. The 100% should be correspond to categories of the independent variable.
6. Write a couple of sentences describing what relationship, if any, your table describes.
7. Submit the final percent table and your answers on moodle. In your write-up, make sure to answer all the questions and complete all the tasks above from #3 to #7. Also make sure to name all your group members on your individual write-up and say what roles people played in creating the table. And don’t forget your name! NOTE: Could you take a look at the example table above in the Google doc and see if you could try and calculate the percentages based on our data? That would be great. As that is needed. Also i need u to answer all questions for #3 and add all your group members on your individual write-up and say what roles people played in creating the table. And don’t forget your name as well (see #7). Also, submit the official table that includes the percentages (see #5) and make sure to write up for #6  
8. https://drive.google.com/drive/folders/1zklfYXrznK… here are the other materials