subject
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

ansver
Answers: 2

Another question on Engineering

question
Engineering, 03.07.2019 14:10
Line joining liquid phase with liquid and solid phase mixture is known as: a) liquidus b) solidus c) tie line d) none of the mentioned
Answers: 2
question
Engineering, 04.07.2019 18:10
The filament of an incandescent lamp has a temperature of 2000k. calculate the fraction of radiation emitted in the visible light band if the filament is approximated as blackbody
Answers: 2
question
Engineering, 04.07.2019 18:10
Shafts are machine elements that are used to a) carry axial loads b) direct shear loads c) transmit power d) rotate at constant speed e) none of the above circular and square shafts subjected to the same torque under the same circum behave a) the same way b) almost the same way
Answers: 2
question
Engineering, 04.07.2019 18:10
The higher the astm grain size number, the finer the gran is. a)-true b)-false
Answers: 2
You know the right answer?
What follows is a list of functions and descriptions of their behavior you may find useful in produc...
Questions
question
Mathematics, 04.12.2019 18:31
question
Mathematics, 04.12.2019 18:31
Questions on the website: 13722366