Business Finance Homework Help

I WILL SEND VIDEOS of the formulas (I don’t want anything too advanced that we did not go over in class)

Please download the dataset at this link.T hese data are City of Los Angeles payroll data from 2013-2016. Each row in the dataset includes information on payments made to individuals who work for the City. Other data attributes include department titles, job titles, projected annual salaries (with breakdowns of quarterly pay), bonuses, and benefits information. You will need to create a new worksheet in the provided workbook to conduct your analyses.

---

Using what you have learned about data analysis in Excel, please answer the following questions. Include a brief explanation for your answers including the steps you took in Excel to perform your analysis. If you encounter problems with the datasets (inaccurate data, missing data, etc.), provide a narrative explanation of how you overcame those problems. Note – there is no single “right” answer to these questions. However, you should use the Excel formulas and functions we have learned plus your analytical skills to produce answers to these questions.

1. (3 pts) How do benefits and salaries differ for employees across departments (mean, median)? *Note: (You do not need to compare all departments but you should include three or more departments in your analysis)
2. (3 pts) Are there any unusually large differences between the lowest and highest employee salaries? You can compare across departments or across job classes.
3. (3 pts) How have salaries changed from 2013-2016?
4. (3 pts) Have the costs of benefits changed dramatically during the data collection period?
5. (3 pts) How do payments differ between quarters (i.e. Q1, Q2, etc)?

---

Turn in

At the completion of the exercise, please turn in the following:

• Excel workbook with original data and calculations
• Word document with answers to the five questions above including a brief description of your analysis in Excel