1. Download UNC_Salares_NandO_2015-05-06.csv
2. Answer these questions:
- How many columns are there?
- How many employees are in the database?
- What is the cell address of Susan King’s total salary?
- Who gets paid the most?
- Who gets paid the least?
- What is the total amount that UNC-CH employees get paid?
- What is the average total salary?
- What is the median total salary?
- How much more does the dean of JOMC make than the dean of Summer School?
- How much do all deans make?
- Whose non-state salary is highest, as a percentage of total salary?
- What is the average age of all employees?
- Among full-time, 12-month employees how many times more per month does the highest paid employee make than the lowest paid? What’s the reverse – the lowest paid employee’s monthly salary is what percentage of the highest paid?
- Who makes the most for their level of effort? (months and FTE status)?
- How many people work in housekeeping?
- What’s the total amount that UNC-CH pays people who work in housekeeping?
- What’s the average salary of someone that works in housekeeping?
- How many different departments are there?
- How many employees does each department have?
- What is the total amount that each department spends in salaries?
- Which department has the highest average salary?
- How many people of each age are there?
- What’s the average salary for each age?
- Split the names into two columns
- Put the date in MM/DD/YYYY format in a new field with the “Date” data type