Question: cross-tabulation analysis along with a chi-square test using the raw data as follows: (1) Use the employee data.xls data and create contingency table using gender
cross-tabulation analysis along with a chi-square test using the raw data as follows: (1) Use the "employee data.xls" data and create contingency table using gender (1: male, 0: female) as an independent variable and job category (1: clerical, 2: custodial, 3: manager) as a dependent variable. The table should present both observed frequency and column percentage for each cell. (2) Calculate expected frequencies for each cell. (3) Use Excel to perform the chi-square test if job type allocations are different between male and female employees. Interpret the results.
| gender | jobcat |
| m | 3 |
| m | 1 |
| f | 1 |
| f | 1 |
| m | 1 |
| m | 1 |
| m | 1 |
| f | 1 |
| f | 1 |
| f | 1 |
| f | 1 |
| m | 1 |
| m | 1 |
| f | 1 |
| m | 1 |
| m | 1 |
| m | 1 |
| m | 3 |
| m | 1 |
| f | 1 |
| f | 1 |
| m | 1 |
| f | 1 |
| f | 1 |
| f | 1 |
| m | 1 |
| m | 3 |
| m | 1 |
| m | 3 |
| m | 1 |
| m | 1 |
| m | 3 |
| m | 1 |
| m | 3 |
| m | 3 |
| f | 1 |
| m | 1 |
| m | 1 |
| m | 1 |
| f | 1 |
| f | 1 |
| m | 1 |
| m | 1 |
| m | 1 |
| m | 2 |
| f | 1 |
| f | 1 |
| m | 2 |
| m | 1 |
| m | 3 |
| m | 1 |
| m | 1 |
| m | 3 |
| m | 1 |
| m | 1 |
| m | 1 |
| m | 1 |
| f | 1 |
| m | 1 |
| m | 1 |
| m | 1 |
| m | 3 |
| m | 3 |
| m | 3 |
| m | 1 |
| m | 3 |
| m | 3 |
| m | 3 |
| m | 3 |
| m | 1 |
| m | 3 |
| f | 1 |
| f | 1 |
| f | 1 |
| f | 1 |
| f | 1 |
| f | 1 |
| f | 1 |
| f | 1 |
| f | 1 |
| f | 1 |
| f | 1 |
| f | 1 |
| f | 1 |
| m | 1 |
| m | 1 |
| m | 1 |
| m | 3 |
| m | 3 |
| f | 1 |
| f | 1 |
| f | 1 |
| f | 1 |
| f | 1 |
| f | 1 |
| m | 2 |
| m | 1 |
| m | 2 |
| f | 1 |
| m | 3 |
| m | 3 |
| m | 1 |
| m | 3 |
| m | 1 |
| m | 1 |
| m | 3 |
| f | 1 |
| f | 1 |
| m | 1 |
| m | 1 |
| m | 2 |
| m | 2 |
| m | 3 |
| m | 1 |
| m | 1 |
| m | 1 |
| f | 1 |
| f | 1 |
| f | 1 |
| f | 3 |
| f | 1 |
| f | 1 |
| f | 1 |
| f | 1 |
| m | 1 |
| m | 2 |
| m | 2 |
| f | 1 |
| m | 3 |
| m | 3 |
| m | 1 |
| m | 1 |
| m | 1 |
| f | 3 |
| f | 1 |
| m | 1 |
| m | 3 |
| m | 1 |
| f | 1 |
| f | 1 |
| f | 1 |
| f | 1 |
| f | 1 |
| f | 1 |
| m | 1 |
| m | 1 |
| m | 1 |
| f | 1 |
| m | 1 |
| m | 1 |
| m | 3 |
| m | 2 |
| f | 1 |
| f | 1 |
| m | 1 |
| m | 1 |
| f | 1 |
| f | 1 |
| f | 1 |
| m | 3 |
| m | 1 |
| m | 3 |
| m | 1 |
| f | 1 |
| f | 1 |
| f | 1 |
| f | 1 |
| f | 3 |
| m | 1 |
| m | 1 |
| m | 1 |
| f | 1 |
| m | 3 |
| m | 2 |
| m | 1 |
| f | 1 |
| f | 1 |
| f | 1 |
| m | 1 |
| f | 1 |
| f | 1 |
| f | 1 |
| m | 1 |
| m | 1 |
| m | 2 |
| m | 1 |
| m | 3 |
| f | 1 |
| f | 1 |
| f | 1 |
| f | 1 |
| m | 1 |
| f | 1 |
| f | 1 |
| f | 1 |
| f | 1 |
| m | 3 |
| m | 3 |
| m | 3 |
| m | 3 |
| m | 1 |
| m | 1 |
| m | 1 |
| m | 1 |
| m | 3 |
| m | 2 |
| m | 1 |
| f | 1 |
| f | 1 |
| m | 1 |
| m | 1 |
| m | 1 |
| m | 2 |
| f | 1 |
| f | 1 |
| m | 1 |
| m | 1 |
| m | 1 |
| m | 1 |
| m | 1 |
| f | 1 |
| f | 1 |
| f | 1 |
| f | 1 |
| f | 1 |
| f | 1 |
| f | 1 |
| f | 1 |
| f | 1 |
| m | 1 |
| m | 3 |
| m | 3 |
| m | 1 |
| m | 1 |
| m | 3 |
| f | 1 |
| f | 1 |
| f | 1 |
| f | 1 |
| f | 3 |
| f | 1 |
| f | 1 |
| f | 1 |
| f | 1 |
| f | 1 |
| f | 1 |
| f | 1 |
| f | 1 |
| f | 1 |
| f | 1 |
| f | 1 |
| m | 1 |
| f | 1 |
| m | 3 |
| m | 2 |
| m | 3 |
| m | 3 |
| m | 1 |
| f | 1 |
| f | 1 |
| f | 1 |
| f | 1 |
| f | 1 |
| f | 1 |
| f | 1 |
| f | 1 |
| f | 1 |
| m | 1 |
| m | 1 |
| m | 1 |
| m | 1 |
| m | 1 |
| m | 2 |
| m | 3 |
| m | 1 |
| m | 3 |
| f | 3 |
| f | 1 |
| f | 1 |
| f | 1 |
| m | 2 |
| m | 1 |
| m | 3 |
| m | 3 |
| m | 2 |
| m | 3 |
| m | 1 |
| m | 3 |
| m | 3 |
| m | 3 |
| m | 2 |
| m | 1 |
| m | 1 |
| m | 1 |
| m | 1 |
| m | 1 |
| f | 1 |
| f | 1 |
| f | 1 |
| m | 1 |
| m | 1 |
| m | 1 |
| m | 2 |
| f | 1 |
| m | 2 |
| m | 1 |
| m | 3 |
| m | 1 |
| m | 1 |
| m | 1 |
| f | 1 |
| f | 1 |
| f | 1 |
| f | 1 |
| f | 1 |
| m | 1 |
| m | 1 |
| m | 3 |
| m | 1 |
| m | 1 |
| f | 1 |
| f | 1 |
| f | 1 |
| f | 1 |
| f | 1 |
| m | 2 |
| m | 1 |
| m | 3 |
| m | 3 |
| m | 1 |
| f | 1 |
| f | 1 |
| f | 1 |
| f | 1 |
| m | 2 |
| m | 3 |
| f | 1 |
| f | 1 |
| f | 1 |
| f | 1 |
| m | 3 |
| f | 1 |
| m | 3 |
| m | 1 |
| f | 1 |
| f | 1 |
| f | 1 |
| f | 3 |
| f | 1 |
| f | 1 |
| f | 1 |
| f | 1 |
| m | 2 |
| f | 1 |
| m | 1 |
| m | 1 |
| f | 1 |
| f | 1 |
| f | 1 |
| f | 1 |
| f | 1 |
| f | 1 |
| m | 1 |
| f | 1 |
| f | 1 |
| f | 1 |
| f | 1 |
| f | 1 |
| m | 1 |
| f | 1 |
| f | 3 |
| m | 1 |
| m | 1 |
| m | 1 |
| m | 1 |
| m | 1 |
| m | 1 |
| f | 1 |
| f | 1 |
| f | 1 |
| m | 1 |
| m | 1 |
| m | 3 |
| f | 1 |
| m | 2 |
| m | 2 |
| m | 3 |
| m | 1 |
| m | 3 |
| f | 1 |
| f | 1 |
| f | 1 |
| f | 1 |
| f | 1 |
| f | 1 |
| f | 1 |
| f | 1 |
| f | 1 |
| f | 1 |
| f | 1 |
| f | 1 |
| f | 1 |
| f | 1 |
| f | 1 |
| f | 1 |
| m | 3 |
| m | 1 |
| m | 3 |
| m | 1 |
| f | 1 |
| f | 1 |
| f | 1 |
| f | 3 |
| m | 2 |
| m | 1 |
| m | 1 |
| m | 1 |
| m | 1 |
| m | 1 |
| m | 3 |
| m | 1 |
| m | 1 |
| f | 1 |
| f | 1 |
| f | 1 |
| m | 1 |
| m | 1 |
| m | 1 |
| m | 2 |
| m | 3 |
| m | 3 |
| m | 1 |
| m | 1 |
| m | 1 |
| m | 1 |
| m | 1 |
| m | 1 |
| m | 1 |
| f | 1 |
| f | 1 |
| f | 1 |
| f | 1 |
| f | 1 |
| f | 1 |
| m | 1 |
| m | 3 |
| m | 1 |
| f | 1 |
| m | 3 |
| m | 3 |
| m | 1 |
| m | 1 |
| m | 1 |
| m | 3 |
| m | 3 |
| m | 3 |
| m | 1 |
| m | 3 |
| f | 1 |
| f | 1 |
| f | 1 |
| f | 3 |
| f | 1 |
| m | 3 |
| m | 1 |
| f | 1 |
| f | 1 |
| f | 3 |
| f | 1 |
| m | 1 |
| m | 1 |
| m | 1 |
| f | 1 |
| f | 1 |
Step by Step Solution
There are 3 Steps involved in it
To conduct a crosstabulation analysis along with a chisquare test using the provided raw data we need to follow several steps Ill guide you through ea... View full answer
Get step-by-step solutions from verified subject matter experts
Study Help