| | | Responses | Responses |
| | Insert a new sheet titled San Francisco Salaries |
| | Important data into the above sheet from San Francisco Salaries.txt |
| | Format appropriately |
| | Insert a column in H titled Total Pay & Benefits |
| | Populate this column with the total of base pay, OT, Other pay, and benefits |
| | In column M create a formula to determine the Base Pay as a percent of Total Pay & Benefits |
| | In 2011, what job title had the most employees & how many were there? |
| | How many total employees were there in 2011? |
| | How many total employees were there in 2014? |
| | In 2012, what was the Average Base pay as a percent of total pay & benefits for the Accountant II position? |
| | In 2013, which individual (name) had the highest total pay & benefits? |
| | In 2013, which job title had the highest average total pay & benefits? |
| | In 2012, which job title had the highest average of OT pay? |
| | In 2012, which job title had the highest average Other pay? |
| | In 2014, which Part Time (PT) job title had the highest total pay & benefits and how much was it? |
| | In 2014, which Full Time (FT) job title had the highest total pay & benefits and how much was it? |
| | In 2014, how many Full Time (FT) Pharmacist were employed? |
| | In 2014, how many Part Time (PT) Storekeepers were employed? |
| | In 2014, what was the average (FT) Lieutenant, Fire Suppression average base pay as a percent of total pay? |
| | All years combined, how much was paid in all forms to custodians? |
| | In 2013, who was the highest total paid Accountant IV and what was the total pay? |
| | In 2014, what was Michael R Rottmayer's % base pay as a percent of total? |
| | In 2014, how many full time employees were there? |
| | In 2014, how many part time employees were there? |
| | All years combined, what percent of the total pay & benefits went to Firefighters? (one decimal place) |
| | All years combined, how much was paid to all positions? |
abparsley
SanFranciscoSalariesStudent1.xlsx
