Creating Pivot Tables for Workplace Demographics

Using Department and Left Variables

Create a pivot table for the variables ‘department’ and ‘left’ (youcan use the table created in question 1f if you wish) and use it to answer thefollowing questions. You do not need to include the table in your answer script.i. Of those who left the workplace, what percentage worked in accounting?

ii. Of those who worked in marketing, what percentage left the workplace?

iii. What percentage of employees left the workplaceandworked in account-ing?

iv. What percentage of employees left the workplaceorworked in accounting?

v. If there were an association between the variable of department worked inand the variable of leaving the workplace, what sort of thing might yousee in the percentages or proportions in the table