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
The y form of iron is known as: a) ferrite b) cementite c) perlite d) austenite
Answers: 3
question
Engineering, 03.07.2019 15:10
If you were designing a bumper for a car, would you prefer it to exhibit elastic or plastic deformation? why? consider the functions of a bumper in both a minor "fender-bender" and a major collision.
Answers: 1
question
Engineering, 03.07.2019 15:10
Ahouse has the following electrical appliance usage (1) single 40w lamp used for 4 hours per day (2) single 60w fan used for 12 hours per day (3) single 200w refrigerator that runs 24 hours per day with compressor run 12 hours and off 12 hours find the solar power inverter size in watt with correction factor of 1.25.
Answers: 1
question
Engineering, 04.07.2019 16:10
The force on a cutting tool are 2600n vertically downward and 2100 horizontal. determine the resultant force acting on the tool and the angle at which it acts.
Answers: 1
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, 07.05.2021 17:30
question
Business, 07.05.2021 17:30
question
Geography, 07.05.2021 17:30
question
Mathematics, 07.05.2021 17:30
question
Mathematics, 07.05.2021 17:30
question
Mathematics, 07.05.2021 17:30
Questions on the website: 13722360