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
Step: 1
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...
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Intermediate Algebra Functions & Authentic Applications
Authors: Jay Lehmann
5th Edition
0321923464, 9780321923462
