Engineering
Engineering, 24.03.2020 05:28, melikefood01

What follows is a list of functions and descriptions of their behavior you may find useful in producing an analysis of this data. 1. isSalary employee, isHourly employee, getSalary employee and getDeparment employee: The functions isSalary, isHourly, getSalary and getDepartment access specific fields of the employee tuple and return either a boolean (in the case of the is functions) or a value (in the case of the get functions). 2. calcSalary employee: The function calcSalary calculates the annual salary, either by returning the directly recorded annual salary or calculating it by finding the average weekly salary by multiplying the hours per week by hourly wage, and then multiplying that by 52 to get the average annual salary for that hourly worker. 3. getNumberOfEmployees AllData The function getNumberOfEmployees returns the number of employees in the data set. 4. AllData The function returns the number of employees who have an annual salary in the data set 5. AllData The function returns the number of employees who are paid hourly in the data set. 6. find Highest PaidEmployee AllData The function find Highest PaidEmployee returns the name and salary of the highest paid employee. Use the computed salary for hourly employees. 7. find Highest PaidEmployeeInDept AllData DeptName The function find Highest PaidEmployee returns the salary of the highest paid employee within a specific department. Use the computed salary for hourly employees. 8.getAverageSalary AllData The function getAverageSalary calculates the average of the computed salary field. 9.getAverageSalarylnDept AllData DeptName The function getAverageSalary calculates the average of the computed salary field for a specific department. The function getUnique DepartmentNames has been provided for you, searching through the data set to generate a list of department names. 10. AllData DeptNames This function computes the number of employees in every department. This function should return a list of tuples, pairs between the department name and number of employees. 11. AllData DeptNames This function computes the overall annual salary budget for every department. The calculated salary should include the average annual salary for hourly employees. This function should return a list of tuples, pairs between the department name and total annual salary. 12. find Highest PaidDept Alldata DeptNames This function returns the name and total annual salary of the department with the largest overall annual salary paid to employees in that department. The calculated salary should include the average annual salary for hourly employees. This function should return a single tuple, containing the department name and total annual salary. Enter name of the csv file containing employee data: payroll_01.csv Enter name of the department to be analyzed: POLICE # of employees: 30 # of employees in POLICE: 15 % of employees Salaried: 23 (76.67%) % of employees Hourly: 7 (23.33%) Average salary: 88614.19 Average salary in POLICE: 83084.80 Largest salary: PETER C CUNNINGHAM JR paid 132732.00 annually Largest salary in POLICE: 107988.00 ** Histogram of employees by department (each star represents 5 employees): AVIATION: 2 CITY COUNCIL: 1 DOIT: 1 FAMILY & SUPPORT: 1 FIRE: 4 GENERAL SERVICES: 2 OEMC: 1 POLICE: ***15 STREETS & SAN: 1 WATER MGMNT: 2 9-6060-88800 11 (36 ** Salary Ranges: 0-60000 : 3 (10.0%) 60000-80000 : 7 (23.33333333%) 80000-100000: 11 (36.66666667%) 100000-120000: 7 (23.33333333%) > 120000: 2 (6.666666667%) ** Histogram of Salary Ranges (each star represents 10 employees): <60000: 3 60-80k: 7 80-100k: *11 100-120k: 7 >128000: 2

answer
Answers: 2

Other questions on the subject: Engineering

image
Engineering, 03.07.2019 15:10, brooklyn674
Apiston-cylinder with a volume of 0.25 m3 holds 1 kg of air (r 0.287 k/kgk) at a temperature of 100 c. heat transfer to the cylinder causes an isothermal expansion of the piston until the volume triples. how much heat is added to the piston-cylinder?
Answers: 3
image
Engineering, 04.07.2019 18:10, mm016281
What difference(s) did you notice using a pneumatic circuit over hydraulic circuit. explain why the pneumatic piston stumbles when it hits an obstacle.
Answers: 2
image
Engineering, 04.07.2019 18:10, 19deleonl
Coiled springs ought to be very strong and stiff. si3n4 is a strong, stiff material. would you select this material for a spring? explain.
Answers: 2
image
Engineering, 04.07.2019 18:10, sarahgrindstaff123
Afluid flows with a velocity field given by v=(x/t)i.. determine the local and convective accelerations when x=3 and t=1.
Answers: 2
Do you know the correct answer?
What follows is a list of functions and descriptions of their behavior you may find useful in produc...

Questions in other subjects:

Konu
Mathematics, 20.10.2020 21:01