90.2K

Verified Solution

Link Copied!

its a Excel thing if you know how to do it just show me an example with any digit.

ASAP

fapn Styles Question 5 (25 marks): Part A (15 Marks): Insert a Pivot Table based on the changes you made above to the Recruiting Data tab so that you can create the following 3 report tables (each table can be a separate table based on data you get from the pivot table). Each table should show the breakdown of all staff and the % breakdown) from your dataset broken down by each of the 3 following fields: Salary Ranges Gender Placement Source General Part B (10 marks): Using all staff, create a table that shows the number of staff and % breakdown of staff by Gender and Salary Ranges and the % Point difference between Gender. Your table should use the vertical axis for your Salary Ranges and the horizontal Axis for your gender breakdown. Be creative as to how you show this breakdown, but make it easy to read and understand fapn Styles Question 5 (25 marks): Part A (15 Marks): Insert a Pivot Table based on the changes you made above to the Recruiting Data tab so that you can create the following 3 report tables (each table can be a separate table based on data you get from the pivot table). Each table should show the breakdown of all staff and the % breakdown) from your dataset broken down by each of the 3 following fields: Salary Ranges Gender Placement Source General Part B (10 marks): Using all staff, create a table that shows the number of staff and % breakdown of staff by Gender and Salary Ranges and the % Point difference between Gender. Your table should use the vertical axis for your Salary Ranges and the horizontal Axis for your gender breakdown. Be creative as to how you show this breakdown, but make it easy to read and understand

Answer & Explanation Solved by verified expert

See Answer