Question: In a separate table ( below the given raw data table ) , calculate the Sum, Average, Maximum, Minimum & percentage ( % ) Salary
In a separate table below the given raw data table calculate the Sum, Average, Maximum, Minimum & percentage Salary for Each Department.
a Write the Department, Sum, Average, Maximum, Minimum & percentage Salary as Column heading.
b Write Department names under Department column.
c Compute Sum, Average, Maximum and Minimum for each department.
d Compute Sum of the salaries for all departments at the end of the Sum column in other words, total salaries for all the departments
e Compute percentage Salary of each department as Sum of Salary for the department divided by Total of Salaries for all departments.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
