summary statistics for wages Bell

summary statistics for wages Duarte

8. Compare the mean salaries of Bell and Duarte public employees by position titles.

9. Do police office on average get paid well in the city of Bell? What about officers who assume higher ranking positions?

10. Compare the average salary of a city council members in both cities. What do you notice? Usually, city council members get paid nominal amount of money for their public service. Use the output you obtained in question 8 to answer this question.

11. Now, look for the city managers salaries in each city and change those salaries to standardized z-scores, meaning find out how many standard deviations away the city manager salary is from the mean? z-score = (city manager salary mean)/standard deviation. When the z-score is more than 3, we say the data value is very unusual.

a) For the city of Bell, how many standard deviations is the city manager salary above the mean?

b) For the city of Duarte, how many standard deviations is the city manager salary sbove the mean?

c) City managers could make salaries that are three or four times above the mean. Do you get suspicious here about any of the two city managers? Which one? And why?

plz answer all the question , thanks

Summary statistics for Wages Bell: Group by: Position Bell Position Bell Mean Account Clerk 47587.333 104406 Accounting Manager Assistant Chief of Police 147821 Assistant City Manager 562538 Assistant to Food Bank Coordinator 110053 Business Development Coordinator 159033 Business License Officer 15071 Chief of Police 185809 1171423 City Manager Code Enforcement Officer Community Services Technician 35113.667 47887 Council 111832.5 164583 Deputy City Engineer Director of Administrative Services Director of Community Services 253774 184176 Director of Community Services 184176 Director of General Services 244849 74657.5 32500 Dispatcher Filing Officer Housing Rehabilitation Technician Housing Specialist Management Analyst Motor Officer 64552 87657 60674.333 65153 Office Assistant 30385.667 60387 Office Coordinator Parking Enforcement Officer Police Captain Police Chief 51453 131450 109163 100653.67 Police Detective Police Dispatcher Police Lieutenant 61592.75 76246 Police Motor Officer Police Officer 102106 92356.708 Summary statistics for Wages_Duarte: Group by: Position Duarte Position Duarte Mean Accountant 61461 60032 Accounting Specialist Administrative Secretary Assistant Boxing Trainer 48319.2 11992.5 132562 Assistant City Manager Assistant Civil Engineer 72665 Assistant Planner 29479 Boxing Trainer 18657 Bus Driver 18716.857 City Engineer 20580 215466 10194 City Manager Clerk Typist/Receptionist Clerk/Typist Receptionist Code Compliance/Animal Control Officer Community Services Officer 33715 60848 15819.667 Community Services Officer 15819.667 Councilmember 13717.333 Crime Prevention Specialist 60025 Custodian 18903.308 98430 129298 125113 98714 16147 Deputy City Manager Director of Community Development Director of Public Safety Services Engineering Division Manager Fee and Charge Instructor Field Services Manager Field Services Supervisor Human Resources Analyst Human Resources Manager Irrigation Control Technician Lead Driver 102490 66878 56400 77250 53847 52948 Planning Intern 13318 Promise Fellows 12620 00070 Tier Services Supervisor 56400 Human Resources Analyst Human Resources Manager 77250 53847 Irrigation Control Technician Lead Driver 52948 Planning Intern 13318 Promise Fellows 12620 Recreation Coordinator 30527 Recreation Leader 12071 97147 Recreation Superintendent Recreation Supervisor Redevelopment Coordinator 65211.25 55845 Senior Custodian 45081 53642.333 Senior Maintenance Technician Senior Maintenance Technician Electrician 55597 Senior Planner 90249 Transit Supervisor 82606 Police Captain 131450 Police Chief 109163 Police Detective 100653.67 Police Dispatcher 61592.75 Police Lieutenant 76246 Police Motor Officer 102106 Police Officer 92356.708 Police Sergeant 121016 Recreation Aide 15709.6 Recreation Attendant 13090.9 Recreation Leader 22461 25903 55993 Recreation Programmer Recreation Supervisor Senior Code Enforcement Officer Senior Management Analyst Senior Recreation Supervisor 77107 80060 90806.5 Summary statistics for Wages Bell: Group by: Position Bell Position Bell Mean Account Clerk 47587.333 104406 Accounting Manager Assistant Chief of Police 147821 Assistant City Manager 562538 Assistant to Food Bank Coordinator 110053 Business Development Coordinator 159033 Business License Officer 15071 Chief of Police 185809 1171423 City Manager Code Enforcement Officer Community Services Technician 35113.667 47887 Council 111832.5 164583 Deputy City Engineer Director of Administrative Services Director of Community Services 253774 184176 Director of Community Services 184176 Director of General Services 244849 74657.5 32500 Dispatcher Filing Officer Housing Rehabilitation Technician Housing Specialist Management Analyst Motor Officer 64552 87657 60674.333 65153 Office Assistant 30385.667 60387 Office Coordinator Parking Enforcement Officer Police Captain Police Chief 51453 131450 109163 100653.67 Police Detective Police Dispatcher Police Lieutenant 61592.75 76246 Police Motor Officer Police Officer 102106 92356.708 Summary statistics for Wages_Duarte: Group by: Position Duarte Position Duarte Mean Accountant 61461 60032 Accounting Specialist Administrative Secretary Assistant Boxing Trainer 48319.2 11992.5 132562 Assistant City Manager Assistant Civil Engineer 72665 Assistant Planner 29479 Boxing Trainer 18657 Bus Driver 18716.857 City Engineer 20580 215466 10194 City Manager Clerk Typist/Receptionist Clerk/Typist Receptionist Code Compliance/Animal Control Officer Community Services Officer 33715 60848 15819.667 Community Services Officer 15819.667 Councilmember 13717.333 Crime Prevention Specialist 60025 Custodian 18903.308 98430 129298 125113 98714 16147 Deputy City Manager Director of Community Development Director of Public Safety Services Engineering Division Manager Fee and Charge Instructor Field Services Manager Field Services Supervisor Human Resources Analyst Human Resources Manager Irrigation Control Technician Lead Driver 102490 66878 56400 77250 53847 52948 Planning Intern 13318 Promise Fellows 12620 00070 Tier Services Supervisor 56400 Human Resources Analyst Human Resources Manager 77250 53847 Irrigation Control Technician Lead Driver 52948 Planning Intern 13318 Promise Fellows 12620 Recreation Coordinator 30527 Recreation Leader 12071 97147 Recreation Superintendent Recreation Supervisor Redevelopment Coordinator 65211.25 55845 Senior Custodian 45081 53642.333 Senior Maintenance Technician Senior Maintenance Technician Electrician 55597 Senior Planner 90249 Transit Supervisor 82606 Police Captain 131450 Police Chief 109163 Police Detective 100653.67 Police Dispatcher 61592.75 Police Lieutenant 76246 Police Motor Officer 102106 Police Officer 92356.708 Police Sergeant 121016 Recreation Aide 15709.6 Recreation Attendant 13090.9 Recreation Leader 22461 25903 55993 Recreation Programmer Recreation Supervisor Senior Code Enforcement Officer Senior Management Analyst Senior Recreation Supervisor 77107 80060 90806.5