Utilizing the data set "Analyzing San Francisco Salary Data" from the case studies file, I answered these four questions.
Who were the top five earners in 2011 in the category of Base Pay?
- a. John J Loftus - $274,127
- b. Naomi M Kelly - $270,642
- c. Barbara A Garcia - $270,591
- d. George Gascon - $252,221
- e. Kenneth A Lombardi - $239,247
Create a calculated field named "% Other Pay", which is comprised of "Other Pay/Total Pay", and show which job titles made only "Other Pay" in 2012.
| Job Titles | Sum of Other Pay | Sum of Total Pay | Sum of % Other Pay |
|---|---|---|---|
| Warehouse Worker | $3,370 | $3,370 | 100.0% |
| Representative, Human Rights Commission | $88 | $88 | 100.0% |
| Principal Real Property Officer | $2,193 | $2,193 | 100.0% |
| Industrial Injury Investigator | $2,816 | $2,816 | 100.0% |
| Carpenter Supervisor 2 | $50 | $50 | 100.0% |
| Captain, (Fire Department) | $35,333 | $35,333 | 100.0% |
| Assistant Recreation Director | $2,173 | $2,173 | 100.0% |
| Auto Svc Wrk Asst Sprv | $3,773 | $3,773 | 100.0% |
In 2012, out of the employees who made $100k or more, which employee earned more than 50% of their pay from "Other Pay"?
- a. Anna L Cuthbertson - $116,478 - 51%
In 2012 and 2013, how many employees held some sort of "Curator" position? Of those employees, who earned the top average base pay? Clear all filters and pull in Job Category and Job Title as row labels (Titles sorted alphabetically), then group any titles including the word "Curator" into a new category called "Curator". How many employees held some sort of Curator position in either 2012 or 2013? Among those, who earned the highest average base pay?
| Job Group: Curator | Employee Name | Sum of Base Pay |
|---|---|---|
| Curator 3 | Dennis G Sharp | $81,066 |
| Curator 4 | Sonya Knudsen | $75,891 |
| Curator 3 | Allison Cummings | $75,790 |
| Curator 3 | Ramekon O'Arwisters | $74,076 |
| Curator 3 | Robert D Harris | $72,816 |
| Curator 3 | Dennis Sharp | $72,363 |
| Curator 1 | Ann H.A. Carroll | $62,901 |
| Curator 1 | Aimee Le Duc | $54,150 |
| Curator 1 | Allison Harding | $25,247 |
| Top Five "Base Pay" Earners | Only "Other Pay" Earners | > 50% "Other Pay" Earners | Top "Curator" Earners |
|---|---|---|---|
 |
 |
 |
 |