Please use Microsoft Excel in answering thank you :)

3. The following sample shows 30 observations involving two hypothetical qualitative variables x and y! The categories for x are A, B, and C; the categories for y are 1 and 2. Develop a crosstabulation for the data. Observation X y Observation X Y Observation X Y 21 C 2 A 1I A 12 B 22 B N B C 2 CI 2 C A IN C 2 25 B B 2 26 C 2 C 27 C B 28 A 29 B B 30 B 2 10