Math 10 - Lab 3 – Cross-tabulation and Two Way Tables & Discrete Random Variables Key for Lab 3 Open the Minitab file popular.mpjfrom the website Here is a description of the data collected from elementary schools in Michigan: 1. Gender: (Boy, Girl) 2. Grade: 4, 5 or 6 3. Age: Age in years 4. Ethnicity: White, Other (Yes, that was the way it was reported when this data was collected!) 5. Location: Rural, Suburban, Urban 6. School: 1=Brentwood Elementary, 2=Brentwood Middle, 3=Ridge, 4=Sand, 5=Eureka 6=Brown, 7=Main, 8=Portage, 9=Westdale Middle 7. Goals: Student's choice in the personal goals: 1=Make Good Grades, 2=Be Popular, 3=Be Good in Sports 8. Grades: Rank of "make good grades" (1=most important for popularity, 4=least important) 9. Sports: Rank of "being good at sports" (1=most important for popularity, 4=least important) 10. Looks: Rank of "being handsome or pretty" (1=most important for popularity, 4=least important) 11. Money: Rank of "having lots of money" (1=most important for popularity, 4=least important) Cross Tabulation is a method of taking pairs of categorical variables and creating a two-way table. The command can be found on the menu barSTAT>TABLES>CROSSTABULATION. Choose two data items and check that you want count, row percentsand column percents. You can also make a clustered bar graph GRAPHS>BAR GRAPH>CLUSTERED. The example shows gender cross-tabulated with grade level: There are three questions with parts on the next three pages. Be sure to answer them all.