Data Analysis with Excel
karlovstreet
31OCT22FTBUS520DataSetandKey-2.xlsxSURVEY BUS520 31OCT22FT
| Gender | Age | Department | Position | Tenure | Job Satisfaction | Intrinsic | Extrinsic | Commitment | |||
| 1 | 1 | 1 | 2 | 1 | 5.7 | 3.2 | 5.1 | 4.1 | KEY TO SURVEY | ||
| 1 | 1 | 1 | 2 | 1 | 5.7 | 3.2 | 5.1 | 4.1 | |||
| 1 | 1 | 1 | 3 | 1 | 5.7 | 3.1 | 5 | 4.2 | DEMOGRAPHICS | ||
| 1 | 1 | 1 | 3 | 1 | 5.7 | 3.1 | 5 | 4.2 | |||
| 1 | 1 | 2 | 2 | 1 | 5.7 | 3 | 4.9 | 4.3 | Gender | ||
| 1 | 3 | 2 | 2 | 1 | 5.7 | 2.9 | 4.8 | 4.4 | 1 | Male | |
| 1 | 1 | 2 | 3 | 2 | 5.5 | 5.4 | 4.1 | 5.3 | 2 | Female | |
| 1 | 1 | 2 | 1 | 2 | 5.4 | 5.4 | 4.1 | 4.8 | Age | ||
| 1 | 3 | 2 | 3 | 1 | 5.2 | 2.8 | 4.7 | 4.5 | 1 | 16 - 21 | |
| 1 | 1 | 2 | 1 | 1 | 6.6 | 2.7 | 4.6 | 4.6 | 2 | 22 - 49 | |
| 1 | 1 | 1 | 3 | 1 | 6.4 | 2.6 | 4.5 | 4.7 | 3 | 50 - 65 | |
| 1 | 2 | 1 | 1 | 1 | 6.2 | 2.5 | 4.4 | 4.8 | Department | ||
| 1 | 2 | 1 | 1 | 2 | 6 | 2.4 | 4.3 | 4.9 | 1 | Front-Line Worker | |
| 1 | 2 | 2 | 2 | 3 | 5.9 | 3.7 | 5.5 | 4.2 | 2 | Supervisor | |
| 1 | 3 | 3 | 3 | 2 | 5.8 | 2.3 | 4.2 | 5 | 3 | Management | |
| 1 | 2 | 3 | 3 | 2 | 5.6 | 2.2 | 4.1 | 5.1 | Position | ||
| 1 | 1 | 3 | 2 | 2 | 5.4 | 2.1 | 4 | 5.2 | 1 | Hourly Employee Part-time | |
| 1 | 2 | 2 | 2 | 1 | 5.2 | 6 | 3.9 | 5.3 | 2 | Hourly Employee Full-time | |
| 1 | 1 | 3 | 2 | 1 | 5.2 | 5.3 | 5.7 | 6.4 | 3 | Salaried Employee | |
| 1 | 2 | 2 | 1 | 2 | 5.2 | 5.3 | 5.7 | 4.7 | Tenure With Company | ||
| 1 | 2 | 2 | 3 | 1 | 5.2 | 5.3 | 5.7 | 2.3 | 1 | Less than 2 years | |
| 1 | 1 | 3 | 2 | 1 | 5.2 | 5.3 | 5.7 | 2.3 | 2 | 2 to 5 years | |
| 1 | 1 | 3 | 3 | 1 | 5.2 | 5.2 | 4.6 | 5.3 | 3 | Over 5 Years | |
| 1 | 2 | 1 | 1 | 3 | 5.2 | 4.7 | 5.6 | 6.4 | |||
| 1 | 1 | 2 | 1 | 2 | 5.2 | 4.7 | 5.6 | 5.2 | SURVEY MEASURES | ||
| 1 | 3 | 3 | 2 | 1 | 4.9 | 6.4 | 4.6 | 4.2 | |||
| 1 | 3 | 3 | 3 | 2 | 4.9 | 5.4 | 7 | 5.4 | SURVEY MEASURE #1 | ||
| 1 | 3 | 3 | 1 | 1 | 4.9 | 5.3 | 5.7 | 4.7 | OVERALL JOB SATISFACTION (Scale 1-7) | ||
| 1 | 1 | 2 | 2 | 1 | 4.9 | 5.3 | 5.7 | 2.3 | 1 = Least Satisfied | ||
| 1 | 1 | 2 | 2 | 1 | 7 | 5.3 | 5.7 | 2.3 | 7 = Most Satisfied | ||
| 1 | 1 | 1 | 1 | 3 | 4.9 | 5.3 | 2.9 | 5.3 | SURVEY MEASURE #2 | ||
| 1 | 3 | 3 | 1 | 1 | 4.9 | 5.3 | 2.9 | 3.7 | INTRINSIC JOB SATISFACTION (Scale 1-7) | ||
| 1 | 2 | 2 | 2 | 3 | 4.9 | 5.3 | 2.9 | 3.7 | 1= Least Satisfied | ||
| 1 | 1 | 2 | 1 | 1 | 4.9 | 7 | 5.7 | 7 | 7= Most Satisfied | ||
| 1 | 1 | 1 | 1 | 3 | 4.9 | 5.2 | 4.6 | 5.4 | SURVEY MEASURE #3 | ||
| 1 | 3 | 3 | 1 | 1 | 4.9 | 5.2 | 4.6 | 4.2 | EXTRINSIC JOB SATISFACTION (Scale 1-7) | ||
| 1 | 3 | 3 | 3 | 1 | 4.9 | 5.2 | 4.6 | 4.2 | 1 = Least Satisfied | ||
| 1 | 3 | 3 | 2 | 1 | 4.9 | 5.2 | 4.6 | 4.2 | 7 = Most Satisfied | ||
| 1 | 1 | 3 | 2 | 1 | 4.9 | 5.2 | 4.6 | 4.2 | SURVEY MEASURE #4 | ||
| 1 | 3 | 3 | 2 | 1 | 4.9 | 4.7 | 5.6 | 4.7 | ORGANIZATIONAL COMMITMENT (Scale 1-7) | ||
| 1 | 1 | 3 | 2 | 1 | 4.9 | 4.7 | 5.6 | 4.5 | 1= Least Satisfied | ||
| 1 | 1 | 3 | 2 | 1 | 5.2 | 4.7 | 5.6 | 4.5 | 7= Most Satisfied | ||
| 1 | 2 | 2 | 1 | 1 | 5.2 | 4.7 | 5.6 | 4.5 | |||
| 1 | 1 | 3 | 2 | 1 | 5.2 | 4.7 | 5.6 | 4.5 | |||
| 1 | 2 | 2 | 1 | 1 | 5.2 | 4.7 | 5.6 | 4.5 | |||
| 1 | 2 | 1 | 1 | 2 | 5.2 | 4.7 | 5.6 | 4.5 | |||
| 1 | 3 | 2 | 3 | 1 | 5 | 5.9 | 3.8 | 5.4 | |||
| 1 | 1 | 1 | 1 | 3 | 4.9 | 6.4 | 5.5 | 5.4 | |||
| 1 | 3 | 3 | 3 | 2 | 4.9 | 6.4 | 5.5 | 5.4 | |||
| 1 | 1 | 1 | 1 | 3 | 4.9 | 5.3 | 2.9 | 5.3 | |||
| 1 | 3 | 3 | 1 | 1 | 4.9 | 5.3 | 2.9 | 3.7 | |||
| 1 | 2 | 2 | 2 | 3 | 4.9 | 5.3 | 2.9 | 3.7 | |||
| 1 | 1 | 2 | 1 | 1 | 4.9 | 5.2 | 5.7 | 4.2 | |||
| 1 | 1 | 1 | 1 | 3 | 6 | 5.2 | 4.6 | 5.4 | |||
| 1 | 3 | 3 | 1 | 1 | 4.9 | 5.2 | 4.6 | 4.2 | |||
| 1 | 3 | 3 | 3 | 1 | 4.9 | 5.2 | 4.6 | 4.2 | |||
| 1 | 3 | 3 | 2 | 1 | 4.9 | 5.2 | 4.6 | 4.2 | |||
| 1 | 1 | 3 | 2 | 1 | 4.9 | 5.2 | 4.6 | 4.2 | |||
| 1 | 3 | 3 | 2 | 1 | 4.9 | 4.7 | 5.6 | 4.7 | |||
| 1 | 1 | 3 | 2 | 1 | 4.9 | 4.7 | 5.6 | 4.5 | |||
| 1 | 1 | 3 | 1 | 1 | 4.9 | 4.7 | 5.6 | 4.5 | |||
| 1 | 2 | 2 | 3 | 1 | 4.9 | 4.7 | 5.6 | 4.5 | |||
| 1 | 2 | 2 | 2 | 1 | 4.9 | 4.7 | 5.6 | 4.5 | |||
| 1 | 3 | 3 | 2 | 1 | 4.9 | 4.7 | 5.6 | 4.5 | |||
| 1 | 2 | 2 | 2 | 1 | 4.9 | 4.7 | 5.6 | 4.5 | |||
| 1 | 2 | 2 | 2 | 3 | 4.9 | 4.7 | 5.6 | 4.5 | |||
| 1 | 3 | 3 | 2 | 1 | 4.9 | 4.7 | 5.6 | 4.5 | |||
| 1 | 2 | 3 | 1 | 3 | 4.9 | 4.7 | 5.5 | 5.4 | |||
| 1 | 2 | 2 | 2 | 1 | 4.8 | 5.8 | 3.7 | 5.5 | |||
| 1 | 2 | 1 | 1 | 3 | 4.6 | 5.7 | 3.6 | 5.6 | |||
| 1 | 3 | 1 | 1 | 3 | 4.4 | 5.6 | 3.5 | 5.7 | |||
| 1 | 2 | 1 | 2 | 2 | 4.2 | 5.5 | 3.4 | 5.8 | |||
| 1 | 1 | 2 | 3 | 2 | 4 | 5.4 | 3.3 | 5.9 | |||
| 1 | 2 | 2 | 2 | 3 | 3.8 | 5.3 | 3.2 | 6 | |||
| 1 | 1 | 2 | 1 | 1 | 3.6 | 5.2 | 3.1 | 6.1 | |||
| 1 | 1 | 1 | 1 | 3 | 3.4 | 5.1 | 3 | 6.2 | |||
| 1 | 3 | 3 | 1 | 1 | 6 | 6.4 | 5.5 | 3.5 | |||
| 1 | 3 | 3 | 3 | 1 | 3.2 | 5.4 | 5.6 | 5.4 | |||
| 1 | 3 | 3 | 2 | 1 | 3.2 | 5.4 | 4.6 | 4.2 | |||
| 1 | 1 | 3 | 2 | 1 | 3.1 | 5.2 | 4.6 | 4.2 | |||
| 1 | 3 | 3 | 2 | 1 | 3.2 | 5.2 | 4.6 | 4.2 | |||
| 2 | 2 | 2 | 3 | 1 | 5.2 | 5.2 | 2.9 | 2.9 | |||
| 2 | 2 | 2 | 2 | 1 | 5.2 | 4.7 | 3.9 | 6.6 | |||
| 2 | 3 | 3 | 2 | 1 | 6.5 | 5.3 | 2.3 | 6.5 | |||
| 2 | 2 | 2 | 2 | 1 | 6.5 | 4.7 | 6.5 | 2.5 | |||
| 2 | 2 | 2 | 2 | 3 | 5.9 | 5.2 | 4.6 | 4.2 | |||
| 2 | 3 | 3 | 2 | 1 | 5.7 | 6.4 | 5.5 | 3.1 | |||
| 2 | 2 | 3 | 1 | 3 | 5.7 | 6 | 3 | 5 | |||
| 2 | 2 | 2 | 2 | 1 | 5.7 | 6 | 3 | 6.4 | |||
| 2 | 2 | 1 | 1 | 3 | 5.7 | 5.6 | 3.2 | 6.8 | |||
| 2 | 3 | 2 | 3 | 1 | 5.7 | 5.6 | 3.2 | 6.8 | |||
| 2 | 3 | 2 | 1 | 3 | 5.7 | 5.4 | 5.8 | 2.5 | |||
| 2 | 3 | 2 | 2 | 2 | 6 | 5.4 | 3.3 | 4.1 | |||
| 2 | 3 | 2 | 2 | 2 | 5.7 | 5.4 | 3.3 | 4.1 | |||
| 2 | 2 | 2 | 1 | 1 | 5.2 | 4.7 | 3.9 | 3.1 | |||
| 2 | 2 | 1 | 2 | 2 | 5.2 | 4.7 | 3.5 | 2.9 | |||
| 2 | 1 | 1 | 1 | 3 | 5.1 | 5.3 | 6 | 2.5 | |||
| 2 | 3 | 2 | 3 | 1 | 4.9 | 6.4 | 5.5 | 3.5 | |||
| 2 | 2 | 2 | 1 | 3 | 4.2 | 6.4 | 4.8 | 4.7 | |||
| 2 | 3 | 3 | 2 | 1 | 4.9 | 6.4 | 4.6 | 4.2 | |||
| 2 | 2 | 2 | 2 | 3 | 4.9 | 5.4 | 5.6 | 5.4 | |||
| 2 | 1 | 3 | 1 | 1 | 4.9 | 5.3 | 5.5 | 5.2 | |||
| 2 | 1 | 3 | 1 | 3 | 4.9 | 5.3 | 2.9 | 3.7 | |||
| 2 | 2 | 1 | 1 | 2 | 6 | 5.3 | 2.9 | 3.7 | |||
| 2 | 1 | 3 | 2 | 1 | 4.9 | 5.2 | 5.2 | 5.3 | |||
| 2 | 1 | 3 | 1 | 1 | 4.9 | 5.2 | 4.6 | 4.2 | |||
| 2 | 1 | 3 | 2 | 1 | 4.9 | 5.2 | 4.6 | 4.2 | |||
| 2 | 2 | 2 | 2 | 3 | 6 | 5.2 | 4.6 | 4.2 | |||
| 2 | 3 | 1 | 1 | 1 | 4.9 | 4.7 | 5.6 | 4.5 | |||
| 2 | 3 | 3 | 3 | 2 | 4.9 | 4.7 | 5.6 | 4.5 | |||
| 2 | 3 | 3 | 2 | 3 | 4.9 | 4.7 | 5.6 | 4.5 | |||
| 2 | 3 | 2 | 3 | 1 | 4.8 | 6.4 | 2.5 | 6.6 | |||
| 2 | 3 | 3 | 1 | 1 | 4.8 | 5.2 | 5.5 | 2.6 | |||
| 2 | 1 | 2 | 2 | 1 | 4.8 | 3.7 | 5.7 | 6.6 | |||
| 2 | 1 | 2 | 1 | 1 | 4.5 | 4 | 4 | 4.8 | |||
| 2 | 2 | 2 | 2 | 2 | 5 | 1.8 | 5 | 5.8 | |||
| 2 | 3 | 3 | 2 | 2 | 4.4 | 1.6 | 5.2 | 6 | |||
| 2 | 3 | 2 | 1 | 2 | 4.3 | 4.2 | 3.9 | 4.7 | |||
| 2 | 3 | 3 | 1 | 3 | 4.3 | 2 | 4.8 | 5.6 | |||
| 2 | 1 | 1 | 3 | 1 | 4.1 | 4.4 | 3.8 | 4.6 | |||
| 2 | 2 | 2 | 2 | 2 | 4.1 | 1.9 | 4.9 | 5.7 | |||
| 2 | 3 | 3 | 2 | 2 | 3.9 | 5.4 | 6.4 | 2.5 | |||
| 2 | 3 | 2 | 1 | 2 | 3.9 | 4.7 | 6.4 | 2.5 | |||
| 2 | 3 | 3 | 1 | 3 | 3.9 | 4.6 | 3.7 | 4.5 | |||
| 2 | 1 | 1 | 3 | 1 | 3.8 | 5.2 | 5.8 | 6.8 | |||
| 2 | 2 | 3 | 2 | 1 | 3.8 | 5.2 | 2.1 | 6.8 | |||
| 2 | 1 | 1 | 3 | 3 | 3.8 | 4.7 | 2.4 | 2.8 | |||
| 2 | 1 | 3 | 3 | 2 | 3.7 | 4.8 | 3.6 | 4.4 | |||
| 2 | 3 | 2 | 2 | 1 | 3.6 | 5.8 | 3.1 | 4 | |||
| 2 | 3 | 2 | 2 | 1 | 3.6 | 5.8 | 3.1 | 6.6 | |||
| 2 | 1 | 1 | 1 | 2 | 3.5 | 6.4 | 5.4 | 2.8 | |||
| 2 | 3 | 2 | 1 | 1 | 3.5 | 5 | 3.5 | 4.3 | |||
| 2 | 3 | 2 | 1 | 1 | 3.5 | 5 | 3.5 | 4.3 | |||
| 2 | 1 | 1 | 1 | 3 | 3.2 | 4.7 | 4.7 | 4.7 | |||
| 2 | 3 | 3 | 2 | 1 | 3.2 | 2.1 | 4.7 | 5.5 | |||
| 2 | 2 | 1 | 2 | 2 | 2.8 | 5.4 | 2.8 | 3.6 | |||
| 2 | 1 | 1 | 1 | 3 | 2.4 | 5.4 | 4.7 | 4.8 | |||
| 2 | 2 | 2 | 2 | 3 | 2.3 | 5.2 | 5.5 | 3.4 | |||
| 2 | 3 | 2 | 1 | 3 | 2.2 | 5.2 | 2.2 | 6.8 | |||
| 2 | 3 | 2 | 1 | 3 | 2.1 | 5.2 | 3.4 | 4.2 | |||
| 2 | 3 | 2 | 1 | 3 | 2.1 | 5.2 | 3.4 | 4.2 | |||
| 2 | 1 | 3 | 1 | 1 | 1.6 | 1.7 | 5.1 | 5.9 | |||
| 2 | 2 | 1 | 1 | 3 | 5.2 | 6.4 | 5.6 | 7 | |||
| 2 | 2 | 1 | 3 | 1 | 5.2 | 5.4 | 4.1 | 4.8 | |||
| 2 | 2 | 2 | 1 | 1 | 5.2 | 5.2 | 5.8 | 5.2 | |||
| 2 | 2 | 2 | 1 | 1 | 5.2 | 5.2 | 5.8 | 5.2 | |||
| 2 | 1 | 3 | 3 | 3 | 5.2 | 5.2 | 5.7 | 4.2 | |||
| 2 | 2 | 1 | 1 | 2 | 5.2 | 5.2 | 5.4 | 5.4 | |||
| 2 | 3 | 3 | 3 | 3 | 5.2 | 5.2 | 4.5 | 4.5 | |||
| 2 | 2 | 2 | 2 | 1 | 5.2 | 4.7 | 5.6 | 4.5 | |||
| 2 | 2 | 2 | 1 | 1 | 5.2 | 4.7 | 3.9 | 3.1 | |||
| 2 | 2 | 1 | 2 | 2 | 5.2 | 4.7 | 3.5 | 2.9 | |||
| 2 | 1 | 1 | 1 | 3 | 5.1 | 5.3 | 5.2 | 2.5 | |||
| 2 | 3 | 2 | 3 | 1 | 4.9 | 6.4 | 5.5 | 3.5 | |||
| 2 | 2 | 2 | 1 | 3 | 4.9 | 6.4 | 4.8 | 4.7 | |||
| 2 | 3 | 3 | 2 | 1 | 4.9 | 6.4 | 4.6 | 4.2 | |||
| 2 | 2 | 2 | 2 | 3 | 7 | 5.4 | 5.6 | 5.4 | |||
| 2 | 1 | 3 | 1 | 1 | 4.9 | 5.3 | 5.5 | 5.2 | |||
| 2 | 1 | 3 | 1 | 3 | 4.9 | 5.3 | 2.9 | 3.7 | |||
| 2 | 2 | 1 | 1 | 2 | 4.9 | 5.3 | 2.9 | 3.7 | |||
| 2 | 1 | 3 | 2 | 1 | 4.9 | 5.2 | 5.2 | 5.3 | |||
| 2 | 1 | 3 | 1 | 1 | 3.8 | 5.2 | 4.6 | 4.2 | |||
This Course's Industry Focus Laundromats in the US
